Issues connecting to a RAC using a SID

[joness59]

We have a test RAC and one of the databases on the RAC is DEV. When I try to connect using the connect string jonesst@:: I get the error ORA-12545 Connect failed because target host or object does not exist. When I use the same connect string in SQL*Plus it works just fine. It appears PL/SQL Developer is doing something with the connect string which causes it not work. I also tried this on a single instance database and get the same results.

 

[Marco Kalter]

PL/SQL Developer does not alter the connect string. It does parse it for the username, password and database though.

You can use the EZCONNECT naming method by using the following format:

host[ort]/database

The default port number is 1521, in which case it can be omitted:

host/database

See also:

http://www.orafaq.com/wiki/EZCONNECT

Note that this still requires an Oracle Client installation, and that EZCONNECT needs to be enabled in the SQLNET.ORA file.

 

[joness59]

The format you supplied is for using the service_name, which works. However, the vendor of the software we're using requires the SID in the connect string which is host[ort]:sid and this formats fails. I do have EZCONNECT in my sqlnet.ora.

 

[Marco Kalter]

I am not familiar with this format. If you can configure your Oracle Client to use this format, it can also be used in PL/SQL Developer.