How to solve the 12514 error in oracle

Method: 1. Open the "listener.ora" file, add the "...ORACLE_HOME = D:oracleproduct10.1.0db_1..." code in "SID_LIST_LISTENER" and save it; 2. Restart the TNSListener service It can be solved.

The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.

How to solve the 12514 error in oracle

Problem prompt Error prompt: ERROR:ORA-12514:

TNS:listener could not resolve SERVICE_NAME given in connect

Solution:

The code is as follows

1. Open the /network/admin/listener.ora file and find:

Add: The code is as follows

Finally becomes:

The code is as follows

2 ,. Save the file and restart TNSListener in the service, OK!

Note, be sure to restart TNSListener,

Method: Command mode

The code is as follows

C:>lsnrctl
LSNRCTL>stop
LSNRCTL>start

Get it done, it works.

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to solve the 12514 error in oracle. For more information, please follow other related articles on the PHP Chinese website!