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
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
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: 68624
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 messageGo to next message
martijn
Messages: 286
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.
Re: Error in logging in [message #664484 is a reply to message #602738] Thu, 20 July 2017 01:50 Go to previous messageGo to next message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
Thank You. Problem solved.
Re: Error in logging in [message #664495 is a reply to message #664484] Thu, 20 July 2017 04:43 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
How?
Re: Error in logging in [message #664496 is a reply to message #664495] Thu, 20 July 2017 05:46 Go to previous messageGo to next message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
Reinstall the database.
Re: Error in logging in [message #664507 is a reply to message #664484] Thu, 20 July 2017 06:42 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
amjad_alahdal wrote on Thu, 20 July 2017 01:50
Thank You. Problem solved.
You mean the problem from Dec 2013?
Re: Error in logging in [message #664509 is a reply to message #664507] Thu, 20 July 2017 07:48 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Big database Wink
Previous Topic: Retention Policy with RMAN Incremental Backups
Next Topic: Retention Policy for Control File Auto Backups
Goto Forum:
  


Current Time: Thu Mar 28 06:51:28 CDT 2024