Pages

Saturday, April 4, 2020

ORA-01012: not logged on for SAP System


Symptom :

While starting the database you may get the error ORA-01012 not logged on



Solution:

This error usually occur because of  orphaned shared memory segment with user oracle or ora<sid>.

In order to resolve the issue run the command ipcs or sysresv

To remove the these shared segement use command ipcrm -m <shmid>

Example :
ipcrm -m 1690043378

Suggestion:
Do not run this command when system is up and running that may lead to crash your database.





No comments:

Post a Comment