Protecting Oracle

Creating Oracle Resource Hierarchies (Active Node)

1. Log in to the Windows OS on the active node (SIOS20-NODE1) as SIOS20-AD\lkadmin.

2. Launch the PowerShell for administrators and start the stopped Windows Service related to Oracle Database with the following command:
   Check the target Oracle-related services.
   

   PS > Get-Service | ? { $_.Name -match "^Oracle[^ ]" -and $_.StartType -ne "Disabled" } | select Name, Status, StartType
   

   
   Start the Oracle-related services.
   

   PS > Get-Service | ? { $_.Name -match "^Oracle[^ ]" -and $_.StartType -ne "Disabled" } | % { Start-Service -Name $_.Name }
   

3. Launch the LifeKeeper GUI and log in with SIOS20-AD\lkadmin.

4. Create an Oracle resource hierarchy. From the menu bar, click Edit > Server > Create Resource Hierarchy and follow the prompt to enter the following values:

1 : OracleJobSchedulerORCL and None may appear as options. Optional Services are not required at this time, select *None.

5. Once the Oracle resource hierarchy is created, the following screen will be displayed. The IP address and volume resources are children of the parent resource “ORCL”.
   

Creating Oracle Pluggable Database Resource Hierarchies (Active Node)

1. Log in to the Windows OS on the active node (SIOS20-NODE1) as SIOS20-AD\lkadmin.

2. Launch the LifeKeeper GUI and log in as SIOS20-AD\lkadmin.

3. Create an Oracle Pluggable Database resource hierarchy. From the menu bar, click Edit > Server > Create Resource Hierarchy and follow the prompt to enter the values as described in the table below.

4. Once the Oracle Pluggable Database resource hierarchy is created, the following screen will be displayed. Please note that the Oracle resource is a child of the parent resource “pdb-ORCL”.
   

Creating Dependency between LB Health Check Resource and Oracle Pluggable Database Resource

1. Log in to the Windows OS on the active node (SIOS20-NODE1) as SIOS20-AD\lkadmin.

2. Launch the LifeKeeper GUI and log in as SIOS20-AD\lkadmin.

3. Create a parent-child dependency between Gen-LB and pdb-ORCL. Click Edit > Resource > Add Dependency from the menu bar, and follow the prompt to enter the values as described in the table below.

4. Now you have created the dependencies required for the pdb-ORCL resource. The resource hierarchy has been created as follows.