imported>Jason.nicholls at 18:26, 17 July 2014

2014-07-17T18:26:23Z

← Older revision		Revision as of 18:26, 17 July 2014
Line 1:		Line 1:
			{{DISPLAYTITLE:Database Failover}}
			[[Category:enPortal legacy]]
	This page details the steps for configuring the enPortal 4.x system to fail over during an outage to a backup system.		This page details the steps for configuring the enPortal 4.x system to fail over during an outage to a backup system.

imported>Jason.nicholls: moved Database Failover to enportal/legacy/database failover

2014-07-17T18:25:52Z

moved Database Failover to enportal/legacy/database failover

← Older revision	Revision as of 18:25, 17 July 2014
(No difference)

imported>Mike.berman: created page

2013-04-01T09:53:54Z

created page

New page

This page details the steps for configuring the enPortal 4.x system to fail over during an outage to a backup system.

==Database Configuration==

This section outlines the procedures for converting the database configuration from a standard, single-node enPortal system to a multi-node system that can fail over to a backup database in the event that the primary database server becomes unavailable.

The examples in this section use an Oracle database. This is the most common database platform used with enPortal systems that support failover.

===Implement Pre-requisites===

Perform the following steps prior to making any changes to the enPortal configuration:

* Verify that the portal is running and properly connecting to the Oracle database using the standard thin client configuration in <tt>$PORTAL_HOME/config/persist.properties</tt>.
* Go to the Oracle website. Download and install the Oracle client into <tt>/opt/oracle/</tt>.

{{Tip|Oracle Instant Client is a minimal Oracle installation that contains the JDBC libraries, OCI libraries, SQLplus library, and other basic core components. This installation is sufficient for enPortal’s needs, and is much smaller than the full Oracle Client package. Make sure sqlplus is downloaded as part of Oracle Instant Client package.}}

* Determine if there is a folder <tt>$PORTAL_HOME/xmlroot/server/backup/</tt> that represents the current data in the database. If not, you should create this folder as a database backup by navigating to <tt>$PORTAL_HOME/bin/</tt> and executing the <tt>portal XMLexport</tt> command.
* Obtain a template Oracle configuration file <tt>tnsnames.ora</tt>, and place it in <tt>/opt/oracle/</tt>.

===Configure Database Failover Connections===

You must update the Oracle and enPortal configuration files to instruct the system how to fail over from the primary database to the alternate database. To do this, perform the following steps:

* Edit the file <tt>/opt/oracle/tnsnames.ora</tt>.
** Provide an '''ADDRESS''' line for each database in the failover sequence. Enter the appropriate host and port for each database.
** Enter the appropriate '''SERVICE_NAME''' for connecting to the database.

* Verify that the <tt>LD_LIBRARY_PATH</tt> variable contains a path to the libraries downloaded as part of Instant Client. One way to do this is to just make links from <tt>/usr/lib/</tt> to all of the libraries included in the Instant Client download. The reason is that <tt>/usr/lib/</tt> is by default in the <tt>LD_LIBRARY_PATH</tt>, so just linking in these libs will automatically make them available.
** Example: Instant Client downloaded to <tt>/opt/oracle/</tt>, and there was a lib in that directory called <tt>libodbc.so</tt>. Create a link in the <tt>/usr/lib/</tt> directory by executing the command: <tt>ln -s /opt/oracle/libodbc.so /usr/lib/libodbc.so</tt>.
** Repeat for each library in the Instant Client package.

* Use the <tt>sqlplus</tt> command line tool to verify that a connection to database is working as configured in <tt>tnsnames.ora</tt>.
** Make sure you have the directory where you downloaded the package in your <tt>LD_LIBRARY_PATH</tt>, and make sure the <tt>TNS_ADMIN</tt> variable is also set to that same install directory.
** From the directory where you downloaded the Instant Client package, execute the following command: <tt>./sqlplus username@DB_NAME</tt> where <tt>''username''</tt> is a valid password to the portal database, and <tt>''DB_NAME''</tt> corresponds to the entry in your <tt>tnsnames.ora</tt> file for the portal. A prompt for the portal password will display.
** If you enter the correct password, you should have command-line SQL access to the Database. This will verify that the <tt>tnsnames.ora</tt> file is configured correctly.

* Edit the file <tt>$PORTAL_HOME/config/persist.properties</tt>.
** Verify that <tt>persisting=true</tt>.
** Update the <tt>db.driver: oracle.jdbc.driver.OracleDriver</tt>.
** Update the <tt>db.URL: jdbc\:oracle\:oci\:@TNSLABEL</tt> where <tt>''TNSLABEL''</tt> is the label for the failover configuration to use in the <tt>tnsnames.ora</tt> file.

* Edit the portal start script <tt>$PORTAL_HOME/bin/portal</tt>. Add the parameter <tt>tns_admin=opt/oracle</tt>.

===Re-start enPortal===

Restarting enPortal will test whether the changes are successful.

{{Tip|Develop a thorough understanding of the procedures in this section on a test system before deploying any changes to your production system.}}

Perform the following steps to re-start enPortal:

# Confirm whether the database you will be using under the new configuration already contains the portal data.
#* If the database already contains data, then make sure there are not any load*.txt files under <tt>$PORTAL_HOME/xmlroot/server/</tt>. These files should all be renamed with alternate extensions such as .completed.
#* If enPortal will now be connecting to a new (empty) database, verify the existence of the file <tt>$PORTAL_HOME/xmlroot/server/load_restore.txt</tt>. This file will load all of the XML data from <tt>$PORTAL_HOME/xmlroot/server/backup/</tt> into the new database.
# Navigate to <tt>$PORTAL_HOME/bin/</tt>.
# Execute the command: <tt>portal portalstop</tt>.
# Execute the command: <tt>portal portalstart</tt>.
# Review the output to the terminal for indication of a successful database connection.
# Open a browser from a location with network access to the portal web server. Navigate to the URL: <tt>https://hostname:port</tt>. If the system login page is displayed, this confirms that the portal made a successful connection to the database.

Enportal/legacy/database failover - Revision history

imported>Jason.nicholls at 18:26, 17 July 2014

imported>Jason.nicholls: moved Database Failover to enportal/legacy/database failover

imported>Mike.berman: created page