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.