This content has been marked as final. Show 5 replies
user633278 wrote:open Command Window & do EXACTLY as below; line for line
I have hit a problem with my oracle development database.
When in sqlplus I executed the shutdown command, but nothing happened for several minutes and it was just hanging. No messages were displayed to the screen. The only thing was to close the command window. When I open sqlplus again and enter in the user name password as sysdba I am getting ORA 12514 TNS Listener could not resolve service in descriptor. This is odd as I could log on before and use the database. So I thought that the services were still shutting down I waited, and using the Windows snap on tool for Oracle 11g, I restarted the services on the database, but this has had no effect.
Even using EM made no difference because I couldn't log on to perform a startup or recovery.
So, please does anyone know how I can fix this?
/ as sysdba
COPY command & results from above then PASTE all back here
In order to help you. sb wants to get accurate information. When you just write the question, there is too much chance of making a mistake. For example, TNS errors include ORA-12514, -12415, -12145 and -12154.
The 12514 you mention implies the alias after the @ is down, since the listener does not klnow of that iservice.
So you entered an alias for a service that was down (or possibly removed) - the TNSNAMES.ORA entry was found and pointed to a listener, but the instance is not registered to the listener, so thelistener can not conect.
Without additional accurate information, such as could be provided by copy/paste of screen info of the instance startup, we can only guess as to what might be happening in your environment.
Edited by: Hans Forbrich on Feb 22, 2012 3:48 PM