Page 1 of 1

Problem to connect direct my program with Oracle 9.2.0.5 for UNIX

Posted: Thu 26 Oct 2006 09:33
by Alberto
Hello,

I have a problem to connect direct my program with 9.2.0.5 Oracle DB for Unix 3.50.12.0.
I got to connect them if I install the oracle client but without it it hasn't
been impossible.

The error showed when it tries to connect, it was "not exists TCP:Listener" or something similar.

I need your help because I don't know more things to try.

Thanks in advance,

Alberto

Posted: Thu 26 Oct 2006 09:50
by Alexey
Please specify the connection string you are using to connect to your server.

Posted: Thu 26 Oct 2006 10:34
by Alberto
The connection string is:

"Data Source=cluster;User Id=USUARIO;Sid=orcl;Password=xxx; Direct=true"

Posted: Thu 26 Oct 2006 12:43
by Alexey
Check your connection parameters:
  • check letter case
  • check your SID (must equal to SERVICE_NAME from tnsnames.ora file)
  • set the Port
  • cluster must be the name of the PC where Oracle server resides
  • this can be the problem with 2 cluster database settings

Posted: Thu 26 Oct 2006 16:29
by Alberto
I could connect it.

The problem was the port, it was different of the default port (1521) and I didn't add it to the string connect.

Thank you very much for all.

Posted: Fri 27 Oct 2006 06:28
by Alexey
You're welcome.