Re: Connect to Remote oracle DB

What is in your $db_string? I'm concerned that the ID / password / ORACLE_SID string may be malformed. That's particularly true if you aren't used to accessing remote Oracle databases.

Posting it, with password and ORACLE_SID replaced, would help.

Comment on Re: Connect to Remote oracle DB

Replies are listed 'Best First'.
Re^2: Connect to Remote oracle DB by charithd (Acolyte) on Feb 14, 2012 at 04:30 UTC
Thanks you very much for you all to great quick replies. I have oracle client installed in my host and I already have set TNS record and through that I can connect to my remote db. But I just wanted to ssh remote db host and execute sqlplus from that point.because I can't get set oracle client and tns on every host that I going to run my script.same as DBI module. if there any way to use this module without installing,I mean as portable module so I can send module and script as one package so no dependencies. Thanks again.	[reply]

Replies are listed 'Best First'.

Re^2: Connect to Remote oracle DB
by charithd (Acolyte) on Feb 14, 2012 at 04:30 UTC

Thanks you very much for you all to great quick replies. I have oracle client installed in my host and I already have set TNS record and through that I can connect to my remote db. But I just wanted to ssh remote db host and execute sqlplus from that point.because I can't get set oracle client and tns on every host that I going to run my script.same as DBI module. if there any way to use this module without installing,I mean as portable module so I can send module and script as one package so no dependencies. Thanks again.

[reply]