Oracle Restart On File System

 

Many people may not be aware of the fact that Oracle restart (OHAS) can be configured on databases that are storing their data on a file system. ASM is not required.

The installation and configuration process took some work to figure out, since Oracle does not document too well, but I did track it down eventually.

In my current environment, I have installed the Oracle database software and created a database using the silent installation method. See the blog here at houseofbrick.com: http://houseofbrick.com/oracle-12-2-0-1-silent-installation/ for instructions on how to do silent installation and database creation.

Next, go to the Oracle website and download the the Grid Infrastructure software.  I noted that for some reason, Oracle has chosen to force you to download what amounts to an entire GI home, so you should place the zip file in the location of your grid directory. eg, if you intend to put the GI home in /u01/app/oracle/grid, place the zip file in /u01/app/oracle/grid.   Then unzip the file, eg:

mkdir –p /u01/app/grid

cp  linuxx64_12201_grid_home.zip /u01/app/grid

unzip linuxx64_12201_grid_home.zip

Next, install the the software.

In the directory /u01/app/grid, run the file gridSetup.sh.  This file requires x-windows.

Choose the setup software only option

 

image

 

On the next screen, select the server.  The server name should be configured in the hosts file.

image

On the next screen accept the defaults. 

image

 

When prompted, choose Yes.

image

Next verify the installation directory.  Its wrong, move the files and start over.  You cannot change it here.

image

 

Next, choose the appropriate option for the root scripts.

image

Verify the prerequisites, correct or ignore as necessary.

image

Choose install on the next screen.

image

Once completed, run the root scripts

 

 

[root@rhel7 grid]# ./root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/grid/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.

To configure Grid Infrastructure for a Cluster or Grid Infrastructure for a Stand-Alone Server execute the following command as oracle user:
/u01/app/grid/grid/gridSetup.sh
This command launches the Grid Infrastructure Setup Wizard. The wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media.

At this point, the GI has been installed.  Note that we had to install only because otherwise the installer will assume that you want to install an ASM instance, and there is now way around that through the installer.

So, our next step is to enable oracle HAS. 

su – root.  Set your environment to your newly installed GI home.  In my case, to make things easier, I put this entry in the oratab:

grid:/oracle/app/grid:N

So as root, I just run oraenv and choose grid:

[root@rhel7 grid]# . oraenv
ORACLE_SID = [root] ? grid
The Oracle base has been set to /u01/app/oracle

Next, run this command to configure and enable has for a file system:

$ORACLE_HOME/perl/bin/perl-I$ORACLE_HOME/perl/lib -I$ORACLE_HOME/crs/install $ORACLE_HOME/crs/install/roothas.pl

The output should look like this:

root@rhel7 ~]# $ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib -I$ORACLE_HOME/crs/install $ORACLE_HOME/crs/install/roothas.pl
Using configuration parameter file: /u01/app/grid/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/crsdata/rhel7/crsconfig/roothas_2017-11-06_02-32-44PM.log
2017/11/06 14:32:49 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user ‘oracle’, privgrp ‘oinstall’..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
CRS-4664: Node rhel7 successfully pinned.
2017/11/06 14:33:31 CLSRSC-330: Adding Clusterware entries to file ‘oracle-ohasd.service’
2017/11/06 14:35:08 CLSRSC-400: A system reboot is required to continue installing.

Next, per the instructions above, reboot the server.

Once the server has been restarted, as root, start the high availability service:

[root@rhel7 grid]# . oraenv
ORACLE_SID = [root] ? grid
The Oracle base has been set to /u01/app/oracle

crsctl start has

Now, as oracle enable has:

crsctl enable has

Finally, add the database and to OHAS:

srvctl add db -db silent -startoption open -oraclehome /u01/app/oracle/product/12.2.0.1/dbhome_1
srvctl start db -d silent
srvctl add listener -l listener -o $ORACLE_HOME
srvctl start listener

At this point, you have successfully installed Oracle HAS (High Availability Services) for a database running on file system.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: