Installing Oracle 20c Binary on OEL 7.5

In this post, we are installing Oracle 20c binaries on OEL 7.5. First, we need to download the software then unzip it on oracle home and start runInstaller from the software location. Initally, you can use Oracle 20c on OCI. [root@oemserver ~]# mkdir -p /u01/app/oracle/product/20.0.0/dbhome_1 [root@oemserver ~]# chown -R oracle:oinstall /u01 [root@oemserver ~]# chmod -R […]

Read More

Patch the 2 node RAC in OCI with DBCLI

In this post,  we will perform patching on BM (Bare Metals) and VM ( Virtuals Machine) database systems by using DBCLI on the 2-Node RAC running on Oracle Database 19c. Note: This tool is not applicable to Exadata DB systems. Prerequisites The /u01 directory has at least 15 GB of free space. The Oracle Clusterware […]

Read More

Configuring Data Guard in Oracle Cloud Infrastructure (OCI)

In previous article, we saw the creation of Oracle RAC on Oracle Cloud Infrastructure (OCI) Installation of Oracle RAC on Oracle Cloud Infrastructure(OCI) In this post, we will see how to configure data guard with RAC on OCI. Assumption : Oracle RAC database is already installed and configured on OCI. Click on Displa Name: DBSVM […]

Read More

Background Media Recovery terminated with ORA-1274 after adding a Datafile

Today lt’s have a tour towards the steps which we are going to solve the issue regards “Background Media Recovery terminated with ORA-1274 after adding a Datafile“ Symptoms in alert.log file: Wed Nov 02 15:35:48 2017 ALTER DATABASE RECOVER  managed standby database disconnect using current logfile Attempt to start background Managed Standby Recovery process (STDB5_DG) […]

Read More

crsctl Error: CLSU-00100 CLSU-00101 CLSU-00103 CLSU-00104

Today we are going to work on the error of oracle “crsctl Error: CLSU-00100 CLSU-00101 CLSU-00103 CLSU-00104” .  Let’s have a look on the steps . [root@oraclehelpdbms2 ~]# /opt/grid/product/11.2.0.3/bin/crsctl start has CLSU-00100: Operating System function: opendir failed with error data: 2 CLSU-00101: Operating System error message: No such file or directory CLSU-00103: error location: scrsearch1 […]

Read More

ORA-19511: Error received from media manager layer

Today we are going to have a look on the steps which we use to resolve the issue “ORA-19511: Error received from media manager layer, error text: ANS1017E (RC-50) Session rejected: TCP/IP connection failure” RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t1 channel at 12/04/2018 06:01:10 […]

Read More

ORA-16014: log X sequence# XXX not archived in Standby

Today we are going to have a look on the steps which are used by DBA’s to resolve issue “ORA-16014: log X sequence# XXX not archived, no available destinations (In Standby Database)”. Problem: In the alert log file Tue May 30 13:48:49 2018 alter database activate standby database ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE (testdb3) […]

Read More

ORA-17502: ksfdcre:4 Failed to create file +DATA during Physical Standby creation using RMAN

We are going to follow some steps to solve the “ORA-17502: ksfdcre:4 Failed to create file +DATA during Physical Standby creation using RMAN”. run{ allocate channel prmy1 type disk; allocate channel prmy2 type disk; allocate auxiliary channel stby type disk; duplicate target database for standby from active database spfile parameter_value_convert ‘oraclehelpdb01′,’oraclehelpdb02′ set db_name=’oraclehelpdb01′ set db_unique_name=’oraclehelpdb02′ set db_file_name_convert=’/oraclehelpdb01/’,’/oraclehelpdb02/’ set log_file_name_convert=’/oraclehelpdb01/’,’/oraclehelpdb02/’ set control_files=’+DATA’ set log_archive_max_processes=’4′ set standby_archive_dest = ‘/holding/oraclehelpdb02/standby_logs’ set log_archive_dest_1 = ‘LOCATION=/holding/oraclehelpdb02/archive_logs valid_for=(online_logfile, all_roles)’ set log_archive_dest_2 = ‘LOCATION=/holding/oraclehelpdb02/standby_logs valid_for=(standby_logfile, standby_role)’ set standby_file_management=’AUTO’ set log_archive_config=’dg_config=(oraclehelpdb01,oraclehelpdb02)’ ; […]

Read More

EXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033

Today we are going to have a look on the steps which we use to resolve the issue “EXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033” ERROR : Error Description: IMPDP fails or terminate with following errors.  ORA-39065: unexpected master process exception in SEND ORA-39079: unable to enqueue message RP,KUPC$C_3_20120305232114,MCP,KUPC$A_4_232736061619000,1,N ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86 […]

Read More