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…
How to change renderer from systemd-networkd NetworkManager First view the config file using the cat command: Sample outputs: The above config tells of bringing up the Ethernet interface named enp0s31f6 via…
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…
Preliminary Note The particularity of this command is you don’t need any requirements, however, it’s run as a root The basic format of nmcli: OBJECT could be one of these…
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…
Backwards Compatibility The transition to using systemd is made easier by the fact the service and chkconfig commands are still available. They have been reworked to call the equivalent systemctl commands. What’s more, they sometimes output the command…