in reply to Oracle hangs at connect

Can you provide the connect description you give to sqlplus (minus the auth info, of course)? I'm taking a wild guess here, but I don't think that you're using both the host name and the SID... probably just using a TNS name (which maps, via either your $ORACLE_HOME/tnsnames.ora, or via an oranames server listed in your $ORACLE_HOME/sqlnet.ora, to a host, SID, and port number).

Anyway, my best guess for what to try is: drop the host=$host and the sid=$sid, and instead make your DSN just be: DBI:Oracle:$tnsname. That's what I always do.

Oh, and as to why this will work with one database and not with another... well, the different databases maybe differently configured on either your oranames server or on the sqlnet client's tnsnames.ora file.

update: that should be $ORACLE_HOME/network/admin/tnsnames.ora (and sqlnet.ora). Sorry, I typed too fast :-) 

------------
:Wq
Not an editor command: Wq

[download]

Replies are listed 'Best First'.
Re^2: Oracle hangs at connect
by DrManhattan (Chaplain) on Aug 09, 2004 at 16:59 UTC
[reply]

In Section Seekers of Perl Wisdom