Home » Other » General » ORA error (10g)
ORA error [message #550990] Sat, 14 April 2012 05:57 Go to next message
saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal
Junior Member

Hi Experts...

My database is not running and the errors are

ORA-01034 and ORA-27101

please guide me .

Thanks
Re: ORA error [message #550994 is a reply to message #550990] Sat, 14 April 2012 07:02 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Your Database is down. Start it.


Re: ORA error [message #551055 is a reply to message #550994] Sun, 15 April 2012 03:56 Go to previous messageGo to next message
saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal
Junior Member

Thanks for reply but I have stated all services more than 1 time. How can I start it? please guide me
Re: ORA error [message #551056 is a reply to message #551055] Sun, 15 April 2012 04:28 Go to previous messageGo to next message
John Watson
Messages: 8461
Registered: January 2010
Location: Global Village
Senior Member
Saqib, you did not give detail of either your operating system or what the error actually is. Next time, show the error, like this:
c:\users\john\home>sqlplus scott/tiger

SQL*Plus: Release 11.2.0.3.0 Production on Sun Apr 15 10:24:40 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name:
is that what you have, and are you running on Windows? If so, starting the Windows service does not start the Oracle instance. To do that, connect as SYS and issue the STARTUP command.
Re: ORA error [message #551090 is a reply to message #551056] Sun, 15 April 2012 10:25 Go to previous messageGo to next message
saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal
Junior Member

ORA-01034 ORACLE not available
ORA-27101 shared memory realm does not exits




I m using window and I have stated all windows services as u say. But problem is same. Where I run STARTUP command?

[Updated on: Sun, 15 April 2012 11:06]

Report message to a moderator

Re: ORA error [message #551092 is a reply to message #551090] Sun, 15 April 2012 10:47 Go to previous messageGo to next message
Michel Cadot
Messages: 67665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Open a DOS box, set ORACLE_SID, ORACLE_HOME and PATH to contain %ORACLE_HOME%\bin directory.
Launch sqlplus using:
sqlplus / as sysdba
then execute STARTUP.

If you have to administer a database I advice you to read/watch:
Database 2 Day DBA
Oracle DBA Lite

Windows specific books at http://www.oracle.com/pls/db102/portal.portal_db?selected=9

Regards
Michel


Re: ORA error [message #551109 is a reply to message #551092] Sun, 15 April 2012 12:11 Go to previous message
saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal
Junior Member

Thanks for reply .
Previous Topic: CCNA dumps
Next Topic: Unidentified format in archive logs
Goto Forum:
  


Current Time: Mon Jan 25 18:30:58 CST 2021