{"id":261,"date":"2012-04-01T22:58:32","date_gmt":"2012-04-01T20:58:32","guid":{"rendered":"http:\/\/jal-bs.de\/blog\/?p=261"},"modified":"2012-03-30T07:12:30","modified_gmt":"2012-03-30T05:12:30","slug":"oracle-undokumentierte-option-ura-ora-12526-tnslistener-all-appropriate-instances-are-in-restricted-mode","status":"publish","type":"post","link":"https:\/\/jal-bs.de\/blog\/?p=261","title":{"rendered":"Oracle undokumentierte Option: UR=A : ORA-12526: TNS:listener: all appropriate instances are in restricted mode"},"content":{"rendered":"

Befindet sich die Datenbank im „restriced mode“ so kann mit folgenden undokumentiertem Parameter „UR=A“ trotzdem eingeloggt werden (ORA-12526: TNS:listener: all appropriate instances are in restricted mode).<\/p>\n

Beispiel:<\/p>\n

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
\nSystem altered.
\nSQL> select logins FROM v$instance;
\nLOGINS
\n———-
\nRESTRICTED<\/p>\n

SQL> connect user\/password@oracleinstance<\/a>
\nERROR:
\nORA-12526: TNS:listener: all appropriate instances are in restricted mode
\n########################################################<\/p>\n

tnsnames.ora:<\/p>\n

oracleinstance= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=oraserver)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=DBService1) (UR=A) ) )<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Befindet sich die Datenbank im „restriced mode“ so kann mit folgenden undokumentiertem Parameter „UR=A“ trotzdem eingeloggt werden (ORA-12526: TNS:listener: all appropriate instances are in restricted mode). Beispiel: SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; System altered. SQL> select logins FROM v$instance; … Weiterlesen →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[22,18],"_links":{"self":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/261"}],"collection":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=261"}],"version-history":[{"count":5,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/261\/revisions"}],"predecessor-version":[{"id":271,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/261\/revisions\/271"}],"wp:attachment":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}