In these posts, we will see how we can unplug the application container and plug it into different CDB. Step 1: Unplug application container. SQL> alter pluggable database app_pdb unplug into ‘/u02/app_pdb.xml’; alter pluggable database app_pdb unplug into ‘/u02/app_pdb.xml’ * ERROR at line 1: ORA-65025: Pluggable database APP_PDB is not closed on all instances. It […]
Category: ORACLE 12CR2
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: […]
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 […]
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
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]