Many times, you get the private key from the cloud provider to connect to the Virtual machine. Generally, the keys will be in OpenSSH format. If you directly try to use that key with Putty to connect to the VM machine, you will get failure. we need to convert the private key into ppk format […]
Latches and Mutex in Oracle database
Introduction To Latch in Oracle Database Latches are low-level serialization mechanisms used to protect shared data structures in the Oracle SGA. The implementation of latches is operating system-dependent, particularly in regard to whether a process will wait for a latch and for how long. A latch is a type of lock that can be very […]
How to monitor transaction Rollback Progress
I had a situation where I had to killed the long-running session in my Oracle database. The session does not terminate immediately. It is marked for the kill and the rollback is done in the background. SQL> ALTER SYSTEM KILL SESSION ’12,2233′; ALTER SYSTEM KILL SESSION ’12,2233′ * ERROR at line 1: ORA-00031: session marked […]
Alert Log and how to check alert log errors in oracle
What is alert log file in Oracle The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file are database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected […]
ORA-01111 in MRP in Physical Standby database
Some time back, MRP in the standby database failed with ORA-01111 with the following detailed error in alert log Alert Log in Standby Shows MRP is terminated with below error ================================================================= File #8 added to control file as ‘UNNAMED00008’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file should be manually created to continue. […]
Active Dataguard in Oracle
What is Active Dataguard in Oracle The Active Data Guard Option available with Oracle Database 11g Enterprise Edition enables you to open a physical standby database for read-only access for reporting, for simple or complex queries, sorting while Redo Apply continues to apply changes from the production database to the standby database. All queries reading […]
