Question Re: ORA-27101: shared memory realm does not exist in Technology Q&A

ORA-27101: shared memory realm does not exist

Former Member — Thu, 21 May 2009 10:34:59 GMT

Hi,

I´ve done an upgrade from Oracle 10.2.0.2 to 10.2.0.4 and now I can´t start the sap system, I´ve this error:

/usr/sap/SID/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

This is the log:

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/SID/SYS/exe/run/startdb: Terminating with error code 12

I tried to start the DB manually but.......:

sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 21 12:30:39 2009

Connected to an idle instance.

SQL>startup

ORACLE instance started.

Total System Global Area 2969567232 bytes

Fixed Size 2059104 bytes

Variable Size 1493173408 bytes

Database Buffers 1459617792 bytes

Redo Buffers 14716928 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

I tried :

SQL> shutdown immediate

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

If I tried to do first the shutdown immediate I´ve this error:

SQL> shutdown immediate

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

HPUX-ia64 Error: 2: No such file or directory

Could someone help me?????????

Re: ORA-27101: shared memory realm does not exist

Former Member — Fri, 29 May 2009 07:40:14 GMT

Hi bro ,,

I am getting the sme erorr after system copy l... Did u managed to resolve it...if yes please share with me..

rgds

rahul

Re: ORA-27101: shared memory realm does not exist

Former Member — Mon, 03 Aug 2009 09:20:05 GMT

Hi,

I did it:

1. $sqlplus "/as sysdba"

2. SQL> STARTUP UPGRADE

3. SQL>SPOOL patch.log

4. @?/rdbms/admin/catupgrd.sql

5. SQL> SPOOL OFF

6. SQL> SHUTDOWN IMMEDIATE

9. SQL> STARTUP

10. Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are SQL>@ /oracle/<SID>/102_64/rdbms/admin/utlrp.sql

11. Run the following command to check the status of all the components after the upgrade:

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

12. Stop the sap system

13. start sap system

You can find more information about this error in the Oracle documentation.

If you need more help, please let me know, Sapera

Re: ORA-27101: shared memory realm does not exist

Former Member — Mon, 03 Aug 2009 09:20:18 GMT

Hi,

I did it:

1. $sqlplus "/as sysdba"

2. SQL> STARTUP UPGRADE

3. SQL>SPOOL patch.log

4. @?/rdbms/admin/catupgrd.sql

5. SQL> SPOOL OFF

6. SQL> SHUTDOWN IMMEDIATE

9. SQL> STARTUP

10. Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are SQL>@ /oracle/<SID>/102_64/rdbms/admin/utlrp.sql

11. Run the following command to check the status of all the components after the upgrade:

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

12. Stop the sap system

13. start sap system

You can find more information about this error in the Oracle documentation.

If you need more help, please let me know, Sapera