How To Resize the Online Redo Log files

Today we are going to work on the steps used for Resize the online Redo Logfiles.  Let’s follow the steps:- Single Instance: 1. First, see the size of the current logs: sqlplus /nolog SQL> connect / as sysdba SQL> select group#, bytes, status from v$log; GROUP# BYTES STATUS ———- ———- —————- 1 1048576 INACTIVE 2 […]

Read More

How to clone Oracle Binaries

Today we are going to work on the steps which are used to clone Oracle Binaries.  Sometimes we install Oracle software by using a utility such as tar to copy an existing installation of the Oracle binaries to a different server. Installing Oracle with an existing copy of the binaries is a two-part process Copy […]

Read More

How to set IDLE TIME in Oracle Database

Today we are going to explore the steps which we use for set IDLE TIME in Oracle Database.  Let’s follow the steps. Step1:- connect as sysdba user SQL> conn /as sysdba SQL> sho parameter resource_limit NAME TYPE VALUE ———————————— ———– —————————— resource_limit boolean FALSE Step2:- Change the resource parameter to true SQL> alter system set […]

Read More

How to disable and enable archive log in Oracle RAC

After the core DBA, continue our journey towards RAC environment. Today we are going to explore the steps use for “How to disable and enable archive log in oracle RAC“ Let’s follow the steps. Hopefully, you will feel the difference in RAC. Step1: First we need to stop database instance on node1 using sqlplus. [oracle@rac-node1 […]

Read More

How to configure Shared server mode

Today we are going to explore the steps to use for configure Shared server mode. Let’s follow the steps. We need to set the init parameters SQL>alter system set shared_servers=5; SQL>alter system set max_dispatchers=10 scope=spfile;; SQL>alter system set shared_server_sessions=5 scope=spfile;; SQL>alter system set circuits=300 scope=spfile;; SQL>alter system set dispatchers=”(protocol=TCP)(dispatchers=3)(connections=100)” scope=spfile; Now client tnsfile should be […]

Read More

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

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