Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # lihat service pdb
- SELECT name, pdb FROM v$services ORDER BY pdb, name;
- # saat pertama kali install, koneksi DEFAULT menuju ke CDB
- # cek tnsnames.ora, jika tidak tersedia servicename PDB, silahkan ditambahkan dan restart oracle
- PDB1 =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP) (HOST = dbase.lab)(PORT = 1000))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = pdb1.dbase.lab)
- )
- # konek AS CDB, pastikan PDB1 MOUNTED
- SELECT name, open_mode FROM v$pdbs;
- # OPEN ALL DATABASE pdb
- ALTER pluggable DATABASE ALL OPEN;
- # kemudian konek AS PDB dengan service name pdb1.dbase.lab
Add Comment
Please, Sign In to add comment