we are using a PL/SQL package. This package is compiled in one schema and it is accessible in another schemas also. The problem we are getting is "Network Adapter could not establish the Connection" when we try to run this package in both the schemas. We are getting this problem alternatively i.e once this procedure is able to execute successfully and once giving the exception mentioned above.
Here the procedure which we are executing inturn calls a java stored procedure and the java stored procedure calls the java class and in this java class we are giving database connection to connect to the database.
The exceptions we are getting are as follows :
Process err :java.sql.SQLException: Io exception: The Network Adapter could not establish the
Process err : at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
Process err : at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
Process err : at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273)
Process err : at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)
Process err : at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:365)
Process err : at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)
Process err : at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
Process err : at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:563)
Process err : at java.sql.DriverManager.getConnection(DriverManager.java:582)