| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Still Problem with ORA-12514
Do you have identical TNSNAMES.ORA files in both ORACLE_HOMEs?
Have you done a
ps -ef | grep ora
to see if the instance is started?
This error is caused either by a bad SERVICE_NAME in the TNSNAMES.ORA file or else because the instance is not started.
"ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Cause: The service name specified in the connect descriptor is
incorrect, or the database service is not registered with the
listener.
Action: Perform these steps:
1. Check to make sure the SERVICE_NAME specified in the
connect descriptor is correct.
2. Ensure the database instance is running. If the instance
not running, start it so that it can register with the listener.
You can use the Listener Control utility SERVICES command to see
what services are currently registered with the listener. "
You can check the LISTENER by going to the command line at
ORACLE_HOME/bin and entering
lsnrctl services
If you don't see an entry for CMS then enter
lsnrctl reload
and then
lsnrctl services.
HTH
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: tday6_at_csc.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 05 2002 - 14:35:27 CST
 |
 |