News

  1. Home
  2. All posts
All posts by Team Ajara

How to connect to PDBs?

How to connect to PDBs using oracle binary user?

Details:

Server name: oratsrv
Instance name: CDBG
unique name of Container DB: UCDBG

PDB names: PDB1, PDB2,PDB3
Oracle Version: 19.12.0.0.0

=====================================

Step 1) set the environment and connect to CDB

[oracle@oratsrv ~]$ . oraenv
ORACLE_SID = [orcl] ? CDBG
The Oracle base remains unchanged with value /u00/app/oracle
[oracle@oratsrv ~]$ sqlplus “/as sysdba”

SQL*Plus: Release 19.0.0.0.0 – Production on Tue Jun 6 11:35:14 2023
Version 19.12.0.0.0

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.12.0.0.0

Step 2) Display PDBs and connect to PDB2

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
4 PDB1 READ WRITE NO
5 PDB2 READ WRITE NO

 

SQL> alter session set container=PDB2;

Session altered.

SQL> select name from v$database;

NAME
———
UCDBG

SQL> select name from v$pdbs;

NAME
——————————————————————————–
PDB2

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
5 PDB2 READ WRITE NO

 

Step 3) Connect to PDB1

SQL> alter session set container=PDB1;

Session altered.

SQL> select name from v$database;

NAME
———
UCDBG

SQL> select name from v$pdbs;

NAME
——————————————————————————–
PDB1

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
4 PDB1 READ WRITE NO
SQL>

 

See also: