OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-27101

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-27101 [message #63754]

Thu, 04 November 2004 17:38

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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 02:43:45 CDT 2026