Home » RDBMS Server » Server Administration » ORA-27101: shared memory realm does not exist (11g, oracleXE, Window server 2008)
ORA-27101: shared memory realm does not exist [message #635815] Thu, 09 April 2015 06:17 Go to next message
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 Go to previous messageGo to next message
EdStevens
Messages: 1005
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.
Re: ORA-27101: shared memory realm does not exist [message #635818 is a reply to message #635815] Thu, 09 April 2015 06:36 Go to previous messageGo to next message
gazzag
Messages: 1043
Registered: November 2010
Location: Bristol, UK
Senior Member
C:\> set ORACLE_SID=XE
C:\> sqlplus / as sysdba

SQL> startup;
Re: ORA-27101: shared memory realm does not exist [message #635824 is a reply to message #635818] Thu, 09 April 2015 08:27 Go to previous messageGo to next message
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 Go to previous messageGo to next message
gazzag
Messages: 1043
Registered: November 2010
Location: Bristol, 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.
Re: ORA-27101: shared memory realm does not exist [message #635921 is a reply to message #635825] Mon, 13 April 2015 01:17 Go to previous messageGo to next message
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
Re: ORA-27101: shared memory realm does not exist [message #635924 is a reply to message #635921] Mon, 13 April 2015 02:43 Go to previous messageGo to next message
gazzag
Messages: 1043
Registered: November 2010
Location: Bristol, UK
Senior Member
You didn't show us what you did. You told us what you think you did, so we'll never know.
Re: ORA-27101: shared memory realm does not exist [message #635934 is a reply to message #635924] Mon, 13 April 2015 05:58 Go to previous message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Now, access to the databases is bar. Database is working fine.
Previous Topic: Account Locked
Next Topic: FRA and DATA
Goto Forum:
  


Current Time: Sun Nov 18 16:50:25 CST 2018