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.
- Update your WebSphere Commerce
instance.xml configuration file.
- Update your createInstance.properties file with the updated Oracle
configurations.
- 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 .
- 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 .
- Update the class path value to ${ORACLE_JDBC_DRIVER_PATH}/ojdbc8.jar.
- Go to jdbc:oracle:thin:@//database_hostname:1521/Oracle_SID , then update your data source URL. For example,
- Update your WebSphere Commerce JDBC and data source.
- Log in to your Search WebSphere Application Server Administrative console.
- Go to .
- 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 jdbc:oracle:thin:@//database_hostname:1521/Oracle_SID. , open WebSphere Commerce Oracle DataSource instanceName, then update your data source URL. For example,
- Go to jdbc:oracle:thin:@//database_hostname:1521/Oracle_SID. , open WebSphere Commerce Oracle Publish DataSource instanceName, then update your data source URL. For example,
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.