10 Replies Latest reply on Nov 13, 2012 6:42 AM by 973904

    ORA-01075: you are currently logged on

      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.