ORA-12012 Oracle 12.2 (DBCA) Known Bug

DB Ver: 12.2 BETA and higher version. Getting Below alert in Alert.log while creating a database through DBCA in AIX Env. ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_7252″ ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at “SYS.DBMS_STATS”, line 47207 ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 882 ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 20059 ORA-06512: […]

Read More

Generating AWR report from Active Dataguard

Oracle 12.2 came up with a new feature that we can generate AWR report from Physical Standby database if we have enabled active datagaurd. We need to perform the following steps to enable AWR reporting from a physical standby database. Step 1: Unlock SYS$UMF user and change its password using SYS user. SYS$UMF account is used […]

Read More

ORA-04030:QERGH hash-agg,kllcqas:kllsltba

In Oracle 12.2, ORA-04030:QERGH hash-agg,kllcqas:kllsltba, then we need do the following [oracle@local03 run]$ grep CRS_LIMIT_OPENFILE /u01/app/12.2.0.1/grid/crs/install/s_crsconfig_local03_env.txt Old value CRS_LIMIT_OPENFILE=65536 We need to change the value and restart the CRS New value CRS_LIMIT_OPENFILE=400000

Read More

Managing Remote Archived Log File Retention

In the previous article of Automatic deletion of archived redo log, we have seen automatic deletion is enabled by default in the Logical Standby database. Automatic Deletion of Redo Log Files by SQL Apply LOG_AUTO_DEL_RETENTION_TARGET parameter is responsible for this. It has default value 1440 minutes. However, we can manage this parameter and set retention […]

Read More

Automatic Deletion of Redo Log Files by SQL Apply

Archive log files which are used by SQL apply process at Logical Standby database is said to be Foreign Archive Logs or Remote Archived Logs. Foreign Archive log files are managed by SQL Apply process. To know more about it Oracle Dataguard After all the redo entries of Archive log files are applied using SQL apply process, these […]

Read More

Securing Your Logical Standby Database

The logical standby database is in Read-Write mode means a fully updatable mode. A database can be accessed and potential data may be changed. So Oracle data guard provides a lock. We can configure GUARD on the database at a different level according to our requirement. Logical Standby Database Creation A user access can be […]

Read More

Creating RAC database With PDBS

In this Article we will Create RAC Database with PDBS using DBCA. Step 1 : Once you use dbca , first screen that will open is as below select Create Database and click  next: Step 2 : Select Advanced Mode and click Next Step 3 : Select RAC database as database type and Admin Managed […]

Read More

Missing braces on \o{} at clonedb.pl line 245, near “$lne’ , ‘$clonedbdir”

There is a known issue with clonedb.pl script,  you might end-up with “Missing braces on \o{} at clonedb.pl line 245, near “$lne’ , ‘$clonedbdir”  Especially if you are using perl Vv5.10.1. Actual Line: print OUTFILE1 “dbms_dnfs.clonedb_renamefile(‘$lne’,’$clonedbdir/\ora_data_$cldbname$i.dbf’); \n”;    lets Verify You will get the Error when this Line of code  executed and “\o” is the […]

Read More

How to increase number of database writer in Oracle Database

Database Writer Process (DBW) The database writer process (DBW) writes the contents of database buffers to data files. DBW processes write modified buffers in the database buffer cache to disk. Although one database writer process (DBW0) is adequate for most systems, you can configure additional processes—DBW1-DBW9, DBWa-DBWz and BW36-BW99—to improve write performance if your system […]

Read More

Standby with DBCA in Oracle Database 12cR2

In the new features of Oracle Database 12cR2 (12.2.0.1) DBCA can already be used to create dataguard on the standby side. Below is the environment detail: Type Hostname db_unique_name Primary host01 orclpri Standby host02 orclsby Enable force logging on primary.

2. Create standby with DBCA. Assume we have listener is running on primary side. […]

Read More