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;

[…]

AIOUG – Sangam 17 – I am Speaking too

Hello All,

I am speaking this year at AIOUG Sangam 17 and my presenation topic is Oracle Sharding.

Agenda yet to be published and registrations are open.

http://www.aioug.org/sangam17/index.php/registration/registration-details

-Thanks

Suresh

 

Australia OTN 2017 – IAOUG – OTN (ODC) Conference 2017

We are back again, this year with more fantastic sessions with another set of Speakers who are well known in Oracle Community and ACE (D).

More Details at http://www.iaoug.com/otn-days.html

Registrations are Open and Tickets are Limited

Venue: Rydge Hotel World Square, Sydney, Australia

Date: Nov 24,

From: 8:30 am until 5:30 pm

[…]

catctl.pl -E Emulation Feature

Hi

Many of us know about catctl.pl script to upgrade the databases using parallel slave processes since 12c. Adding to that there is executable in $ORACLE_HOME/rdbms/bin called dbupgrade utility which in turn calls out catctl.pl.

There is little known feature which is emulation feature you can run with this utility or script. it displays on […]

Oracle 12c Upgrade : Virtual Column with Function Based Index (bug)

Issue: Post 12C upgrade: Oracle Bug – Virtual Column issue

Fix: Set it at session level or system level – fix_control=’16237969:OFF’

Be aware of the virtual column getting created with function based index, which may lead to sub-optimal plans.

In 11g , index is getting picked by the oracle optimizer and going with optimal Plan. […]

Oracle 12.2 New Features : Approximate Query Processing

While sometime ago, I was looking for a database project requirement to process analytical workload. The organisation choice was Oracle and Developers choice was postgres or vertica. But to handle Vertica we do not have that much of data processing actually needed so the final contenders are Oracle and Postgres.

As per licensing guidelines I […]