Problem to connect direct my program with Oracle 9.2.0.5 for UNIX

Alberto · Post by **Alberto** » Thu 26 Oct 2006 09:33

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

Alexey · Post by **Alexey** » Thu 26 Oct 2006 09:50

Please specify the connection string you are using to connect to your server.

Alberto · Post by **Alberto** » Thu 26 Oct 2006 10:34

The connection string is:

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

Alexey · Post by **Alexey** » Thu 26 Oct 2006 12:43

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

Alberto · Post by **Alberto** » Thu 26 Oct 2006 16:29

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.

Alexey · Post by **Alexey** » Fri 27 Oct 2006 06:28

You're welcome.