Category Archives: 12c new features

Oracle database 12c new features

Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold

One single 11.2.0.4 instance Oracle database alert log shows below information; RFS[1]: No standby redo logfiles available for thread 1 Data Guard shows ORA-16857 error: DGMGRL> show database “TESTSTY”; Database – TESTSTY Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 10 … Continue reading

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

root.sh Failed with “CLSRSC-670: No msg for has:clsrsc-670” When Adding a Node

While adding a node by running ‘root.sh’ in 12.1.0.2, the below errors occurred: # /u01/app/12.1.0.2/grid/root.sh Check /u01/app/12.1.0.2/grid/install/root_racnode2_2018-01-26_23-56- 01.log for the output of root script #cat /u01/app/12.1.0.2/grid/install/root_racnode2_2018-01-26_23-56-01.log Performing root user operation. The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= … Continue reading

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

Deinstall 12.1.0.2 Grid Infrastructure Home After Being Upgraded to 12.2.0.1

Grid Infrastructure 12.1.0.2 has been upgraded to 12.2.0.1 successfully. So 12.1.0.2 GI_HOME needs to be de-installed.  There are two ways to uninstall the old GI_HOME ( 12.1.0.2) 1) Detach GI_HOME and Remove the GI_HOME manually: $ export ORACLE_HOME=/u01/app/grid/12.1.0.2 $ $ORACLE_HOME/OPatch/opatch … Continue reading

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

“Duplicate from Active Database” Failed With ORA-12528 When Connecting to Auxiliary Instance

RMAN “duplicate target database for standby from active database” failed with below errors: Connection from target database server to the auxiliary database  fails with error: ORA-12528: TNS:listener: all appropriate instances are blocking new connections. CAUSE Since Auxiliary instance is started in … Continue reading

Posted in 12c new features, DataGuard, GI and RAC, ORA- ERRORS, RMAN Restore and Recovery | Tagged , , , , | Leave a comment

datapatch -verbose Fails with Error “patch xxxxxxxx: Archived patch directory is empty”

“datapatch -verbose” failes on 12.1.0.2 database with below errors: $ ./datapatch -verbose -skip_upgrade_check … .. . Error: prereq checks failed! patch 22139226: Archived patch directory is empty Prereq check failed, exiting without installing any patches. … .. . Check $ORACLE_HOME/sqlpatch, there … Continue reading

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

How to Remove PDB From Restricted Mode

1) Check PDB  status: SQL> select INST_ID,NAME,OPEN_MODE,RESTRICTED from gv$pdbs order by 1,2; INST_ID NAME OPEN_MODE RES ———- —————————— ———- — 1 RACTESTPDB READ WRITE YES 1 PDB$SEED READ ONLY NO 2 RACTESTPDB READ WRITE YES 2 PDB$SEED READ ONLY NO … Continue reading

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

The pluggable databases that need to be patched must be in upgrade

After applied PSU and OJVM binary patches, and  run “datapatch”,  then get error “The pluggable databases that need to be patched must be in upgrade mode”. $ ./datapatch -verbose … .. . The following patches will be rolled back: 22139226 … Continue reading

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

12.2.0.1 GI RU( 12.2.0.1.180116) OPatchauto Failed due to exit status 2

When applying 12.2.0.1 GI RU( 12.2.0.1.180116 ), there are a couple of issues resolved by : Detach ORACLE_HOME which have no instances running against. Remove databases which are non required , but still in OCR. Use latest opatch  for “wallet” issue. … Continue reading

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

TFA – Oracle Trace File Analyser Installation

Uninstall TFA 1) Check TFA_HOME. $ grep TFA_HOME= /etc/init.d/init.tfa TFA_HOME=/u01/app/12.2.0.1/grid/tfa/racnode1/tfa_home 2) Uninstall TFA as root user. [root@racnode1 bin]# ./tfactl -h Usage : /u01/app/12.2.0.1/grid/bin/tfactl <command> [options] commands:diagcollect|collection|analyze|ips|run|start|stop|enable|disable|status|print|access|purge|directory|host|receiver|set|toolstatus|uninstall|diagnosetfa For detailed help on each command use: /u01/app/12.2.0.1/grid/bin/tfactl <command> -help [root@racnode1 bin]# /u01/app/12.2.0.1/grid/bin/tfactl uninstall … Continue reading

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

“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