Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-12514 After shutdown immediate

maddoxAug 24 2011 — edited Aug 24 2011
After a shutdown immediate, any attempt to connect to the database results in a ORA-12514 error. I can not restart the db from the command line. I can restart it by restarting the db listener. The listener log shows that the service died after the shutdown but no indication why.

I am running on Windows 2008 R2 63 bit. IPV6 has been turned off and all references are made by IP not DNS entries.
This post has been answered by Balazs Papp on Aug 24 2011
Jump to Answer

Comments

Balazs Papp
After a shutdown immediate, any attempt to connect to the database results in a ORA-12514 error.
absolutely normal, since you shut down the database, and its not running
I can not restart the db from the command line.
how did you try? whats the error?
I can restart it by restarting the db listener.
restarting the DB by restarting the listener? makes no sense
maddox
Tried to restart db with startup command. That is when I get the error. Also get the error if I try to reconnect to the db.
My mistake. I meant to say when I restart the service for the db which is set to also start the db.
Balazs Papp
Answer
im assuming that after you shut down the database, you want to log in to the database through the listener
by default the database uses dynamic registration and is available through the listener only in MOUNT or OPEN state
to be able to "log in" to a not running, or a NOMOUNT database (as SYSDBA), you have to register the database instance manually in your listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.com)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = ORCL)
    )
  )
Marked as Answer by maddox · Sep 27 2020
maddox
I had just narrowed it to the db not being setup in the listener.ora file but your explanation and example cleared up why I could not log in. Everything running now. I am putting the note on dynamic registration in my OneNote folder. Thanks for the education.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 21 2011
Added on Aug 24 2011
#general-database-discussions
4 comments
7,713 views