Manual Data Guard switchover in Oracle

Manual Data Guard switchover in oracle

Manual data guard switchover in Oracle: In this article we will explain about how to perform Manual Data Guard switchover in Oracle from primary to physical standby database manually. In a Data Guard environment two types of roles primary database and physical standby database are there we can altered these roles without any data lose … Read more

Create Container Database (CDB) in Oracle 19c using DBCA

Create Container Database (CDB) in Oracle 19c using DBCA

Create Container Database (CDB) in Oracle 19c using DBCA:. In this article we will explain about how to Create Container Database (CDB) in Oracle 19c using DBCA. CDB PDB database features is started from Oracle 12c onwards. A cdb database is the root database in multitenant architecture which contains zero, one or multiple pdbs. Steps … Read more

How to create a Pluggable Database in Oracle 19c using dbca

How to create a new Pluggable Databases in Oracle 19c using dbca

How to create a new Pluggable Database in Oracle 19c using dbca.- In this article we will explain about How to create a Pluggable Database in Oracle 19c using dbca. From Oracle 12c oracle started Multitenant Architecture. In multitenant architecture you could create multiple PDBs and PDBs are created in CDB. Before we create a … Read more

ORA-01274 cannot add data file that was originally created as

ORA-01274_ cannot add data file that was originally created as

ORA-01274: cannot add data file that was originally created as: In this paragraph i will discuss about ORA-01274 database error. When you getting ORA-01274 error follow below steps to resolve the issue. Problem: After adding a datafile in primary database, recovery process in standby database stopped with below error. Primary Side: After adding a datafile … Read more

OLR (Oracle Local Registry) in RAC

OLR (Oracle Local Registry) in RAC

In this paragraph OLR (Oracle Local Registry) in RAC contains node-specific information required by OHASD. Every node has its own dedicated OLR file (not shared between the nodes). From Oracle Clusterware 11g Release 2 onwards an additional component related to the OCR called the Oracle Local Registry (OLR) is installed on each node in the … Read more

Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database

Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database

Transparent Data Encryption In Oracle: In this article we will discuss about configuring and enabling Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database. Let’s see steps how to configure TDE. Take full database RMAN backup: Take full database RMAN backup before starting the TDE implementation activity. Use below script to take full Database RMAN … Read more

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