[oracle@bourne admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 30 15:05:34 2024
Version 19.3.0.0.0
Copyright © 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SYS@ORCLCDB> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 ORCLPDB2 READ WRITE NO
5 ORCLPDB3 READ WRITE NO
SYS@ORCLCDB>
SYS@ORCLCDB> alter session set container = orclpdb1 ;
Session altered.
SYS@ORCLCDB> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
3 ORCLPDB1 READ WRITE NO
SYS@ORCLCDB> alter session set container = cdb$root;
Session altered.
或者
SYS@ORCLCDB> conn / as sysdba
Connected.
SYS@ORCLCDB> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 ORCLPDB2 READ WRITE NO
5 ORCLPDB3 READ WRITE NO
SYS@ORCLCDB>
[oracle@bourne admin]$ sqlplus sys/oracle as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 30 15:13:02 2024
Version 19.3.0.0.0
Copyright © 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SYS@ORCLCDB>
方式三：
[oracle@bourne admin]$ lsnrctl status
…
Service “orclpdb1” has 1 instance(s).
Instance “ORCLCDB”, status READY, has 1 handler(s) for this service…
…
[oracle@bourne admin]$ sqlplus sys/oracle@bourne:1521/orclpdb1 as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 30 15:14:49 2024
Version 19.3.0.0.0
Copyright © 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SYS@bourne:1521/orclpdb1> conn sys/oracle@orclcdb as sysdba
Connected.
SYS@orclcdb> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 ORCLPDB2 READ WRITE NO
5 ORCLPDB3 READ WRITE NO
SYS@orclcdb>
