Home » RDBMS Server » Backup & Recovery » Error in logging in (Windows xp)
Error in logging in [message #602721] Sat, 07 December 2013 14:44 Go to next message
Messages: 67
Registered: October 2013
Location: Saudi Arabia
Hello guys,,,
while I was deleting some not needed files from my computer. I accidentally deleted a file that is an ORACLE file. Now, whenever I try to log in to my database, it shows me this error.
ERROR - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

I don't know if I can retrieve the deleted file. Is there anyway to solve this problem, or I install the Oracle again ??????

Re: Error in logging in [message #602723 is a reply to message #602721] Sat, 07 December 2013 14:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64841
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Restore a backup and recover.
If you have not then you lose your database.

Re: Error in logging in [message #602738 is a reply to message #602721] Sun, 08 December 2013 05:29 Go to previous message
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
12:21 PM oracle@app01.bos:~/scripts/oracle(tijnprim) $ oerr ora 1034
01034, 00000, "ORACLE not available"
// *Cause: Oracle was not started up. Possible causes include the following:
//         - The SGA requires more space than was allocated for it.
//         - The operating-system variable pointing to the instance is
//           improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
//          the problem mentioned in the other messages. 
//          If Oracle has been initialized, then on some operating systems,
//          verify that Oracle was linked correctly. See the platform
//          specific Oracle documentation.
12:22 PM oracle@app01.bos:~/scripts/oracle(tijnprim) $

So, your database is not even started in nomount.

If you have backups you can restore and recover, if you don't .... you have to recreate the database.
Previous Topic: Can not recover file
Next Topic: Restarting dead background process QMN0
Goto Forum:

Current Time: Sun May 28 07:24:33 CDT 2017

Total time taken to generate the page: 0.24662 seconds