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 […]
All posts by Anuradha Mudgal
Anuradha Mudgal
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 […]
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 […]
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 […]
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 […]
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 […]
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) […]
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 […]
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 […]
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) […]