1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

ORA-01075: you are currently logged on

Wednesday, 22 August 2012 12:16

Written by Prakash Palani

Print E-mail

Below error message is thrown when the database was not stopped properly / when it has shared memory problems.

Error Message :  ORA-01075: you are currently logged on

Solution :  Clean up the shared memory occupied by ora by executing below commands.

ipcs -s | grep ora

This will list the semaphores occupied by orasid, use the semaphore id to clear up the memory.

ipcrm -s

ipcrm -m

 

 

ORA-01075: you are currently logged on