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

Oracle Cloud Infrastructure 2019 Architect Professional (1Z0-997)

Hi Readers Finally, I’ve successfully passed 1Z0-997, Oracle Cloud Infrastructure 2019 Architect Professional. It was almost more than 3 years that I’ve been working in OCI starting from OCI classic, Gen1, & Gen2. To clear this exam you must have good hands-on on OCI. OCI Classic – 1Z0-337 Oracle Infrastructure as a Service Cloud 2017 Implementation […]

Read More

Oracle Cloud Infrastructure Developer 2020 (1Z0-1084-20)

Hi Readers Finally, I’ve successfully passed 1Z0-1084-20, Oracle Cloud Infrastructure Developer 2020 Associate. It was almost more than 4-6 months that I’ve been preparing for this. The Exam contains 60 questions related to OCI which includes OCI Functions, OCI Kubernetes, OCI API Gateways etc.. To earn this certification you need to get 70% marks. This was the […]

Read More

Oracle Cloud Infrastructure 2019 Operations Associate (1Z0-1067)

Hi Readers Finally, I’ve successfully passed 1Z0-1067, Oracle Cloud Infrastructure 2019 Cloud Operations Associate. It was almost more than 2-3 months that I’ve been preparing for this. The Exam contains 60 questions related to OCI which includes OCI CLI, Ansible, Terraform, Cost, Security etc.. To earn this certification you need to get 70% marks. This […]

Read More

Oracle Database Cloud Service 2019 (1Z0-998)

Hi Readers Finally, I’ve successfully passed 1Z0-998, Oracle Database Cloud Service 2019. It was almost more than 1-2 months that I’ve been preparing for this. The Exam contains 74 questions related to Database service on OCI which includes cloud concept, backup, recovery, patching etc.. To earn this certification you need to get 67% marks. This was […]

Read More