Problem to connect direct my program with Oracle 9.2.0.5 for UNIX

Problem to connect direct my program with Oracle 9.2.0.5 for UNIX

Postby 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
Alberto
 
Posts: 3
Joined: Thu 26 Oct 2006 09:22

Postby Alexey » Thu 26 Oct 2006 09:50

Please specify the connection string you are using to connect to your server.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alberto » Thu 26 Oct 2006 10:34

The connection string is:

"Data Source=cluster;User Id=USUARIO;Sid=orcl;Password=xxx; Direct=true"
Alberto
 
Posts: 3
Joined: Thu 26 Oct 2006 09:22

Postby 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
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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.
Alberto
 
Posts: 3
Joined: Thu 26 Oct 2006 09:22

Postby Alexey » Fri 27 Oct 2006 06:28

You're welcome.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle