thesuhu

Oracle CDB

Aug 18th, 2021 (edited)
659
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # lihat service pdb
  2. SELECT name, pdb FROM v$services ORDER BY pdb, name;
  3.  
  4. # saat pertama kali install, koneksi DEFAULT menuju ke CDB
  5. # cek tnsnames.ora, jika tidak tersedia servicename PDB, silahkan ditambahkan dan restart oracle
  6. PDB1 =
  7. (DESCRIPTION =                                                            
  8.    (ADDRESS = (PROTOCOL = TCP) (HOST = dbase.lab)(PORT = 1000))
  9.    (CONNECT_DATA =
  10.      (SERVER = DEDICATED)
  11.      (SERVICE_NAME = pdb1.dbase.lab)
  12.    )
  13. # konek AS CDB, pastikan PDB1 MOUNTED
  14. SELECT name, open_mode FROM v$pdbs;
  15. # OPEN ALL DATABASE pdb
  16. ALTER pluggable DATABASE ALL OPEN;
  17. # kemudian konek AS PDB dengan service name pdb1.dbase.lab
  18.  
Add Comment
Please, Sign In to add comment