[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.
--//依旧可以登录。