|
||||
|
In 12.1.0.1, one must have a trigger or script to open all PDB’s once the CDB is restarted. But from 12.1.0.2, there is a new option “Save State” for alter pluggable database command. Let’s test it This is the status of my PDB’s select name,open_mode from v$pdbs; NAME OPEN_MODE —————————— ———- PDB$SEED READ ONLY PDB3 […] Opatchauto failing with error CRS 6706 : Oracle Clusterware Release patch level (‘nnnnnn’) does not match Software patch level (‘nnnnnn’). This can be due to with two reasons One of the node in the cluster have different patches than other The patch level from one node to other is different. How to find it? $/u01/app/12.1.0.2/grid/bin/kfod […] With recent PSU Patch (Jan18) , while runnin datapatch the following issue occurred. Error: prereq checks failed! patch 22139226: The pluggable databases that need to be patched must be in upgrade mode Prereq check failed, exiting without installing any patches. There is an option called “skip_upgrade_check” for datapatch. $ ./datapatch -verbose -skip_upgrade_check SQL Patching tool […] Starting 12c, we can export a view and import it as table instead of view using data pump. SQL> create view emp_dept as select empno, ename, dept.deptno , dname from emp, dept where emp.deptno=dept.deptno; View created. expdp directory=DBA_DATAPUMP dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=emp_dept_vw Processing object type TABLE_EXPORT/VIEWS_AS_TABLES/TABLE_DATA Total estimation using BLOCKS method: 16 KB Processing object […] Hi, In release 12.2, we can use database link to clone the PDB. Here is the example. SQL> CREATE USER c##clone_dba IDENTIFIED BY clone_dba CONTAINER=ALL; SQL> GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO c##clone_dba CONTAINER=ALL; SQL> CREATE DATABASE LINK clone_link CONNECT TO c##clone_dba IDENTIFIED BY clone_dba USING ‘pdb1’; SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1@clone_link; […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!