Oracle Database ORA-12514 Error Resolution

Question Prompt

Error tip: Error:ora-12514:tns:listener could not resolve service_name given in Connect

Workaround:

The code is as follows	Copy Code
1. Open the <oraclehome>/network/admin/listener.ora file and find: Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = Plsextproc) (Oracle_home = d:oracleproduct10.1.0db_1) (program = Extproc) ) )

2. Add:

The code is as follows	Copy Code
(Sid_desc = (Global_dbname = ORACLE) (Oracle_home = d:oracleproduct10.1.0db_1) (Sid_name = ORACLE) )

3. Finally becomes:

The code is as follows	Copy Code
Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = Plsextproc) (Oracle_home = d:oracleproduct10.1.0db_1) (program = Extproc) ) (Sid_desc = (Global_dbname = ORACLE) (Oracle_home = d:oracleproduct10.1.0db_1) (Sid_name = ORACLE) ) )

4. Save the file and restart the tnslistener,ok! in the service

Note that you must restart the Tnslistener,

Method: Command mode

The code is as follows	Copy Code
C:>lsnrctl Lsnrctl>stop Lsnrctl>start

It's done.

Another way out of this problem is: ora-12514:tns: No Listener

Solution: Tnslistener Service is not started, the service can be started.
The usual name: Oracleoradb10g_home1tnslistener:
The service corresponds to the%oracle_hoembintnslsnr.exe
Ora-12514:tns: The listener is currently unable to recognize the service requested by the link descriptor.
For this error, the online approach is usually this:
Open:%oracle_hoem%/network/admin/listener.ora file
In

The code is as follows	Copy Code
Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = Plsextproc) (Oracle_home = d:oracleoracle10g) (program = Extproc) )

Add later:

The code is as follows	Copy Code
(Sid_desc = (Global_dbname = ORACLE) (Oracle_home = d:oracleoracle10g) (Sid_name = ORACLE) )

Finally becomes:

The code is as follows	Copy Code
Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = Plsextproc) (Oracle_home = d:oracleoracle10g) (program = Extproc) ) (Sid_desc = (Global_dbname = ORACLE) (Oracle_home = d:oracleoracle10g) (Sid_name = ORACLE) ) )

But I don't think it's so strenuous. Turn off the listener service first, then close the database service, start the database service, and start the listener service. It's so simple.