ORA-12154 or ORA-12505 appears when running the following command from the command line:
toad.exe -c "<user>/<password>@(DESCRIPTION=(LOAD_BALANCE=yes)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP-Address_1>)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=<IP-Address_2>)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=<IP-Address_3>)(PORT=1521)))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=<service name for RAC>)))"
Note: ORA-12505: TNS:listener does not currently know of SID given in the connect descriptor
ORA-12154: TNS:could not resolve the connect identifier specified
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center