I cannot connect to my database as admin, even using connect descriptor neither via RMAN. I am getting TNS-12514 error.
I consider to install new instance.
1) Can I restore/recover PLSQL code from "dead" oracle database?
2) Where is the PLSQL stored?

EDIT: My situation is described here: ORA-01033 "ORACLE initialization or shutdown in progress" caused by ORA-10567 "REDO is inconsistent with data block"

  • TNS-12514 isn't usually a big problem. Can't you connect "/ as sysdba" from the server? Looks like you're trying to solve the wrong problem, your database probably isn't dead (unless there are thing you haven't mentioned).
    – Mat
    Oct 22, 2014 at 13:49
  • Database is not "dead" but I have ran out of login possibilities.
    – Jakub P
    Oct 22, 2014 at 14:01

1 Answer 1


You need to restore/recover your database. If you can't then yes the code is buried in the system table spaces. But it won't be easy looking through the data file with a hex editor trying to find the code. You should either try to restore the database or just rewrite the code. Do you have a backup of your database? Do you have all of the data files, control files, online redo files? If you don't have a backup and your database is in an inconsistent state, then you can probably alter database recover until cancel and then point Oracle to your online redo logs to see if it can find what it needs.

Otherwise you might be out of luck. What is in your alert log for your database?

  • -1 He has to recover because he cannot connect to the database?
    – miracle173
    Oct 27, 2014 at 7:18
  • Agreed. This appears to be a login problem. Oct 28, 2014 at 13:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.