Return
-
Title
ORA-12154: TNS:could not resolve the connect identifier specified -
Description
When attempting to establish a connection to an Oracle Database using either Quick Connect or the Active Roles Synchronization Service, the following error is received:
ORA-12154: TNS:could not resolve the connect identifier specified
-
Resolution
Verify a TNSNames.ora file exists on the QuickConnect/Active Roles Synchronization Service server
- By default, the TNSNames.ora file resides in <OracleInstallDirectory>\network\admin
- If the TNSNames.ora file does not exist, reference the following guide on how to create one:
- https://oracle-base.com/articles/misc/oracle-network-configuration
Set the TNS_Admin environment variable if it is not set
- Navigate to Control Panel > System
- Select Advanced System Settings
- In the Advanced tab, select Environment Variables
- Under System Variables, click New
- In the Variable name text box, type TNS_ADMIN
- In the Variable value text box, type the location of the TNSNames.ora file
- Click OK to add the variable
- Restart the server