10 Replies Latest reply: Nov 13, 2012 12:42 AM by 973904 RSS

    ORA-01075: you are currently logged on

    653084
      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.