Exadata Configuration
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)))) . . .