Step-by-Step guide to configure Oracle Database SEHA on a Microsoft Windows platform:

installing Oracle Database Standard Edition High Availability (SEHA) on a Windows platform,

Install Oracle Database SEHA - GUI Mode

Step 1: System Requirements and Setup

1. Hardware and Software Requirements:

• Check that your hardware is suitable for Oracle Database and meets the minimum requirements for CPU, RAM, and disk space.

• Ensure your Windows Server version is supported by the Oracle Database version you intend to install.

1. Windows Configuration:

• Install Windows Server on all intended nodes.

• Setup networking to ensure proper communication between all nodes.

1. Windows Failover Clustering:

• Install the Failover Clustering feature through the Windows Server Manager.

• Configure a new cluster using the Failover Cluster Manager, setting up nodes and storage configurations.

Step 2: Install Oracle Database Software

1. Download Oracle Database Software:

• Obtain the Oracle Database Standard Edition 2 installation files from the Oracle website.

1. Run the Oracle Database Installer:

• Execute setup.exe from the installation media to start the Oracle Universal Installer.

• Select "Create and configure a single instance database" for the installation type.

1. Installation Options:

• Choose "Server Class" for system class.

• For the installation type, select "Typical install" which will include default configurations for a simpler setup.

1. Specify Network and Storage:

• Ensure the database listener is configured to communicate across the cluster.

• Configure storage options, ensuring that database files are placed on shared storage accessible by all cluster nodes. This might involve SAN, NAS, or other storage technologies that support multi-access.

1. Database Configuration:

• Provide necessary details such as global database name, administrative passwords, and other relevant configuration details.

1. Install Database Software on Each Node:

• Repeat the installation process on each node to ensure they all have the Oracle Database software installed.

Step 3: Database Creation and Configuration

1. Create Database:

• Use the Database Configuration Assistant (DBCA) to create a database instance on the primary node. Ensure that data files are located on the shared storage.

• Configure necessary parameters for high availability such as redo logs, undo tablespaces, and others to be redundant across the storage infrastructure.

1. Manual Database Configuration:

• Manually adjust parameters in the init.ora file if specific tuning or settings are required for your environment.

1. Configure Listeners:

• Set up Oracle Net listeners to manage incoming connections to the database. Ensure the listeners are configured to handle connections appropriately across the cluster.

Step 4: Validation and Testing

1. Test Database Connectivity:

• Connect to the database using tools like SQL*Plus or Oracle SQL Developer from different nodes and external systems to ensure connectivity and proper operation.

1. Performance and Stress Testing:

• Perform tests to validate the performance under load and ensure that the database responds well in a clustered environment.

1. Security Configurations:

• Implement necessary security measures, including configuring firewalls, setting up user roles, and applying encryption as needed.

Step 5: Documentation and Regular Maintenance

• Document all configurations, changes, and procedures.

• Set up regular maintenance schedules for updates, backups, and performance tuning.

Install Oracle Database SEHA - SILENT INSTALLATION STEPS

1. Download Oracle Database Software:

• Obtain the Oracle Database Standard Edition 2 installation files from Oracle's official site.

1. Extract Installation Files:

• Use command line to navigate to your downloaded files and extract them: C:\> powershell Expand-Archive -Path "C:\download\oracle_database.zip" -DestinationPath "C:\oracle_installation_files"

1. Start Oracle Universal Installer:

• Launch the Oracle Database setup using the command Line C:\oracle_installation_files\database\setup.exe -silent -responseFile C:\oracle_installation_files\database\response\db_install.rsp

• Modify the db_install.rsp response file beforehand to include your specific installation and configuration settings, such as the Oracle home directory, installation edition, and system class.

Step 3: Create and Configure Database

1. Set Environment Variables:

• Configure Oracle environment variables using the command line: set ORACLE_HOME=C:\app\oracle\product\12.2.0\dbhome_1 set ORACLE_SID=ORCL set PATH=%ORACLE_HOME%\bin;%PATH%

1. Use Database Configuration Assistant (DBCA):

• Create a database using DBCA in silent mode: dbca -silent -createDatabase \ -templateName General_Purpose.dbc \ -gdbName ORCL \ -sid ORCL \ -responseFile NO_VALUE \ -characterSet AL32UTF8 \ -sysPassword SysPassword1 \ -systemPassword SystemPassword1 \ -createAsContainerDatabase false \ -databaseType MULTIPURPOSE \ -automaticMemoryManagement false \ -totalMemory 2000

• Adjust parameters as needed to fit your system's specifications and requirements.

Step 4: Configure Listeners

1. Configure the Listener:

• Use Oracle Net Configuration Assistant (NETCA) or manually edit the listener.ora file: echo LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) > %ORACLE_HOME%\network\admin\listener.ora

1. Start the Listener:

• Use the lsnrctl command to start the listener: lsnrctl start

Step 5: Validation and Testing

1. Connect to Database:

• Test the database connection using SQL*Plus: sqlplus sys/SysPassword1@ORCL as sysdba

• Run a few basic SQL queries to confirm the database is functioning correctly.

Reference Link: Standard Edition High Availability Released - See What's New (oracle.com)