Database (237) 썸네일형 리스트형 53 - [Oracle 19C] To create a new Instance If you wish to use a different listener port number, select 'Create a new listener.' ~/StudioProjects/oracle$ cat *.ora ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle88)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.com) ) ) [oracle@test admin]$ sqlplus sys/Manager123#@ORS as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 28 16:36:00 2023 V.. 52 - [Oracle 19C] Unplugging & Plugging part2 SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter pluggable database all open; Pluggable database altered. SQL> select con_id, name, open_mode from v$pdbs; CON_ID NAME OPEN_MODE ---------- -------------------- ---------- 2 PDB$SEEDREAD ONLY 3 ORCLPDBREAD WRITE 4 PDB1 READ WRITE 5 PDBTESTREAD WRITE SQL> alter session set container=pdbtest; Session altered. SQL> select.. 51 - [Oracle 19C] Unplugging & Plugging part1 Unplugging a PDB is disassociating the PDB from its CDB Plugging in a PDB is associationg a PDB with a CDB You can plug a PDB into the same or another CDB 1. Close the pdb1 2. Unplug pdb1 to xml 3. Drop the pdb1 but we keep the datafiles 4. Check compatibility 5. Plug the pdb1 using the xml SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter pluggable database all open.. 50 - [Oracle 19C] Cloning PDBs Cloning is copying a source PDB from a CDB and plugging the copy into the same CDB or another CDB Must be connected to a CDB and the current container must be the root Must have the CREATE PLUGGABLE DATABASE system privilege The CDB in which the PBD is being created must be in READ WRITE mode option) It is better you can put the PDB being cloned into READ ONLY mode before you can clone it SQL> s.. 49 - [Oracle 19C] Dropping PDB using DBCA # before SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NO 4 PDB1 READ WRITE NO 5 PDB3 READ WRITE NO # after SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NO 4 PDB1 RE.. 48 - [Oracle 19C] Dropping PDB using SQL SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NO 4 PDB1 READ WRITE NO 5 PDB2 READ WRITE NO SQL> drop pluggable database pdb2 including datafiles; drop pluggable database pdb2 including datafiles * ERROR at line 1: ORA-65025: Pluggable database PDB2 is not closed on all instances. SQ.. 47 - [Oracle 19C] To create PDB from seed PBD(DBCA) # to create tablespace manually if you did not choose the default user tablespace CREATE TABLESPACE pdb2 DATAFILE '/u01/app/oracle/oradata/ORCL/pdb2/pdb2_01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M; ALTER TABLESPACE pdb2 ADD DATAFILE '/u01/app/oracle/oradata/ORCL/pdb2/pdb2_02.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M; SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- ---------- PDB.. 46 - [Oracle 19C] Connecting to the new PDB SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> col name format a20 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- ---------- PDB$SEED READ ONLY ORCLPDB READ WRITE PDB1 READ WRITE SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NO.. 이전 1 ··· 21 22 23 24 25 26 27 ··· 30 다음
