shared memory realm does not exist HP-UX Error: 2: No such file or directory

[caj]

Hi ,

I am getting thr following error when we are executing some job on HP server .After some time if i re-run the job it works fine .

The error message is "
SQL error. Stmt #: 1604 Error Position: 242 Return: 2068 - ORA-02068: following severe e rror from IDB ORA-01034: ORACL E not available ORA-27101: shared memory realm does not exis t HP-UX Error: 2: No such file or directory "


I am not sure what is causing this error .Is it because of semaphore getting file .what is the command to find the usage of shared memory /semaphore ?

Any help will be apprenticed


Thanks in advance

Ajeesh

[A. Clay Stephenson]

ipcs will display sema4's, message queue's, and shared memory segments.

Errno 2 (ENOENT) is set by the shmget() system call when the key (the 3rd column in the ipcs display) requested cannot be found. This means that the shared memory segment was removed but your application was still trying to access the shm segment. This is often the result of improper shutdown procedures (e.g. kill -9). Man 2 shmget for details.

[Ninad_1]

Hi,

Is your database up and running fine ?
Are the env variables ORACLE_SID and ORACLE_HOME set correctly to the database SID and oracle home respectively ?

Regards,
Ninad