TNS Listener -ORA-12514 error following database shutdown - Oracle 11g

oracle11g ora-12514
Andy5 picture Andy5 · Feb 22, 2012 · Viewed 10.9k times · Source

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?

Thanks

Answer

Jer In Chicago picture Jer In Chicago · Feb 22, 2012

May need to startup the listener: lsnrctl start

See: http://www.thegeekstuff.com/2009/05/oracle-lsnrctl-listener-shutdown-and-startup-procedures/

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
ORA-12154: TNS:could not resolve the connect identifier specified

I am trying to connect to oracle 11g installed on Linux EL 5 and and getting the following error SQL> connect sys/password@ud06 as sysdba ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor …

Read More
TNSPING OK but sqlplus gives ORA-12154?

I have Oracle 11 running on a Windows server and I'm logged onto the same server trying to use SQL Plus. When I try to connect I get a ORA-12154 even though TNSPING and various other diagnostics look OK. Can anyone …

Read More