AUTOMATICALLY KILL INACTIVE SESSIONS
Hi, today we are going to create script which automatically kill inactive sessions in oracle database. Here i’m going to kill 15 minutes old inactive sessions. Related Keywords: oracle inactive sessions…
Hi, today we are going to create script which automatically kill inactive sessions in oracle database. Here i’m going to kill 15 minutes old inactive sessions. Related Keywords: oracle inactive sessions…
How to automate Oracle RMAN Backup with shell script In a real environment, you obviously won’t manually trigger all of the Oracle database backups. An automated mechanism is required to…
The primary database is operating in MAXIMUM PROTECTIONor MAXIMUM AVAILABILITY mode, and the standby database doesnot contain any viable standby redo logfiles.ORA-16086: Redo data cannot be written to the standby…
In the following post we’ll go through every possible scenario where we loose REDO, one by one. REDO is the most crucial part when we talk about recovery and contains…
In this article we will learn How to create a new Physical Standby using Backup Set and also DUPLICATE in RMAN, this is a fast way to create Physical Standby…
Download Software Download the Oracle software from OTN or MOS depending on your support status. Unpack Files Unzip the files. You should now have a single directory called “database” containing…
ORACLE DBA – ACTIVITY CHECKLIST on DAILY/WEEKLY/MONTHLY/NIGHTLY Aim: This activity checklist is for Oracle DBA to perform the complete health check report of production databases on Daily/Weekly/Monthly basis as per…
How to Install the Oracle Enterprise Manager Cloud Control (OEM) 13.5c on Oracle Linux Check the OS Hostname: In case if you have not install the Software & Oracle database…
Enterprise Manager Cloud Control offers a centralized solution that allows you to manage and monitor the entire Oracle infrastructure (Hardware, OS, database, middleware) and other market products, remembering that no…
Oracle Database Audit This week there was a specific demand to configure and work with auditing in the Oracle database, in this way I will unravel how to use auditing…