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 1. Open <oraclehome>/network/admin/listener.ora file, 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 follows Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = plsextproc) (Oracle_home = d:oracleproduct10.1.0db_1) (PROGRA M = 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. 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 follows Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = plsextproc) (Oracle_home = d:oracleoracle10g) (program = EXTP ROC)))
Add later:
The code is as follows (Sid_desc = (global_dbname = Oracle) (Oracle_home = d:oracleoracle10g) (sid_name = Oracle))
Finally becomes:
The code follows Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = plsextproc) (Oracle_home = d:oracleoracle10g) (program = EXTP ROC)) (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.