OraFAQ Forum: Server Administration » ORA-27101: shared memory realm does not exist

Home » RDBMS Server » Server Administration » ORA-27101: shared memory realm does not exist (11g, oracleXE, Window server 2008)

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

ORA-27101: shared memory realm does not exist [message #635815]

Thu, 09 April 2015 06:17

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear All,

Database is of oracle XE.

When executed the below script -

alter system set memory_max_target=460235776m scope=spfile;

after shutdown of database, while trying to loging, below error occurred.

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

Unable to logging to database. Can you please assist me to make it up? How can I able to make it up?

Regards,
Ashish Kumar Mahanta

[Updated on: Thu, 09 April 2015 06:18]

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #635817 is a reply to message #635815]

Thu, 09 April 2015 06:33

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

What version of the database (to 4 decimals, please)
What OS?
How did you connect? (showing error messages is good, but the mean MUCH more when given in context - including the command that resulted in the error.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #635818 is a reply to message #635815]

Thu, 09 April 2015 06:36

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

C:\> set ORACLE_SID=XE
C:\> sqlplus / as sysdba

SQL> startup;

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #635824 is a reply to message #635818]

Thu, 09 April 2015 08:27

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Hello All,

When I investigate properly, then found that, location => oracle_home/database is having initXE.ora which was pointing to dbs/spfileXE.ora.

So I renamed the pfile and created new pfile with the help of alert log and started it with nomount command.
It's started. Then I create spfile and it got resolved. Other new alter command is executed from alert log.

Now database is up and running. Oracle XE pfile and spfile was having different location but logic is same Smile

Regards,
Ashish Kumar Mahanta

[Updated on: Thu, 09 April 2015 08:28]

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #635825 is a reply to message #635824]

Thu, 09 April 2015 08:31

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

ashishkumarmahanta80 wrote on Thu, 09 April 2015 14:27

location => oracle_home/database is having initXE.ora which was pointing to dbs/spfileXE.ora.

That is standard and expected. Additionally, you don't need an instance to be started to create a spfile from a pfile or vice versa.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #635921 is a reply to message #635825]

Mon, 13 April 2015 01:17

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Database was down because of wrong parameters values executed. It was not getting started even. So, I had renamed the old Pfile and created the newest one with the help of alert log.

Do, I have done anything wrong? Please suggest...

Regards,
Ashish Kumar Mahanta

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #635924 is a reply to message #635921]

Mon, 13 April 2015 02:43

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You didn't show us what you did. You told us what you think you did, so we'll never know.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #635934 is a reply to message #635924]

Mon, 13 April 2015 05:58

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Now, access to the databases is bar. Database is working fine.

Report message to a moderator

Previous Topic:	Account Locked
Next Topic:	FRA and DATA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 04 19:58:06 CST 2025