Connection error to an Oracle XE database - TNS:could not resolve the connect identifier specified

Hi Anonymous ,

Here'are some solutions you can refer to:

Verify a TNSNames.ora file exists on the QuickConnect 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

Reference: ORA-12154: TNS:could not resolve the connect identifier specified (213860)

Also, you can refer to these articels:

ORA-12154: TNS could not resolve service name tips

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

ORA-12154 could not resolve the connect identifier specified

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.