Re: ORA-12170: TNS:Connect timeout occurred

What an interesting and smart thought! You are right: when I use sqlplus with the a/b_at_c syntax, I have the same problem: it just hangs there until it quits with a timeout message. And thanks to your suggestion I found the problem: I changed the tnsnames.ora file: I changed HOST=xxx into HOST=localhost. And it works perfectly!!!! Thank you for your help!

Anke

joel garry wrote:
> Hmmm... could this mean that perl is using the network to try to
> connect, as opposed to the local bequeath connection?
>
> Try using sqlplus to connect using the a/b_at_c syntax. On my peecee with
> XE, XE added an entry like
> XE =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX)(PORT = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = XE)
> )
> )
>
> (where the x'd out part is my hostname, of course). This might give a
> clue as to what perldbi wants, assuming it wants to do everything
> network-like.
>
> Or, modify tnsnames.ora for the local connection to use BEQ, search for
> that in the net services admin guide
> http://download-west.oracle.com/docs/cd/B19306_01/network.102/b14212/troublestng.htm
> and
> http://download-west.oracle.com/docs/cd/B19306_01/network.102/b14268/asoappa.htm
> and see metalink Note:69725.1 (apologies if any of this is bogus since
> I haven't done much on O10). Note the adapters command shows what
> protocols you can use.
>
> > specified). So, DBI understands my xxx SID. The error is not caused
> > by a busy network because I am connecting locally, and sqlplus is able
> > to connect.
> >
>
> jg
> --
> @home.com is bogus.
> Linus surprised at resilience of linux kernel:
> http://www.zdnet.com.au/news/software/soa/Torvalds_surprised_by_resilience_of_2_6_kernel/0,130061733,339273095,00.htm
Received on Thu Jan 18 2007 - 09:59:12 CST