Home » SQL & PL/SQL » SQL & PL/SQL » Oracle not available and shared memory realm does not exist
Oracle not available and shared memory realm does not exist [message #268250] Tue, 18 September 2007 01:13 Go to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
Hello friends,
I am having a big problem, my oracle is not working. when i am logging in with system/manager then it shows error:-

ora-01034 oracle not available
ora-27101 shared memory realm does not exist

I have restarted oracle service and server too. but then also it is not working. i have also tried
c:\>set oracle_sid=grms
c:\>sqlplus/nolog

then sql prompt started and there i issuing
SQL>shutdown immediate

HERE IT IS GIVING MESSAGE "Unknown command "shutdown"....

Now please anybody tell me how to make oracle available

thanks in advance
Re: Oracle not available and shared memory realm does not exist [message #268251 is a reply to message #268250] Tue, 18 September 2007 01:15 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
HERE IT IS GIVING MESSAGE "Unknown command "shutdown"....

Have you looged on to database?

Use startup.
Re: Oracle not available and shared memory realm does not exist [message #268255 is a reply to message #268251] Tue, 18 September 2007 01:30 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
yes i have logged into database as dba.
Actually yesterday my database was working correctly. yestreday i have imported latest database in my existing database by following command..

c:\>imp userid=system/manager full=y path=c:\abc.dmp log=abcd

after the database imported successfully, i have also worked on it. But today when i m trying to logging into oracle it is giving me error msg "ORA-01034 Oracle Not Available".
Re: Oracle not available and shared memory realm does not exist [message #268256 is a reply to message #268250] Tue, 18 September 2007 01:34 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

c:\>sqlplus/nolog
sqlplus>startup

Re: Oracle not available and shared memory realm does not exist [message #268257 is a reply to message #268251] Tue, 18 September 2007 01:35 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
startup is also not working. message below is displayed
"unknown command "startup" rest of line ignored"
Re: Oracle not available and shared memory realm does not exist [message #268261 is a reply to message #268257] Tue, 18 September 2007 01:39 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
Mr. Arju, i am sending image of error as attachment. from there could get some idea of what i am trying to do. thanks

[mod-edit] illiterate IM speak removed.
  • Attachment: error.jpg
    (Size: 48.22KB, Downloaded 150 times)

[Updated on: Tue, 18 September 2007 07:39] by Moderator

Report message to a moderator

Re: Oracle not available and shared memory realm does not exist [message #268269 is a reply to message #268250] Tue, 18 September 2007 01:48 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Have you properly set ORACLE_SID, ORACLE_HOME, Shared_pool size?

What the output of echo %ORACLE_HOME%
and echo %ORACLE_SID%
?
And your version is 8i!
Re: Oracle not available and shared memory realm does not exist [message #268271 is a reply to message #268250] Tue, 18 September 2007 01:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

In addition,

Use,
conn / as sysdba

instead of conn sys ad dba which one you used.
Re: Oracle not available and shared memory realm does not exist [message #268273 is a reply to message #268256] Tue, 18 September 2007 01:55 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Arju wrote on Tue, 18 September 2007 07:34
c:\>sqlplus/nolog
sqlplus>startup



Would result in ORA-01031

@amit_vass
Look at the image that you posted (by the way, do not post images, simply cut and paste your sql*plus session.)

You have failed to log in!
You entered:
SQL> conn sys as dba
and you received an error:
expected sysdba or sysoper not "dba"

You then decide to ignore this and try to issue commands anyway.
You cannot use the connect string that you are using. It is invalid syntax. You need to connect either as sysdba or sysoper as per the message that Oracle has given you.
Re: Oracle not available and shared memory realm does not exist [message #268280 is a reply to message #268269] Tue, 18 September 2007 02:01 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
From where we can set ORACLE_SID, ORACLE_HOME, Shared_pool size?

Yes i am using 8i.

Re: Oracle not available and shared memory realm does not exist [message #268284 is a reply to message #268273] Tue, 18 September 2007 02:06 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
I have tried that also i also got connected sa sysdba, but then also it is showing shutdown and startup command as unknown command. Now tell me what i can do to make oracle available. Thanks

[mod-edit] illiterate IM speak removed.

[Updated on: Tue, 18 September 2007 07:40] by Moderator

Report message to a moderator

Re: Oracle not available and shared memory realm does not exist [message #268289 is a reply to message #268284] Tue, 18 September 2007 02:15 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Copy and paste your session when you say that you successfully logged in as sysdba please.
Re: Oracle not available and shared memory realm does not exist [message #268297 is a reply to message #268289] Tue, 18 September 2007 02:27 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
At command prompt i typed
C:\>sqlplus/nolog

then

sql> conn / as sysdba
ORA-00022: invalid session id; access denied
Connected
sql>

So this is the scenario..

help me..

[mod-edit] illiterate IM speak removed.


[Updated on: Tue, 18 September 2007 07:41] by Moderator

Report message to a moderator

Re: Oracle not available and shared memory realm does not exist [message #268303 is a reply to message #268289] Tue, 18 September 2007 02:42 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
pablolee wrote on Tue, 18 September 2007 08:15
Copy and paste your session when you say that you successfully logged in as sysdba please.

COPY AND PASTE
Re: Oracle not available and shared memory realm does not exist [message #268309 is a reply to message #268250] Tue, 18 September 2007 02:48 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You have not followed my advice...

Have you properly set ORACLE_SID, ORACLE_HOME, Shared_pool size?

What the output of echo %ORACLE_HOME%
and echo %ORACLE_SID%
?


Note that your your OS user has the permission over $ORACLE_HOME directory.
Re: Oracle not available and shared memory realm does not exist [message #268313 is a reply to message #268303] Tue, 18 September 2007 02:59 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
I am working on command prompt and image of command prompt is attached.
  • Attachment: session.jpg
    (Size: 43.30KB, Downloaded 232 times)
Re: Oracle not available and shared memory realm does not exist [message #268318 is a reply to message #268313] Tue, 18 September 2007 03:04 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
/ as sysdba...
is that Oracle 8.0 syntax?

When was sysdba introduced? 8.0 or 8i?

never mind.. found it, sorry.

[Updated on: Tue, 18 September 2007 03:05]

Report message to a moderator

Previous Topic: oracle 9i
Next Topic: sql%found problem
Goto Forum:
  


Current Time: Sun Dec 04 02:42:14 CST 2016

Total time taken to generate the page: 0.26740 seconds