Subscriber Count

    471

Subscribe to Posts by Email

Pages

12.1.0.2: PDB Database Save State

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 […]

Opatch auto fails CRS-6706

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 […]

Datapatch fails with The pluggable databases that need to be patched must be in upgrade mode

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 […]

EXPDP Import View as Table

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 […]

Oracle 12.2 New Feature : Hot Clone PDB using Database Link

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;

[…]