|
Problem |
Fields in admin.config for Oracle JDBC |
|
Solution |
The following parameters are required to change when using
Oracle as WebSphere repository:
I. Edit the admin.config with the following changes:
1. Add the Oracle JDBC Thin Driver jar file "classes12.zip" to the
AdminServer's classpath
2. Enter the values for the parameters in the section "# Repository
database settings"
# Repository database settings
com.ibm.ejs.sm.adminServer.dbdataSourceClassName=
com.ibm.ejs.sm.adminServer.dbserverName=
com.ibm.ejs.sm.adminServer.dbportNumber=
com.ibm.ejs.sm.adminServer.dbdatabaseName=
com.ibm.ejs.sm.adminServer.dbuser=
com.ibm.ejs.sm.adminServer.dbpassword=
com.ibm.ejs.sm.adminServer.dbdisable2Phase=true
For example:
com.ibm.ejs.sm.adminserver.classpath=C:\download\Oracle\thin\classes12.zip;
/C:/WebSphere/AppServer/properties;C:/WebSphere/AppServer/lib/bootstrap.jar
...
...
...
# Repository database settings
com.ibm.ejs.sm.adminServer.dbdataSourceClassName=
oracle.jdbc.pool.OracleConnectionPoolDataSource
com.ibm.ejs.sm.adminServer.dbserverName=HORIZON
com.ibm.ejs.sm.adminServer.dbportNumber=1521
com.ibm.ejs.sm.adminServer.dbdatabaseName=ORCL
com.ibm.ejs.sm.adminServer.dbuser=ejsadmin
com.ibm.ejs.sm.adminServer.dbpassword=ejsadmin
com.ibm.ejs.sm.adminServer.dbdisable2Phase=true
# URL is only valid for Oracle
com.ibm.ejs.sm.adminServer.dbURL=jdbc:oracle:thin:@HORIZON:1521:ORCL
Notes:
- HORIZON is the hostname of the Oracle Database Server (IP address can
be specified
instead of hostname)
- 1521 is the Oracle Listener port number (default is 1521)
- ORCL is the ORACLE_SID
- ejadmin is the Oracle userid (can be other name).
This userid must be created by Oracle DBA prior to starting WebSphere
II. Edit the setupCmdLine.bat
Add the Oracle JDBC Thin Driver jar file "classes12.zip" to the line
"SET DBDRIVER_JARS".
For example:
SET DBDRIVER_JARS=C:\download\Oracle\thin\classes12.zip
|
|
|
|
|
|
|