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.
| Code Block |
|---|
|
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.
| Code Block |
|---|
| title | /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>
.
.
. |
| Code Block |
|---|
| title | /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))))
.
.
. |