Jul 202011
Oracle Weblogic Server
If you are getting below java sql exception error while testing or configuring the weblogic datasource then follow below steps to fix the issue.
####<Jul 19, 2011 5:50:35 AM EDT> <Warning> <JDBC> <techpaste.inc.com> <yora_56> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1311069035011> <BEA-001129> <Received exception while creating connection for pool "pageDataSource": Io exception: The Network Adapter could not establish the connection>

####<Jul 19, 2011 5:50:35 AM EDT> <Info> <JDBC> <techpaste.inc.com> <yora_56> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1311069035011> <BEA-001156> <Stack trace associated with message 001129 follows:

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387

Above java sql exception error usually comes when the weblogic server is not able to connect/ping datasource configured database. Below are few points to check to avoidt his kind of errors:

1. Check the datasource parameters like db url and query to test the database is up or not.

2. check from the server machine the DB host is ping-able or not. If not add the defined db hostname and ip address to the hosts file in the server.

3.  Check whether there is any N/W outage is there or not.

4. check DB is up and Running or not.

5. Check the servers N/w adapters are online and ready to accept and send requests. If you find problem restart the network adapter and check once again.

6. If all above does not solve the problem then restart the managed server and check.

© Incase of any copyright infringements please check copyrights page for faster resolutions.

  2 Responses to “java sql sqlexception in weblogic datasource”

  1. hello, i have tries the script, for Autodeployment using WLST – manageApplication.py script
    tell me – is the SCript meant for Devlopment Mode of WLS ?? can i run it under Prod Mode ?
    because Prod Mode Involves Starting – stopping of Server -before And After Installing Wars. & the Script failed at the point with Residing the Error;
    ” [Deployer:149140]The task cannot be processed further until the current edit session is activated. When this occurs, task processing will continue. The user can exit the deployer tool without affecting the task………………………………………………………………………………………..No stack trace available.
    This Exception occurred at Fri Mar 11 11:17:33 IST 2016.
    weblogic.management.scripting.ScriptException: Error occured while performing deploy : The action you performed timed out after 300,000 milliseconds.
    Error during the deployment of HISQC_16″

    • Please check if you have lock & edit already activated in weblogic admin console. You have to release the lock first before running the script.

      Login to weblogic admin console and click on release configuration button to release the existing lock.

Leave a Reply

Show Buttons
Hide Buttons