Windows

How to Install Oracle Database Examples

by Ed Chen
September 21, 2022September 19, 2022

What is Oracle Database Examples? Oracle Database Examples is a package which contains various sets of product demostration files that we can additionally apply them… Read More »

How to Build 19c RAC on Windows - 4 of 4 - Creating a RAC Database

by Ed Chen
July 9, 2022September 13, 2022

We click on Database Configuration Assistant (DBCA) in the menu to initiate the database creation process. We had better to restart both nodes to verify… Read More »

How to Build 19c RAC on Windows - 3 of 4 - Installing Database Software on All Nodes

by Ed Chen
July 8, 2022September 13, 2022

We click on "setup.exe" in DB home (i.e. C:\app\oracle\product\19.3.0\dbhome_1) to initiate the database software installation. Next, let's see how to create a RAC database 19c… Read More »

How to Build 19c RAC on Windows - 2 of 4 - Installing Grid Infrastructure

by Ed Chen
July 7, 2022September 13, 2022

We click on "setup.exe" in grid home (i.e. c:\app\19.3.0\grid) to initiate the grid infrastructure installation. Post Grid Installation Check C:\Users\Administrator>crsctl stat res -t -------------------------------------------------------------------------------- Name … Read More »

How to Build 19c RAC on Windows - 1 of 4 - Preparing Two Database Servers

by Ed Chen
July 6, 2022September 13, 2022

Earlier, we have talked about how to build a RAC database 19c on Linux platform already. This time, we turn to Windows platform, more specificially,… Read More »

How to Resolve PRVG-10400: The Windows Time service "W32Time" setting

by Ed Chen
July 5, 2022September 13, 2022

PRVG-10400 Prerequisite check of grid installation failed with some errors which include PRVG-10400: The Windows Time service "W32Time" setting. PRVG-10400: The Windows Time service "W32Time"… Read More »

How to Setup Windows Time Service for RAC Database

by Ed Chen
July 4, 2022September 13, 2022

To make Network Time Protocol (NTP) work properly for running a RAC database on all Windows nodes, we should configure Windows Time Service (W32Time) before… Read More »

Where is TNSNAMES.ORA Location

by Ed Chen
January 19, 2022January 17, 2022

What is TNSNAMES? Whenever we need to connect to the database, we usually provide a connection string like this: SQL> conn hr/hr@chicago-db-server:1521/ORCL Connected. Or we… Read More »

Where is ORACLE_HOME Location

by Ed Chen
January 17, 2022January 25, 2022

What is ORACLE_HOME ORACLE_HOME is the location of Oracle database home directory, which contains many important file relationship we may use them very often. To… Read More »

How to Replace OPatch on Windows

by Ed Chen
January 12, 2022June 3, 2022

OPatch Windows Assuming that you have downloaded the latest OPatch from Oracle. Let's see current version of OPatch utility. C:\Users\Administrator>opatch version OPatch Version: 12.2.0.1.15 OPatch… Read More »