Establish connection to a CDB/PDB

Overview

Connecting to a CDB is only available to common users. Other users must connect using a service name associated with a PDB.

References

• Database Administrator’s Guide
  • 42 Administering PDBs with SQL*Plus
    • 42.2 Connecting to a PDB with SQL*Plus

Reading Notes

"42.2 Connecting to a PDB with SQL*Plus" says:

You can use the following techniques to connect to a PDB with the SQL*Plus CONNECT command:

• Local connection with operating system authentication
• Database connection using easy connect
• Database connection using a net service name

Procedure

BEQUEATH Connection

Via BEQUEATH:

sqlplus / as sysdba

ALTER SESSION SET container = vegemite;

Connection via Service

Find active services in a CDB:

set pages 1000

col network_name for a25

col name for a25

col pdb for a8

set lines 70

select name, network_name, pdb from cdb_services;

Sample output is:

NAME NETWORK_NAME PDB ------------------------- ------------------------- -------- SYS$BACKGROUND CDB$ROOT SYS$USERS CDB$ROOT jarXDB jarXDB CDB$ROOT jar.yaocm.id.au jar.yaocm.id.au CDB$ROOT vegemite.yaocm.id.au vegemite.yaocm.id.au VEGEMITE

Find Current Container

Find current container:

select sys_context('USERENV', 'CON_NAME') from dual;

Sample output:

SYS_CONTEXT('USERENV','CON_NAME') --------------------------------- CDB$ROOT