Return
-
Title
How to troubleshoot ORA-12154 and ORA-12505 Connection Issues? -
Description
How to troubleshoot ORA-12154 and ORA-12505 Connection Issues?
-
Resolution
Resolution:
1. Check the System Requirements for supported client and server versions:
http://www.quest.com/toad-for-oracle/release-information.aspx
NOTE: Please check release notes for more detail information
2. Verify that your OS user is a Windows Power User and have read/write privileges to the Oracle home directories. Also verify you have read access to the Oracle client folders.
NOTE: In certain environments, you may need to select the Toad shortcut icon | right click and choose “Run as Administrator.”
3. Verify you can ping the server and tnsping the database instance
Go to Windows Start | Run and type cmd for command prompt
-Type: PING <hostname> press return for result.
-Type: TNSPING <instance> press return key for result
4. Check your Oracle listener status to make sure it is up and running correctly.
Go to Start | Run | type “lsnrctl status”. For more commands, type “lsnrctl help”.
5. Verify that you are able to connect via Oracle’s SQL*Plus either from SQL*Plus GUI or command line.
NOTE: SQL*Plus does not use SQLNet as a method of connection like Toad for Oracle, however it is a good test just to make sure you are able to established a connection from your PC. If you are unable to connect using Oracle’s SQL*Plus, then most likely you are not be able to connect in Toad for Oracle. Please contact Oracle support or reinstall you Oracle client.
6. Verify you are using the correct tnsnames.ora file
Locate the tnsnames.ora file you would like to use and copy the location path
Right click on My Computer | Properties | Advanced tab | click Environment Variables
-Under System Variables: click New
-For Variable name type: TNS_ADMIN
-For Variable value type: type or paste the entire path where your tnsnames.ora file is located
7. If your Sqlnet.ora file contains NAMES.DEFAULT_DOMAIN entry but the tnsnames.ora aliases does not show proper NAMES.DEFAULT_DOMAIN extension, you may want to try the following:Add NAMES.DEFAULT_DOMAIN extension for the aliases in the tnsnames.ora file to match your sqlnet.ora.E.g. If NAMES.DEFAULT_DOMAIN = ORACLE.CORP exists in sqlnet.ora, then make sure ORACLE.CORP is add to aliases to getTOAD.ORACLE.CORP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOST1234)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORACLE11G)
)
)
8. Verify that you using the correct valid Oracle home in Toad for Oracle.
-Under the Installed Clients, click on the ellipses icon to open the Oracle Home Editor and determine the correct Oracle home
-Under the Installed Clients, click on the Connect Using dropdown and select the correct valid Oracle home
-
Attachments
-
Additional Information
Please see attachment ORA-12154 and ORA-12505 Connection Issues.doc for complete documentation including screenshots.