ORA-27101: shared memory realm does not exist

[Former Member]

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

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

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?????????

[Former Member]

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

[Former Member]

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

[Former Member]

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