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:

2. Logs are 1MB from above, let’s size them to 10MB. Retrieve all the log member names for the groups:

3. Let’s […]

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

Step2:- Change the resource parameter to true

Step3:- Change the IDLE time to 60min

It is changed to 60 min of idle time. The application […]

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.

[…]

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

Now client tnsfile should be like

Bounce the Database To confirm shared server connection use below SQL query

Now we check shared server are idle or […]

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.

Select a “Set Up Software Only” and click next. Select on “Single instance database […]

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:

Trace file:

Cause: This Error occurs if we add a Datafile OR Tablespace in PRIMARY Database and that could not be translated […]

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 .

Cause: Hostname was changed, in this case it was changed to localhost Solution: Option 1:

Option 2:

Oracle Support Doc ID 1551791.1 Thank […]

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”

Solution: In this case TSM(Tivoli Storage Manager) died due to paging space. After started it again by Server responsible people […]

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

Cause : In this case the problem was log_archive_dest_2 was set incorrectly.

Solution :

Please check […]

Read More