This discussion is archived
10 Replies Latest reply: Nov 12, 2012 10:42 PM by 973904 RSS

ORA-01075: you are currently logged on

653084 Newbie
Currently Being Moderated
Hi All,

I am having this issue with a recently created database ( which i created manually as part of my learning exercise) on SUN Solaris, Oracle 10G R2.

Once I disconnect from my database server without logging out from database, next time when I try to connect to database (as SYSDBA) I get

ORA-01075: you are currently logged on

At this point only option I have is to kill database process (using ipcs -s to identify process id and ipcrm -a to kill process) and then restart database.

Trying to find reason behind this but so far I have no clue why this is happening.

Has anyone come across this kind of issue? Your help is much appreciated.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points