WAS 4.0.1 on Oracle 9i ????
GuruMan
WAS - Supported prerequisites and APIs there is only Oracle 8i...???
I have Installed was 4.0.1 successefully with no error...
But every time I try to start the server I get this errorr:
02.12.03 17:14:46:212 GMT+01:00] 55596b64 Server U Version : 4.0.1
[02.12.03 17:14:46:292 GMT+01:00] 55596b64 Server U Edition: Advanced
Edition for Multiplatforms
[02.12.03 17:14:46:312 GMT+01:00] 55596b64 Server U Build date: Thu
Aug 09 00:00:00 GMT+02:00 2001
[02.12.03 17:14:46:322 GMT+01:00] 55596b64 Server U Build number:
a0131.07
[02.12.03 17:14:47:453 GMT+01:00] 55596b64 ORBRas W
com.ibm.CORBA.iiop.Util Util P=86592:O=0:CT JORB0012: Pass by reference has
been set to: true (NoLocalCopies = true)
[02.12.03 17:14:54:303 GMT+01:00] 55596b64 DBMgr F SMTL0026E:
Failure to create a data source: java.sql.SQLException: Io exception:
Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(
CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:361)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
at java.sql.DriverManager.getConnection(DriverManager.java:523)
at java.sql.DriverManager.getConnection(DriverManager.java:183)
at
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:117)
at
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(Oracle
ConnectionPoolDataSource.java:98)
at
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleCo
nnectionPoolDataSource.java:77)
at
com.ibm.ejs.cm.pool.JDBC1xConnectionFactory.createConnection(JDBC1xConnectio
nFactory.java:42)
at
com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:914)
at
com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.
java:846)
at
com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:76
4)
at
com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:6
76)
at
com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:61
0)
at
com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:274)
at
com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:269)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:99)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:206)
at
com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.ja
va:1135)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:943)
at
com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:40
7)
at
com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
ANYBODY CAN HELP ME ???
Mark Ho
> At first, is it possible to install WAS 4.0.1 on Oracle 9i ? Because in the
> WAS - Supported prerequisites and APIs there is only Oracle 8i...???
> I have Installed was 4.0.1 successefully with no error...
Official support for Oracle 9i Release 1 (9.0.1) was introduced with WAS 4.0.3
(check the pre-req web page again, at
http://www-3.ibm.com/software/webservers/appserv/doc/latest/prereq.html)
You will need to apply either this FixPak or the current 4.0.4 level. Oracle 9i
R2 (9.2) is not yet supported.
Your error trace mentions ERR=12505 and a "connection refused". The ORA-12505
error message means:
TNS:listener could not resolve SID given in connect descriptor
Perhaps you have a configuration problem in the tnsnames.ora?
Regards,
Mark
GuruMan
Oracle 9i, or I can have any user with required privileges?
"Mark Ho" <mar...@NOSPAMPLEASE.ca.ibm.com> wrote in message
news:3DEE2EF0...@NOSPAMPLEASE.ca.ibm.com...
Mark Ho
GuruMan wrote:
> Do I have to have a EJSADMIN user in order to install WAS 4.0 prperly on
> Oracle 9i, or I can have any user with required privileges?
I'm not sure if the Oracle user must be named EJSADMIN, but this user does not
require DBA privileges.
Please see the official installation instructions in the WAS InfoCenter (e.g.
http://www-3.ibm.com/software/webservers/appserv/doc/v40/ae/infocenter/was/pdf/win_adv_ihs_oracle_v4.pdf).
Presumably, you can use an Oracle user with a different name, specified by the
com.ibm.ejs.sm.adminServer.dbuser parameter in your admin.config file?
Hope this helps,
Mark
GuruMan
Toni
"Mark Ho" <mar...@NOSPAMPLEASE.ca.ibm.com> wrote in message
news:3DF101A3...@NOSPAMPLEASE.ca.ibm.com...