Category Archives: 12c new features

Oracle database 12c new features

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

ORA-65066: The specified changes must apply to all containers in 12C

  $ sqlplus sys@pdb1 as sysdba SQL> alter user system identified by “Password!23”; alter user system identified by “Password!23” * ERROR at line 1: ORA-65066: The specified changes must apply to all containers SQL> show con_name CON_NAME —————- PDB1   … Continue reading

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

Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE has been deprecated

This warning will be seen in alert log if we issue the same command in 12c : SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; Instead we can use below command to eliminate the WARNING: SQL> … Continue reading

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

No standby redo logfiles available for T-1

One single instance 12c Oracle database alert log shows below information;  RFS[1]: No standby redo logfiles available for T-1 DataGuard shows ORA-16857 error: DGMGRL> show database verbose “TESTSTY”; Database – TESTSTY Role: PHYSICAL STANDBY Intended State: APPLY-OFF Transport Lag: 7 minutes … Continue reading

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

Manage Temporary Tablespace in a 12cR1 Container Database (CDB) and Pluggable Database (PDB)

By default, both CDB and PDB have a TEMP tablespace: SQL> show con_id con_name CON_ID —————————— 1 CON_NAME —————————— CDB$ROOT SQL> select CON_ID,NAME from v$tablespace where name=’TEMP’; CON_ID NAME ———- ————- 1 TEMP 2 TEMP 3 TEMP Default Temporary Tablespace … Continue reading

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

Tablespace SYSMGMTDATA Is Full in GIMR Database (-MGMTDB)

1) Check the datafile of tablespace SYSMGMTDATA in PDB: SQL> select PDB_NAME from dba_pdbs; PDB_NAME ——————————————————————- RACTEST PDB$SEED SQL> alter session set container=RACTEST; Session altered. SQL> select TABLESPACE_NAME,FILE_NAME,AUTOEXTENSIBLE,BYTES/1024/1024,MAXBLOCKS/1024/1024 from dba_data_files where TABLESPACE_NAME=’SYSMGMTDATA’; TABLESPACE_NAME FILE_NAME AUT BYTES/1024/1024 MAXBLOCKS/1024/1024 —————- ———————————————————————- — … Continue reading

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

Oracle 12c PDB Automatic Startup

1) For 12.1.0.1, create a trigger to startup PDBs while CBD is up running. CREATE OR REPLACE TRIGGER auto_open_pdbs AFTER STARTUP ON DATABASE BEGIN EXECUTE IMMEDIATE ‘ALTER PLUGGABLE DATABASE ALL OPEN’; END auto_open_pdbs; / 2) For 12.1.0.2, run below command … Continue reading

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

Opatch Throws error : java.text.ParseException: Unparseable date: “2016.Aug.09 08:27:15 AEST

SYMPTOMS For 12.1.0.2 GI Home,  opatch  12.2.0.1.5 and later versions  throw below errors : $ opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.5 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/12.1.0.2/grid Central Inventory : /u01/app/oraInventory from … Continue reading

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

Manually Create a Container Database (CDB) With Selected Options

Creating a container database ( CDB) by using DBCA  will install all the options by default. There is no way to install selective options. Here is a practical example of manually creating a CDB with selective options — Oracle JVM, … Continue reading

Posted in 12c new features, CDB/PDB | Tagged , , , , , , , , , , , , , , , | 2 Comments

ERROR: Unable to get logical block size for spfile ‘+DATA1/RACTEST/spfileRACTEST.ora’

Created 12.1.0.2 CDB/PDB database through DBCA, there are a lot of below errors in alert.log. Mon Oct 24 23:33:11 2016 ERROR: Unable to get logical block size for spfile ‘+DATA1/RACTEST/spfileRACTEST.ora’. Mon Oct 24 23:33:11 2016 ERROR: Unable to get logical … Continue reading

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