Once you have installed LifeKeeper and configured the volume and communication resources, you are ready to install Oracle.
On the Primary Server
- Download the Oracle Database installation media (WINDOWS.X64_193000_db_home.zip for Oracle Database 19c) and extract it to Oracle Home. If the Oracle Home is shared, extract it on a shared disk. If it is non-shared, extract it on a non-shared disk.
- Run setup.exe to start the Oracle installer. Follow the following table as a reference.
Configuration Option | Set Up Software Only | |
Database Installation Options | Single instance database installation | |
Oracle Home User | Use Existing Windows User Ex. SIOS20\oracle |
Specify the user that runs Oracle-related services. Since this user will access the shared disk from the primary and backup servers, we recommend specifying an existing domain user. If you specify a non-domain user, set up the shared disk so that it can be read and written by that user on both servers. |
Installation Location | Oracle Base Ex. E:\app\oracle |
If Oracle Home is shared, specify it on the shared disk; if it is non-shared, specify it on the non-shared disk. |
Others | Any |
- Next, create an Oracle database instance. Start the Database Configuration Assistant to create the database. Follow the following table as a reference.
Database Operation | Create a database | |
Creation Modes | Advanced configuration | If your Oracle Home is non-shared, select Advanced configuration. |
Deployment Type | Database type Oracle Single Instance database |
|
Storage Option | Database files location Ex. E:\oradata\{DB_UNIQUE_NAME} |
If the Oracle Home is non-shared, specify a shared disk. |
Oracle-Managed Files (OMF) | If Oracle Home is not shared, do not select Oracle-Managed Files (OMF). | |
Fast Recovery Option | Fast Recovery Area Ex. E:\fast_recovery_area\{DB_UNIQUE_NAME} |
If the Oracle Home is non-shared, specify a shared disk. |
Network Configuration | If the listener has not been registered yet, register it by creating a new listener. Make the listener name the same as the SID. | |
Others | Any |
- Start the Service manager, then stop the relevant TNSListener service (Oracle<ORAHOME>TNSListener<SID>) and set it to manual.
- Start Net Manager and make the following changes.
- Select the configured Listener from Listeners, and
- Under Listening Locations, change the Network Address to the IP address that protects the Host for TCP/IP Protocol or the DNS host name protected by the route53 resource or DNS resource. For Named Pipes, change the machine name to the LAN Manager alias.
- Add the Database in Database Services and set the Oracle Home Directory, SID.
- Under Listening Locations, change the Network Address to the IP address that protects the Host for TCP/IP Protocol or the DNS host name protected by the route53 resource or DNS resource. For Named Pipes, change the machine name to the LAN Manager alias.
- Select Address Configuration of the applicable SID from Service Naming and change the Host Name of TCP/IP Protocol to the IP address to be protected or the DNS host name protected by the route53 resource or DNS resource. For Named Pipes, change the machine name to the LAN Manager alias.
- Select the configured Listener from Listeners, and
- Start the Service manager and start the appropriate TNSListener service. Make sure you can connect. In the example below, the IP address is 10.1.0.111, the SID is orcl, and the port is 1521.
sqlplus sys/'password'@10.1.0.111:1521/orcl as sysdba
- Start the Service manager and stop the applicable OracleService and TNSListener services to prepare for setting up the backup server.
On the Backup Server
- Switch over protected volumes and communication resources to the backup server.
- If you installed Oracle Home on a shared disk, rename the Oracle Base app directory so that you can install it on the backup server with the same name. If you installed Oracle Home on a non-shared disk, rename the oradata, fast_recovery_area directories on the shared disk so that you can install it on the backup server with the same name.
- Install it in the same way as the primary server. Make sure that the settings are exactly the same as the primary server.
On the Primary Server
- Switch over protected volumes and communication resources to the primary server.
- Start the Service manager and start the appropriate OracleService, TNSListener services.
Post your comment on this topic.