Shulou(Shulou.com)06/01 Report--

ORA-12154:TNS: unable to parse the specified connection identifier

ORA-12154:TNS: no listener

Error analysis 1. If the PL/SQL client logs in to the database, there will be the above errors if the configuration is wrong, as shown in the following figure.

This error is mainly due to an error in the tnsnames.ora configuration of the pl/sql client, or an error in entering the database option.

Error analysis II. Unconfigured environment variables

So be sure to configure the environment variable TNS_ADMIN before solving the problem.

Path add; E:\ PLSQL Developer (64)\ instantclient_11_2

The environment variable is configured so that what is loaded into the tnsnames.ora file when PL/SQL Developer is opened

There are two ways to configure Database for pl/sql:

Enter database information directly in the Database option when logging in

As shown in the figure above, enter the database information ip: Port / database name directly when logging in. You must have a port, or you will report an error "No listener".

Modify tnsnames.ora

As shown in the following figure, find the installation directory of the pl/sql client, and then find the tnsmames.ora under the network/admin directory

Edit the tnsnames.ora and add the required database information at the end:

The database I configured here is named scm, and the IP address of the database server is 192.168.200.70 and the port is 1521.

Scm = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.200.70) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SCM)

Open the pl/sql client again, select the Database option of the scm just configured, and enter the user name and password. As shown in the figure:

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.