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 development
environment.
Before you begin
- Ensure that you have a working development environment that is set to use and Oracle
database.
Procedure
- Upgrade your existing Oracle database to
12cR2.
- Configure your environment to use
ojdbc7
and
libocijdbc12
.
- Download the oracle instant client
12.1.0.2.0 zip file.
- Unzip the install client 12.1.0.2.0 zip file in temp
directory.
- Copy the ojdbc7.jar file to your
ORACLE_HOME\jdbc\lib\ directory.
- Update your WebSphere Commerce
setdbtype.bat file.
- Open your WCDE_installdir\bin\setdbtype.bat
for editing.
- Search for
%ORACLE_HOME%\jdbc\lib\ojdbc6.jar
, then update the string
to %ORACLE_HOME%\jdbc\lib\ojdbc7.jar
- Save and close the file.
- Run the setdbtype.bat command.
- Start a Windows command prompt and go to the
WCDE_installdir/bin directory.
- Issue the following command:
setdbtype oracle ORACLE_HOME dbName dbAdminID dbAdminPassword dbUserID dbUserPassword [dbHost dbServerPort]
Where:
- ORACLE_HOME
- The root directory of Oracle or the database client, depending on if you have a local or a
remote database.
For example, C:\ORACLE\ORA12
.
- dbName
- The name of the database to use with WebSphere Commerce developer.
If you are using a
remote database, this is the name of the database on the remote database server.
- dbAdminID
- The database administrator ID.
- dbAdminPassword
- The database administrator password.
- dbUserID
- The database user ID.
Important: Do not specify a reserved Oracle
ID user ID. Examples of reserved Oracle IDs include SYSTEM and SYS.
- dbUserPassword
- The database user password.
- dbHost
- For remote database only The fully qualified host name of the
database server.
- dbServerPort
- For remote database only The port number on the database server used
for remote connections.
- Update the
JDBCDriverLocation
in your wc-server.xml
file.
- Open your
WCDE_installdir\WC\xml\config\wc-server.xml file for
editing.
- Locate your
JDBCDriverLocation
setting, and update the value to use
the ojdbc7.jar, as seen in the following example.
JDBCDriverLocation="w:\ORACLE~1\product\121~1.0\client_1\jdbc\lib\ojdbc7.jar"
- Save and close the file.