问题描述:将Oracle数据库作为WebSphere的系统库,按正常程序安装完后,在服务控制台中无法启动WebSphere的Admin Server的服务�
解决问题需注意事项:修改WebSphree安装目录下的admin.config文件中有关Oracle JDBC方面的配置信息�
******************************************************************************
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 parameter 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
***************************************************************************
希望以上信息能对大家有所帮助�
浏览网上本帖子最新内�