Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the problem of ora-12154: unable to parse the specified connection identifier, which has a certain reference value, and interested friends can refer to it. I hope you can learn a lot after reading this article.

When you use PL/SQL Developer to connect to the company's Oracle database, the following error message appears when you log in: ORA-12154: TNS: unable to parse the specified connection identifier. (sometimes there may not be an error dialog box, but it will not be connected, and the error dialog box shown in the following figure will pop up after several attempts. (recommended study: mysql Learning)

1. Inspection service

When this kind of problem occurs, the first thing we think of is to check whether there is a problem with the service OracleOraDb11g_home2TNSListener. Type services.msc while running, open the service window, and see if the OracleOraDb11g_homeTNSListener service is running, and if not, start it.

two。 Use SQL PLUS to test the connection.

If there are any more questions, we use SQL PLUS to test whether we can connect. Run input cmd, enter at the command prompt window

Sqlplus sys/ password @ database SID as sysdba

Such as:

Sqlplus sys/abc123@orcl as sysdba

If you can connect, the problem will be easy, indicating that there is no problem with our database instance, and the problem should lie in the configuration of the oracle client and pl/sql developer.

3. Check tnsnames.ora configuration

Under the installation path of the client, mine is D:\ oracle\ instantclient_12_1\ NETWORK\ ADMIN, and create a file called tnsnames.ora. If you have created it before, just open it and add it. Add the following to the tnsnames.ora:

SID name = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SID name)

Note that the Sid name cannot be preceded by any other characters, especially spaces!

After saving, see if you can log in. If not, click the cancel button in the login window of pl/sql developer, enter pl/sql developer, execute tools-> preferences-> connection, and configure as shown in the following figure (where the oracle home directory is the path of the oracle client).

Thank you for reading this article carefully. I hope the article "how to solve the problem of ora-12154: unable to parse the specified connection identifier" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.