Java开发者论坛离线版(http://www.ChinaJavaWorld.com)
主题WebSphere 4.0中将Oracle作为WebSphere的Repository需注意事项

发贴�carnation 发贴时间:Fri Apr 26 17:44:23 CST 2002
内容
这是我在安装WebSphere4�0时遇到的问题�

问题描述:将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

***************************************************************************

 希望以上信息能对大家有所帮助�

浏览网上本帖子最新内�


Copyright Java开发�------www.ChinaJavaWorld.com

回复�simoncn   回复时间:Sat Apr 27 00:19:10 CST 2002
回复内容
IBM已经提供了一个工具:
http://www14.software.ibm.com/webapp/download/postconfig.jsp?id=4001134&pf=Multi-Platform&v=4.0x&e=All+Editions&cat=&s=p&S_TACT=&S_CMP=&p=TDUN-49EVRT


回复�jiangleyang   回复时间:Mon Jun 17 13:33:28 CST 2002
回复内容
多谢�


回复�银狐999   回复时间:Mon Jun 17 15:03:14 CST 2002
回复内容
非常不错,呵呵,很感谀�



Copyright Java开发�:www.chinajavaworld.com(webmaster: [email protected])