Category Archives: 12c new features

Oracle database 12c new features

“Database option mismatch: PDB installed version NULL.” in PDB_PLUG_IN_VIOLATIONS

There are below warning messages in PDB_PLUG_IN_VIOLATIONS : SQL>select NAME,CAUSE,MESSAGE,TYPE,CON_ID from PDB_PLUG_IN_VIOLATIONS; NAME CAUSE MESSAGE TYPE CON_ID ———— ———- —————————————————————————————————- ——— ———- RACTESTPDB OPTION Database option DV mismatch: PDB installed version NULL. CDB installed version 12.2.0.1.0. WARNING 3 RACTESTPDB OPTION … Continue reading

Posted in 12c new features, CDB/PDB | Tagged , , , , , | Leave a comment

PARALLEL_MIN_SERVERS Parameter Behaviours In 12.2.0.1

By Default, when 12.2.0.1 instance starts up, there are more than necessary parallel processes created. In this test case, there are 133 parallel processes created when instance starts up. SQL>select * from v$px_process_sysstat where statistic like ‘%Server%’ STATISTIC VALUE CON_ID … Continue reading

Posted in 12c new features, Performance Tunning | Tagged , , , , , | Leave a comment

Create a Container Database (CDB) With A Subset Of Options Using DBCA In 12.2.0.1

For 12.1.0.2,  How to Create a Container Database (CDB) With Selected Options  For 12.2.0.1, we don’t need create scripts from DBCA first, manually modify scripts, then run the scripts sequentially to create a CDB/PDB database with required options in both … Continue reading

Posted in 12c new features, CDB/PDB | Tagged , , , , , , , | Leave a comment

PDB_PLUG_IN_VIOLATIONS

PDB_PLUG_IN_VIOLATIONS displays information about incompatibilities between a PDB and the CDB to which it belongs. SQL> select name,cause,type,action from pdb_plug_in_violations where status <> ‘RESOLVED’; NAME CAUSE TYPE ————- —————- ——— ACTION ——————————————- PDB$SEED SQL Patch ERROR Call datapatch to install … Continue reading

Posted in 12c new features, CDB/PDB | Tagged , | Leave a comment

RMAN-06004: ORACLE error from recovery catalog database: ORA-01422: exact fetch returns more than requested number of rows

SYMPTOMS Target Database : 12.2.0.1 RMAN Catalog  :  12.1.0.2 Trying to “upgrade catalog” from 12.2.0.1 RMAN and 12.1.0.2  RMAN catalog, then got below errors: connected to target database: RACTEST (DBID=2073981615) connected to recovery catalog database PL/SQL package RMAN.DBMS_RCVCAT version 12.01.00.02. … Continue reading

Posted in 12c new features, RMAN Restore and Recovery | Tagged , , , , , , , , , , , | Leave a comment

How to Copy ASM Password File From Primary to Standby in 12cR1

12.1.0.2 primary database password file is stored in ASM, so it needs to be manually copied onto standby database ASM for dataguard configuration. Otherwise the below errors will occur: *** 2017-09-06 14:34:29.216 OCISessionBegin failed. Error -1 .. Detailed OCI error … Continue reading

Posted in 12c new features, ASM, Configuration, DataGuard, GI and RAC | Tagged , , , , , , , | Leave a comment

ORA-03135: connection lost contact in12.1.0.2 Standby Database

Newly built 12.1.0.2 DataGuard got below errors: Primary Database alert.log: Mon Sep 11 11:35:59 2017 TT01: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135) TT01: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned Mon Sep 11 11:35:59 2017 Errors in file /u01/app/oracle/diag/rdbms/ractest/RACTEST1/trace/RACTEST1_tt01_30967.trc: ORA-03135: connection lost … Continue reading

Posted in 12c new features, DataGuard, ORA- ERRORS | Tagged , , , , | Leave a comment

ORA-15001: diskgroup does not exist or is not mounted. ORA-15040: diskgroup is incomplete

SYMPTOM              GI: 12.2.0.1.170814 (26609817)         RAC HOME: 12.1.0.2.160419 (22291127) Just started to build a standby database. Tried to put standby database controlfile into ASM diskgroup by using RMAN , got below errors: RMAN> … Continue reading

Posted in 12c new features, ASM, GI and RAC | Tagged , , , | Leave a comment

PRVG-10091 : failed to retrieve the ASM password file location for an ASM instance

Problem Verifying system upgrade readiness for Grid Infrastructure 12.1.0.2 to 12.2.0.1 with below command, then get “PRVG-10091” warning: $ /u01/app/12.2.0.1/grid/runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u01/app/12.1.0.2/grid -dest_crshome /u01/app/12.2.0.1/grid -dest_version 12.2.0.1.0 -fixupnoexec -verbose … .. . Verifying Verify that the ASM … Continue reading

Posted in 12c new features, ASM, GI and RAC, Upgrading and Patching | Tagged , , , , , , , , , | Leave a comment

The Master Node of RAC Cluster

1) Check from ocssd.log: $ cat $GRID_HOME/log/racnode1/cssd/ocssd.l* |grep ‘master node’ |tail -1 2017-07-18 10:09:21.431: [ CSSD][1102125408]clssgmCMReconfig: reconfiguration successful, incarnation 217002855 with 2 nodes, local node number 2, master node number 2 2) Check from crsd.log $ cat $GRID_HOME/log/racnode1/crsd/crsd.l* |grep ‘OCR … Continue reading

Posted in 12c new features, GI and RAC | Tagged , | Leave a comment