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