Later after the query is because the server listener. Ora configuration is localhost, will he change to the server computer name,
And restart the TNSlistener service, connect again found the mistake: ORA - 12514: TNS: listener does not currently know of the service requested in the connect
Descriptor
I finally found PLSQL connection with server database, and then through the instantclient remote connection was no problem, I want to ask next what reason is this? And I found that to restart TNSlistener service again, was unable to connect again, and in the server use the instantclient command line also unable to connect, it is based on the instantclient PLSQL, morally zha only in PLSQL connected to the database, to normal,
CodePudding user response:
If PLSQ can connect, you might suppose there should be no command line connection is not on, please refer to the following screen:Restart after listening, check the monitoring state (command: LSNRCTL status), whether listening has been registered, dynamic monitor automatically registered over a period of time,
After listening to register again using the command line or PLSQL connection,
Dynamic monitoring in addition to automatically register, can also be used manually register, please sign in to baidu command,
CodePudding user response:
The second error is because you tnsnames match wrong service name,See your description, if there is no middle steps omission, it felt like with multiple oracle software problems -- both client and server software, to connect to a remote database, one is enough, do not need to all,