Day: November 19, 2022

Upgrade Oracle Database from 12.1.0.2 to 12.2.0.1 using DBUA

by

Supported Upgrade PathsDirect upgrades are possible from existing databases with the following versions.Destination Source=========== ======12c Release 1 (12.1.0.2) 10.2.0.5+, 11.1.0.7+, 11.2.0.2+ or 12.1.0.112c Release 2 (12.2.0.1) 11.2.0.3+ or 12.1.0.1 or 12.1.0.2 3. PRE-UPGRADE STEPS: The first step is to run the preupgrade information tool preupgrade.jar tool which replaced the preupgrd.sql and utluppkg.sql scripts. This tool … Read more

Step by Step ASM/ Grid Installation in Oracle Standalone

by

Prerequisite. Add below OS groups Add  asmdba as secondary group to Oracle user Create Grid User Change the password for Oracle and Grid user Create the Directories for Oracle Database installation Create the Directories for Oracle Grid installation Step2. Configure Oracle ASM Load / initiate Oracle ASM init 0 Add  25 GB  Hard Disk Add … Read more