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 :- 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 : 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 : 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: 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
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 : 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 : 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 : Important Note : You … Read more
ORA-12154: TNS could not resolve service name: In this article we will see how to resolve this error ORA-12154: TNS could not resolve service name. ORA-12514 is a common error which related to your database tnsnames.ora file and your database name. Solution : Make sure that your listener is listening for the same service name … Read more
For a DBA, starting up and shutting down of oracle database is a routine and basic operation. Sometimes Linux administrator or programmer may end-up doing some basic DBA operations on development database. So, it is important for non-DBAs to understand some basic database administration activities. Oracle Database startup and shutdown procedure Oracle Database startup and … Read more
