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 […]
Monthly Archives: April 2020
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 […]
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 […]
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 […]
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 […]
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 […]