#2 Connection not established..

[Anonymous]

I just came across you utility.. Seems pretty handy.. However I can't get this working.
When I type the following I get ..
I am using it with APPS. also the plsql version installation are clear however how to use it, are not clear..
http://erpdevapp:8012/OA_HTML/US/dbwa.jsp

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:284)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:375)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at _oa__html._us._dbwa._jspService(_dbwa.java:766)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java)
at oracle.jsp.JspServlet.internalService(JspServlet.java)
at oracle.jsp.JspServlet.service(JspServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:314)
at org.apache.jserv.JServConnection.run(JServConnection.java:188)
at java.lang.Thread.run(Thread.java:484)

I have made the connection change as mentioned in the readme.. what is that I am missing.

Here is how my what the jsp looks like..

[Matt Palmerlee]

Logged In: YES
user_id=222242

I am sorry I didn't notice this support request earlier,
from what I can tell, there must be some sort of issue with
either how you are accessing dbwa.jsp or how
apache/jsp/oracle are communicating...
Is it possible for you to try the PL/SQL Package version of DB
Web Admin?

I'll look into this further and let you know.
-Matt

[Matt Palmerlee]

Logged In: YES
user_id=222242

A couple of questions for you...
1) What version of the Oracle Apps are you using (i.e. 11i)
2) What Apache is it? (i.e. Oracle 9iAS)
3) Can you get any other .jsp pages talking to Oracle?

thanks,
-Matt

[Matt Palmerlee]

Logged In: YES
user_id=222242

Can you show me how you customized the connection line
(remove the password) that you are using:

//Replace Connection Info Here:
conn =
DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=oracle)))",
"system", "manager");

Make sure you use the definition from your tnsnames.ora file
to get the information to put into the connection string.
If your TNSEntry for this instance looks like:

dev.world = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1522))
(CONNECT_DATA=(SID=dev))

then make sure your connection string looks like:
conn =
DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1522))(CONNECT_DATA=(SID=dev)))",
"system", "manager");

Hope this helps,
-Matt

[Matt Palmerlee]

Logged In: YES
user_id=222242

If you are trying to figure out how to use the PL/SQL
version, and don't know what URL to use, I realize I forgot
to put instructions on how to access the PL/SQL version....

Try the following for the PL/SQL package
http://erpdevapp:8012/pls/sid/YNH_DB_WEB_ADMIN.dba_utils

Replace 'sid' with the SID for your instance (i.e. test or
prod) and YNH_DB_WEB_ADMIN with what you named your package.

-Matt