Failed to get connection to the database from datasource (DBMgr).

[Siddharth]

Hi,

I'm a new websphere user and am having trouble starting up the admin server.
I installed Websphere 4.0.1 and then applied the 4.0.2 patch.

When trying to startup the admin server (I've disabled it from starting up
in Windows as a service), I get the following error.
I'm using Oracle 8.1.6.

Any help?

-Siddharth

************ Start Display Current Environment ************
WebSphere AE 4.0.2 a0150.05 running with process name sgd/__adminServer and
process id 2080
Host Operating System is Windows 2000, version 5.0
Java version = J2RE 1.3.0 IBM build cn130-20010925was (JIT enabled: jitc),
Java Compiler = jitc, Java VM name = Classic VM
server.root = C:\IBM\WebSphere\AppServer
Java Home = C:\IBM\WebSphere\AppServer\java\jre
ws.ext.dirs =
C:/IBM/WebSphere/AppServer/java/lib;C:/IBM/WebSphere/AppServer/classes;C:/IB
M/WebSphere/AppServer/lib;C:/IBM/WebSphere/AppServer/lib/ext;C:/oracle/ora81
/jdbc/lib/classes12.zip;C:/oracle/ora81/jdbc/lib/nls_charset12.zip
Classpath =
C:/IBM/WebSphere/AppServer/properties;C:/IBM/WebSphere/AppServer/lib/bootstr
ap.jar
Java Library path =
C:\IBM\WebSphere\AppServer\java\bin;.;C:\WINNT\System32;C:\WINNT;C:\\IBM\\We
bSphere\\AppServer\\bin;C:\\oracle\\ora81\\bin;C:\\IBM\\WebSphere\\AppServer
\\java\\bin;C:\Program
Files\ibm\gsk5\lib;c:\sybase\OCS-12_0\dll;c:\sybase\OCS-12_0\bin;c:\sybase\A
SEP;C:\oracle\ora81\bin;C:\Program
Files\Oracle\jre\1.1.7\bin;C:\PROGRA~1\MKSTOO~1\bin;C:\PROGRA~1\MKSTOO~1\bin
\x11;C:\PROGRA~1\MKSTOO~1\mksnt;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32
\Wbem;C:\Program Files\Hummingbird\Connectivity\7.10\Accessories\;C:\Program
Files\Rational\common;C:\Program Files\Rational\Rose\TopLink\;C:\Program
Files\Rational\Rational Test;C:\Program
Files\Rational\ClearCase\bin;C:\Program
Files\Vantive32;c:\sybase\SQLRemote\dll;f:\cases\utils;C:\Program
Files\Microsoft SQL Server\80\Tools\BINN;C:\IBM\WebSphere\AppServer\bin
Current trace specification = *=all=disabled
************* End Display Current Environment *************
[6/20/02 11:23:53:459 PDT] 4d000e19 Server U Version : 4.0.2
[6/20/02 11:23:53:469 PDT] 4d000e19 Server U Edition: Advanced
Edition for Multiplatforms
[6/20/02 11:23:53:469 PDT] 4d000e19 Server U Build date: Tue Dec 18
00:00:00 PST 2001
[6/20/02 11:23:53:479 PDT] 4d000e19 Server U Build number: a0150.05
[6/20/02 11:23:54:250 PDT] 4d000e19 ORBRas W com.ibm.CORBA.iiop.Util
Util P=433709:O=0:CT JORB0012: Pass by reference has been set to: true
(NoLocalCopies = true)
[6/20/02 11:23:59:137 PDT] 4d000e19 ConnectionPoo X CONM6009E: Failed to get
connection to the database from datasource (DBMgr).
[6/20/02 11:23:59:167 PDT] 4d000e19 StaleConnecti A CONM7007I: Mapping the
following SQLException, with ErrorCode 17,002 and SQLState <null>, to a
StaleConnectionException: java.sql.SQLException: Io exception: The Network
Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:263)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:523)
at java.sql.DriverManager.getConnection(DriverManager.java:183)
at
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:111)
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:954)
at
com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.
java:896)
at
com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:81
4)
at
com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:7
20)
at
com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:65
4)
at
com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:307)
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:122)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:120)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:100)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:206)
at
com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.ja
va:1156)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at
com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:40
8)
at
com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1125)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:392)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[6/20/02 11:23:59:267 PDT] 4d000e19 DBMgr F SMTL0026E: Failure to
create a data source: com.ibm.websphere.ce.cm.StaleConnectionException: Io
exception: The Network Adapter could not establish the connection
at java.lang.reflect.Constructor.newInstance(Native Method)
at
com.ibm.ejs.cm.portability.PortabilityLayerImpl.translateException(Portabili
tyLayerImpl.java:192)
at
com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:965)
at
com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.
java:896)
at
com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:81
4)
at
com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:7
20)
at
com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:65
4)
at
com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:307)
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:122)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:120)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:100)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:206)
at
com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.ja
va:1156)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at
com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:40
8)
at
com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1125)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:392)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[6/20/02 11:23:59:407 PDT] 4d000e19 SystemOut U SMTL0026E: Failure to
create a data source: com.ibm.websphere.ce.cm.StaleConnectionException: Io
exception: The Network Adapter could not establish the connection
at java.lang.reflect.Constructor.newInstance(Native Method)
at
com.ibm.ejs.cm.portability.PortabilityLayerImpl.translateException(Portabili
tyLayerImpl.java:192)
at
com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:965)
at
com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.
java:896)
at
com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:81
4)
at
com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:7
20)
at
com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:65
4)
at
com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:307)
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:122)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:120)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:100)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:206)
at
com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.ja
va:1156)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at
com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:40
8)
at
com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1125)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:392)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[Ken Hygh]

This basically means there's a network problem contacting the admin
database.

You may have the wrong URL for the admin database, either wrong port or
machine name. Or, there's a firewall blocking the communication. Or, the
userid running WAS can't open that port number on the local machine.

Ken

[Siddharth]

I was able to connect OK to the oracle db via SQL plus.
Wouldn't that mean that the user/password, port, machine and dbname are all
OK?

Thanks.

"Ken Hygh" <ken...@nc.rr.com> wrote in message
news:3D1260F...@nc.rr.com...

[Siddharth]

Thanks for your help Ken.
I've figured out the problem. The oracle thin driver's conn string was
incorrect.

-Siddharth

"Siddharth" <sg...@hotmail.com> wrote in message
news:aevj16$11ds$1...@news.boulder.ibm.com...