Exadata Configuration

Owned by David Chudnow (Deactivated)
Last updated: Jun 03, 2019
2 min read

Overview

There are several steps necessary to migrate KFS and Rice from AIX to Exadata. 

  • Contact the DBA team and request the environmental KFS and KR schemas be copied to the Exadata platform.
  • Provide the DBA team the dns names of the servers that require access to Exadata so they can request firewall access.
  • Edit the tnsnames.ora file and provide the appropriate connection information (see Server Configuration)
  • Modify the database.url parameter in the /srv/uconn_configs/rice-config/rice-config.xml file on the rice server and the /srv/uconn_configs/kfs-config/security/security.properties on the KFS server (see Application Configuration)

Server Configuration

Edit the file $ORACLE_HOME/network/admin/tnsnames.ora and replace existing connection strings with the following.

Replace kfs<environment>  with the appropiate environmental designation and <service-name> with the database serivce name.

tnsnames.ora
kfs<environment> 
  (DESCRIPTION=
    (LOAD_BALANCE=YES)
    (FAILOVER=ON)
    (ADDRESS=(PROTOCOL=TCP)(HOST=exa02-scan.uits.uconn.edu)(PORT=1521))
    (CONNECT_DATA=
      (SERVICE_NAME=<service-name>)
      (FAILOVER_MODE=
        (TYPE=SELECT)
        (METHOD=BASIC)
        (RETRIES=20)
        (DELAY=5)
      )
    )
  )

KFSORA.world =
  (DESCRIPTION=
    (LOAD_BALANCE=YES)
    (FAILOVER=ON)
    (ADDRESS=(PROTOCOL=TCP)(HOST=exa02-scan.uits.uconn.edu)(PORT=1521))
    (CONNECT_DATA=
      (SERVICE_NAME=<service-name>)
      (FAILOVER_MODE=
        (TYPE=SELECT)
        (METHOD=BASIC)
        (RETRIES=20)
        (DELAY=5)
      )
    )
  )


Application Configuration

Replace <service-name> with the database serivce name.

/srv/uconn_configs/rice-config/rice-config.xml 
.
.
	<param name="datasource.ojb.platform">Oracle9i</param>
	<param name="datasource.platform">org.kuali.rice.core.framework.persistence.platform.OracleDatabasePlatform</param>
    <param name="datasource.driver.name">oracle.jdbc.driver.OracleDriver</param>
	<param name="datasource.url">jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=exa02-scan.uits.uconn.edu)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<service-name>)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=20)(DELAY=5))))</param>
.
.
.


/srv/uconn_configs/kfs-config/security/security.properties
.
.
#
# common datasource
#

datasource.driver.name=oracle.jdbc.OracleDriver
datasource.driver=oracle.jdbc.OracleDriver
datasource.url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=exa02-scan.uits.uconn.edu)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<service-name>)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=20)(DELAY=5))))
.
.
.