Change AWR snapshot Retention period and Interval in Oracle

Change AWR snapshot Retention period and Interval in Oracle

Change AWR snapshot Retention period and Interval in Oracle: In this article we will discuss about how to Change AWR snapshot Retention period and Interval in Oracle. About AWR Report: Oracle MMON background process collect the AWR statistics and generate the snapshot based on retention period, which violates the threshold metric. You can enable this … Read more

How to create a password file using ORAPWD Utility in oracle

How to create a password file using ORAPWD Utility in oracle

How to create a password file using ORAPWD Utility in oracle: In this post we will discuss about how to create a password file using ORAPWD Utility in oracle. What is password file in ORACLE ? The password file stores a list of usernames and passwords that are allowed to remotely authenticate as SYSDBA over … Read more

Oracle 19c 2 node RAC to single instance standby database setup

Oracle-19c-2-node-RAC-to-single-instance-standby-database-setup

Oracle 19c 2 node RAC to single instance standby database setup: In this article we will discuss about how to setup Oracle 19c 2 node RAC to single instance standby database step by step. Environment Details for both (Primary and Standby): Primary Server side Configurations:- Make sure primary is in archivelog mode: Check FORCE LOGGING … Read more

ORA-28040: No matching authentication protocol error

ORA-28040: No matching authentication protocol error

ORA-28040: No matching authentication protocol error :- How to resolve ORA-28040 error. After upgrading Oracle database from 11g to 12c or higher version if you facing the same error then follow below steps. SQLNET parameters ALLOWED_LOGON_VERSION_CLIENT & ALLOWED_LOGON_VERSION_SERVER issue in Oracle 12c. Set the value to the minimum authentication protocol allowed while making connection to … Read more

Install Oracle 19c on Windows step by step

Install Oracle 19c on Windows step by step

Install Oracle 19c on Windows step by step : In this article we will see how to Install Oracle 19c Software on Windows step by step. How to create a Oracle 19c Database on windows using dbca. Click Here. Enviroment : Follow below steps to Install Oracle 19c Database on Windows: Download Oracle 19c Software … Read more

Install Grid Infrastructure for Standalone Server in Oracle 19c

Install Grid Infrastructure for Standalone Server in Oracle 19c

Install Grid Infrastructure for Standalone Server in Oracle 19c : In this article we will see how to Install Grid Infrastructure for Standalone Server in Oracle 19c on Linux. Tables of contents for this Intallation : Install the prerequisites. Install the Oracle Grid Infrastructure Standalone. Check the Grid resource. Install the prerequisites : Install the … Read more

Create and Configure Oracle ASM Disk in Linux

Create and Configure Oracle ASM Disk in Linux

Create and Configure Oracle ASM Disk in Linux: In this article we will see how to Create and Configure Oracle ASM Disk in Linux. Before this article, read the following article to add Disk on VirtualBox. How to Add Hard disk in VirtualBox and Disk format and Mount Steps on Linux. In the above article, … Read more

Add Hard disk in VirtualBox and Disk format and Mount Steps on Linux

Add Hard disk in VirtualBox and Disk format and Mount Steps on Linux

How to Add Hard disk in VirtualBox and Disk format and Mount Steps on Linux: In this article we are going to discuss about How to Add Hard disk in VirtualBox and Disk format and Mount Steps on Linux. Note: After installing Oracle linux 7.8 operating system, I want to prepare this server for Oracle … Read more

Upgrade Oracle Database from 12c to 19c using the RMAN backup

Upgrade Oracle Database from 12c to 19c using the RMAN backup

Upgrade Oracle Database from 12c to 19c using the RMAN backup : In this article we will discuss about how to Upgrade Oracle Database from 12c to 19c using the RMAN backup. Enviroment: Steps of Oracle Database 19c Restore from 12c rman backup : In Oracle 12c : Create pfile from spfile of 12cR2 database: … Read more

Convert Physical Standby to Active Dataguard

How to Convert Physical Standby to Active Dataguard

Convert Physical Standby to Active Dataguard : In this article we will discuss about How To Enable Active Dataguard In Physical Standby Database. Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time. Benefits of using Active Dataguard : Absolutely the best protection … Read more