• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Stale connection problem on Oracle 8

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I receive a Stale connection when I try to start WAS4.0 FP5 with efix. The server that I am using was working just fine before we changed the IP address of the machine and the IP address of the URL that points to the ORacle DB. I can not get into the Admin client console now to fix it. I hear that you can edit a particular file but I do not know what file to edit. PLEASE HELP!!!
************ Start Display Current Environment ************
WebSphere AE 4.0.5 ptf50246.04 running with process name localhost/__adminServer and process id 5199
Host Operating System is Linux, version 2.4.18-3
Java version = J2RE 1.3.1 IBM build cxia32131w-20021107 ORB130 (JIT enabled: jitc), Java Compiler = jitc, Java VM name = Classic VM
server.root = /opt/WebSphere/AppServer
Java Home = /opt/WebSphere/AppServer/java/jre
ws.ext.dirs = /opt/WebSphere/AppServer/java/lib:/opt/WebSphere/AppServer/classes:/opt/WebSphere/AppServer/lib:/opt/WebSphere/AppServer/lib/ext:/oracleJDBC//jdbc/lib/classes12.zip:/oracleJDBC//jdbc/lib/nls_charset12.zip
Classpath = /opt/WebSphere/AppServer/properties:/opt/WebSphere/AppServer/lib/bootstrap.jar
Java Library path = /opt/WebSphere/AppServer/java/jre/bin:/opt/WebSphere/AppServer/java/jre/bin/classic:/opt/WebSphere/AppServer/java/jre/bin:/opt/WebSphere/AppServer/java/jre/bin/classic:/opt/WebSphere/AppServer//bin:/opt/WebSphere/AppServer//lib::/home/db2inst1/sqllib/lib:/usr/lib
Current trace specification = *=all=disabled
************* End Display Current Environment *************
[6/25/03 20:37:57:655 CEST] 67d5006c Server U Version : 4.0.5
[6/25/03 20:37:57:657 CEST] 67d5006c Server U Edition: Advanced Edition for Multiplatforms
[6/25/03 20:37:57:666 CEST] 67d5006c Server U Build date: Fri Nov 22 00:00:00 CET 2002
[6/25/03 20:37:57:666 CEST] 67d5006c Server U Build number: ptf50246.04
[6/25/03 20:37:58:076 CEST] 67d5006c ORBRas W com.ibm.CORBA.iiop.Util Util P=277798 =0:CT JORB0012: Pass by reference has been set to: true (NoLocalCopies = true)
[6/25/03 20:38:04:212 CEST] 67d5006c ConnectionPoo X CONM6009E: Failed to get connection to the database from datasource (DBMgr).
[6/25/03 20:38:04:219 CEST] 67d5006c 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: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:543)
at java.sql.DriverManager.getConnection(DriverManager.java:194)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:117)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:98)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:77)
at com.ibm.ejs.cm.pool.JDBC1xConnectionFactory.createConnection(JDBC1xConnectionFactory.java:42)
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:1077)
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:983)
at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:921)
at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:789)
at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:723)
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:322)
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:135)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:133)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:102)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:206)
at com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.java:1178)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:408)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1147)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:401)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
[6/25/03 20:38:04:261 CEST] 67d5006c 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(PortabilityLayerImpl.java:263)
at com.ibm.ejs.cm.portability.PortabilityLayerImpl.translateException(PortabilityLayerImpl.java:155)
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:1090)
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:983)
at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:921)
at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:789)
at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:723)
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:322)
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:135)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:133)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:102)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:206)
at com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.java:1178)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:408)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1147)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:401)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
----- Begin backtrace for next
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
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:543)
at java.sql.DriverManager.getConnection(DriverManager.java:194)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:117)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:98)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:77)
at com.ibm.ejs.cm.pool.JDBC1xConnectionFactory.createConnection(JDBC1xConnectionFactory.java:42)
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:1077)
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:983)
at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:921)
at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:789)
at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:723)
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:322)
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:135)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:133)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:102)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:206)
at com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.java:1178)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:408)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1147)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:401)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
 
Ranch Hand
Posts: 219
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There are a couple of prelim checks u should do in this circumstance:
a. Check that the app server/DB server machines can actually see each other.
b. It could be that u had set up the Oracle Connection properties through a HOSTNAME and mapped this to an IP in the hosts file ( one unix it is at /etc/ directory). Check this.
c. If by any chance u have an oracle client available on the app server, check u can connect thru it.
d. also check the admin.config file at /usr/WebSphere/AppServer/bin directory to check there is something amiss here.
Reply back if u are still having problems.
 
Nagendra Prasad
Ranch Hand
Posts: 219
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Just another set of checks on the Oracle Server:
(Found this on Oracle Metalink).
Hi,
The error can be raised due to many reasons.
a)Verify the connect string
b)Make sure the listener is configured correctly.
c)Make sure the listener is up and running.
d)Is the database configured for Multithreaded Server (MTS)? If so refer to Note: 139775.1
Note: 139775.1 JDBC Connection Failure: Network Adapter Could not
Establish Connection
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic