How to Find Current SCN in Oracle In this acrticle, we will demonstrate different ways to find current SCN in Oracle. Follow the below SQLs to find SCN in Oracle. 1. Using V$DATABASE: Find the current SCN in the database using V$DATABASE. 2. Using DBMS_FLASHBACK: Find the current SCN in the database using DBMS_FLASHBACK. 3.
Steps to Apply Combo Patch (Oct 2022) on Clusterware in Two Node RAC in Oracle In this article, we are going to demonstrate the Steps to Apply combo patch 34449117 (19.17.0.0.221018) of October 2022 on Oracle Clusterware in Two Node RAC version 19c. Here we will apply a combo patch 34449117 that contains two patches 34416665 (GRID) and 34411846
How to Enable Passwordless SSH login in Linux PasswordLess SSH configuration is required to perform various types of activities at the time of installation to configure members of cluster nodes, after the installation assistant configuration, Opatch, Enterprise manager, and many other features/commands. We have two options to configure PasswordLess SSH either using OUI which creates
Oracle Critical Database Patch ID for October 2022 along with enabled Download Link An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the
Solution for ORA-00600: Internal Error Code, Arguments: [4193] [2206} in Oracle In this post we will see How to solve ORA-00600: Internal Error Code, Arguments: [4193] [2206], You can encounter this error in Multitenant Environment (CDB) if your Oracle Database machine was suddenly stopped without proper shutdown command due to some unavoidable problem like Power
Oracle Database Appliance Odacli & Odaadmcli Command reference In this blog, we will demonstrate several different usages of odacli, odaadmcli & virsh commands along with some commands output that can be used to administer and manage your Oracle Database Appliance (ODA) with KVM residing in your ODA. ODACLI: It is used for everyday tasks on
Solution for Oracle Appliance Manager Console Access Issue in ODA Oracle Appliance Manager Web Console provides a user-friendly interface to monitor ODA hardware and create databases and view job activity. We started to receive the below error while accessing the ODA web console. Follow the below steps to fix the Oracle Appliance Manager Console Access
Steps to Install & Configure SNMP in Oracle Linux 7 SNMP (Simple Network Management Protocol) is an internet standard protocol used to remotely retrieve the operational statistics of the servers and infrastructure components. SNMP protocol is implemented on the application layer of the networking stack. It is one of the widely accepted protocols to manage
Solution for ORA-01516: nonexistent log file, data file, or temporary file in Oracle In the previous blog, we saw steps to restore RMAN consistent backup using duplicate database command Click here to read more. In this blog, we are going to restore the same consistent RMAN backup using the manual method. With this method we
Solution for RMAN-05541: no archived logs found in target database in Oracle In the previous blog, we performed Steps to Clone Oracle Database from Windows to Oracle Linux Click here to read more. The only difference, in this case, we are taking a cold RMAN backup, and since this is a cold rman backup we
