1 Reply Latest reply on Sep 25, 2012 8:12 PM by Peter Häusler

    ORA-12526 error

    gsundaresh
      ORA-12526: TNS:listener: all appropriate instances are in restricted mode (DBD ERROR: OCIServerAttach)
      what should we do to come across this error...i cannot access any tabs can u please help me
        • 1. Re: ORA-12526 error
          Peter Häusler
          Hello,
          you did not specify any version of the database or client, but this error normaly means that you database has a restricted state on the database listener.
          For example if your dba issue the following command on the database site
          alter system enable restricted session;
          then no new connection can made with the error you described until the dba ends this
          alter system disable restricted session;

          Of course there can also be other things which produce this error so give us more information like last errors from the alert log, lsnrctl status output or a select from your v$insance which can look something like this...

          SQL> select logins from v$instance;

          LOGINS
          ----------
          RESTRICTED


          regards
          Peter
          1 person found this helpful