ORA - 12514 TNS: listener does not currently know of the service requested in the connect descriptor
) what is the problem, how to solve it, ask the great spirit guide!!!!!

CodePudding user response:

Are you OracleOraDb11g_home1TNSListener service has not started? If not, you can try to reconfigure the listeners, http://jingyan.baidu.com/article/8cdccae99a754b315413cd8f.html

CodePudding user response:

LSNRCTL status view listening state
LSNRCTL start starts listening (don't start to launch)
LSNRCTL stop stop listening

CodePudding user response:

See if listening to start
Check the TNSNAME configuration is correct? TNSPING

CodePudding user response:

The

reference 3 floor sych888 response:

see if listening to start
Check the TNSNAME configuration is correct? TNSPING

Tnsping without the problem, he will check the IP and port, and will not check service

His error is service

Look at the service of the database configuration, monitoring the service name, such as the service name inside the TNS matches

CodePudding user response:

The small white to learn