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 '14 at 13:49
  • Database is not "dead" but I have ran out of login possibilities. – Jakub P Oct 22 '14 at 14:01

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 '14 at 7:18
  • Agreed. This appears to be a login problem. – captjackvane Oct 28 '14 at 13:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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