

Upgrading runtime environments to use Oracle 12cR2
If you are using an Oracle 12cR1 database, you can upgrade to an Oracle 12cR2 database
and reconfigure your database settings in your WebSphere Commerce environment.
Before you begin
- Ensure that you have an existing WebSphere Commerce instance and Oracle database.
Procedure
- Upgrade your existing Oracle database to 12cR2.
- Configure your environment to use
ojdbc8
andlibocijdbc12
drivers.- Download the oracle instant client 12.2.0.1 zip file.
- Unzip the install client 12.2.0.1 zip file in temp directory.
- Copy the ojdbc8.jar file to your ORACLE_HOME/jdbc/lib/ directory.
- Copy the libocijdbc12.so file to your ORACLE_HOME/jdbc/lib/ directory.
-
Update your WebSphere Commerce
setenv.sh file.
- Open the following file in a text editor:
- WC_installdir/bin/setenv.sh
- Search for all instances of the
ORACLE_HOME
variable, then update the values to the new Oracle 12cR2 value. For example:ORACLE_HOME=/opt/oracle/app/oracle/product/12.2.0.1/dbhome_1
- Search for all instances of
ORACLE_HOME/jdbc/lib/ojdbc6.jar
and change them toORACLE_HOME/jdbc/lib/ojdbc8.jar
. - Save and close the file.
- Open the following file in a text editor:
- Update your WebSphere Commerce
instance.xml configuration file.
- Open the following file for editing.
- WC_installdir/instances/instance_name/xml/instance.xml
- Update the following database configurations for your Oracle 12cR2 database.
DBAName
- The database administrator name.
DBAPwd
- The database administrator password.
DBHost
- The database host name.
DBServerPort
- The database server port.
DBUserID
- The database user ID.
DBUserPwd
- The database user password.
OracleDataFile
- The path to your Oracle data file.
ServiceName
- The Oracle service name.
name
- The name of your Oracle database.
- Save and close the XML file.
- Use the UpdateEAR Ant target to update the deployed WebSphere Commerce application with your configuration changes.
- Open the following file for editing.
- Update your createInstance.properties file with the updated Oracle
configurations.
- Open the following file for editing.
- WC_installdir/instances/instance_name/properties/createInstance.properties
- Update the following properties with the your Oracle 12cR2 values.
dbaName
- The database administrator name.
dbName
- The database name.
dbHostname
- The database hostname.
dbServerPort
- The database port.
serviceName
- The database service name.
dbUserName
- The database user name.
jdbcURL
- The database JDBC URL.
- Update the
jdbcDriverLocation
property to use the Oracle 12cR2 ojdbc8.jar. For example:/opt/oracle12.2/app/oracle/product/12.2.0.1/dbhome_1/jdbc/lib/ojdbc8.jar
- Save and close the properties file.
- Open the following file for editing.
- Update the WebSphere Commerce environment variable
ORACLE_JDBC_DRIVER_PATH for both the WebSphere Commerce and WebSphere Commerce Search servers.
- Log in to the WebSphere Application Server Administrative console.
- Go to Environment > WebSphere Variables > ORACLE_JDBC_DRIVER_PATH.
- Update the ORACLE_JDBC_DRIVER_PATH value to the Oracle 12cR2 library. For example, /opt/oracle12/app/oracle/product/12.2.0.1/dbhome_1/jdbc/lib.
- Update your WebSphere Commerce Search JDBC and data source.
- Log in to your Search WebSphere Application Server Administrative console.
- Go to Resources > JDBC > Data sources > WebSphere Commerce Search Oracle JDBC Provider instanceName.
- Update the class path value to ${ORACLE_JDBC_DRIVER_PATH}/ojdbc8.jar.
- Go to Resources > JDBC > JDBC providers > WebSphere Commerce Search Oracle DataSource instanceName, then update your data source URL. For example, jdbc:oracle:thin:@//database_hostname:1521/Oracle_SID
- Update your WebSphere Commerce JDBC and data source.
- Log in to your Search WebSphere Application Server Administrative console.
- Go to Resources > JDBC > JDBC providers > InstanceName - WebSphere Commerce JDBC Provider.
- Update the class path value to ${ORACLE_JDBC_DRIVER_PATH}/ojdbc8.jar.
- Repeat steps b and c for JDBC providers instanceName - WebSphere Commerce JDBC Provider for Publish.
- Go to Resources > JDBC > Data sources, open WebSphere Commerce Oracle DataSource instanceName, then update your data source URL. For example, jdbc:oracle:thin:@//database_hostname:1521/Oracle_SID.
- Go to Resources > JDBC > Data sources, open WebSphere Commerce Oracle Publish DataSource instanceName, then update your data source URL. For example, jdbc:oracle:thin:@//database_hostname:1521/Oracle_SID.
d
d Go to Resources > JDBC > Data sources, open WebSphere Commerce Oracle DataSource instanceName, then update your data source URL. For example, jdbc:oracle:thin:@//database_hostname:1521/Oracle_SID
e Go to Resources > JDBC > Data sources, open WebSphere Commerce Oracle Publish DataSource instanceName, then update your data source URL. For example, jdbc:oracle:thin:@//database_hostname:1521/Oracle_SID
- Restart the WebSphere Commerce and WebSphere Commerce Search servers.