.::: First time login Oracle using CDB (Container Database / Multitenant) :::.

 

1. login as sysdba 
sqlplus sys/oracle as sysdba;

oracle@teguhth ~]$ sqlplus sys/oracle as sysdba;

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 24 14:12:31 2025
Version 19.3.0.0.0

Copyright (c) 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

SQL> 
 2. create user 

-- di CDB$ROOT
CREATE USER C##AISYAH IDENTIFIED BY hanin;
GRANT CONNECT, RESOURCE TO C##AISYAH;

3. Switch Session ke Container TGHDBFIN

ALTER SESSION SET CONTAINER=TGHDBFIN;

4. Daftar PDB dengan SHOW PDBS
SHOW PDBS;

[oracle@teguhth ~]$ sqlplus sys/oracle as sysdba;

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 24 14:33:25 2025
Version 19.3.0.0.0

Copyright (c) 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

SQL> SHOW PDBS;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TGHDBFIN                       READ WRITE NO
         5 TGHDBHR                        READ WRITE NO
SQL>
 

5. Perintah OPEN dan SAVE STATE pada PDB TGHDBFIN

ALTER PLUGGABLE DATABASE TGHDBFIN OPEN;
ALTER PLUGGABLE DATABASE TGHDBFIN SAVE STATE;

6. test login 

sqlplus C##aisyah/hanin

[oracle@teguhth ~]$ sqlplus aisyah/hanin

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 24 13:45:41 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name: ^C^Z
[oracle@teguhth ~]$ sqlplus C##aisyah/hanin

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 24 13:46:03 2025
Version 19.3.0.0.0

Copyright (c) 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

SQL>

7. test login remote

sqlplus aisyah/hanin@//localhost:1521/TGHDBFIN
sqlplus aisyah/hanin@//10.10.10.28:1521/TGHDBFIN

[oracle@teguhth ~]$ sqlplus aisyah/hanin@//localhost:1521/TGHDBFIN

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 24 13:47:37 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Last Successful login time: Wed Sep 24 2025 13:45:26 +07:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>

[oracle@teguhth ~]$ sqlplus aisyah/hanin@//10.10.10.28:1521/TGHDBFIN

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 24 13:48:18 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Last Successful login time: Wed Sep 24 2025 13:47:37 +07:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>