[20241012]ora-12526.txt

[20241012]ora-12526.txt $ rlsql -s -l scott/book@book01p ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus  $ oerr ora 12526 12526, 00000, "TNS:listener: all appropriate instances are in restricted mode" // *Cause:  Database instances supporting the service requested by the client // were in restricted mode. The Listener does not allow connections to // instances in restricted mode. This condition may be temporary, such as // during periods when database administration is performed. // *Action: Attempt the connection again. If error persists, then contact // the database administrator to change the mode of the instance, // if appropriate. --//很明显开启了restricted mode。 SYS@book> alter system disable restricted session; System altered. $ rlsql -s -l scott/book@book01p quit --//注意这个命令在pdb下无效的。 SYS@book01p> alter system enable restricted session; System altered. $ rlsql -s -l scott/book@book01p <<<@ver2 ============================== PORT_STRING                   : x86_64/Linux 2.4.xx VERSION                       : 21.0.0.0.0 BANNER                        : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production BANNER_FULL                   : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 BANNER_LEGACY                 : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production CON_ID                        : 0 PL/SQL procedure successfully completed. --//依旧可以登录。