Home » RDBMS Server » Server Administration » ORA-27101
ORA-27101 [message #63754] Thu, 04 November 2004 17:38 Go to next message
vqd2697
Messages: 36
Registered: October 2004
Member
I increased the DB_BLOCK_BUFFERS from 0 to 4096 in Oracle9i on NT server.  After shutdown and start up the database without errors.  I'm no longer able to login to database again.  Here are the errors that I got.  Please help me out.....

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Thanks,

Vu

Report message to a moderator

Re: ORA-27101 [message #63769 is a reply to message #63754] Fri, 05 November 2004 05:08 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
Check your alert.log file in order to see why db would not open, and post errors in forum

Best luck.
Remote DBA looking for job.

Report message to a moderator

Re: ORA-27101 [message #63775 is a reply to message #63769] Fri, 05 November 2004 09:14 Go to previous messageGo to next message
vqd2697
Messages: 36
Registered: October 2004
Member
I did look at the Alert log and everything seem to be fine, no errors and the database started in services NT but can not login. I think the problem was due to the SGA requires more space than was
allocated for it. How can I reverse the db_block_buffers back to
0???

Report message to a moderator

Re: ORA-27101 [message #63776 is a reply to message #63775] Fri, 05 November 2004 12:02 Go to previous message
vqd2697
Messages: 36
Registered: October 2004
Member
Problem had been resolved. Thanks

Report message to a moderator

Previous Topic: SIDs and ORATAB doubts !
Next Topic: Very Very Urgent Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 06:28:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.