Question Prompt
Error tip: Error:ora-12514:tns:listener could not resolve service_name given in Connect
Workaround:
The code is as follows
1. Open the/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
(Sid_desc =
(Global_dbname = ORACLE)
(Oracle_home = d:oracleproduct10.1.0db_1)
(Sid_name = ORACLE)
)
3. Finally becomes:
The code is as follows
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
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
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Plsextproc)
(Oracle_home = d:oracleoracle10g)
(program = Extproc)
)
Add later:
The code is as follows
(Sid_desc =
(Global_dbname = ORACLE)
(Oracle_home = d:oracleoracle10g)
(Sid_name = ORACLE)
)
Finally becomes:
The code is as follows
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.