I have developed a web application (jsp) using tomcat 5.5.7 with Oracle 10g as the data base. I use the oracle thin driver (ojdbc14.jar). It works fine in tomcat. I am moving the application to Oracle iAS 10g. The following lines of code load the driver in tomcat with the ojdbc14.jar under WEB-INF/lib:
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.7.80:1521:orclaac", uzr, pwd);
The connection is not working from the Oracle application server. It gives the following error:
ORA-12505: TNS:listener could not resolve SID given
Can anyone help with this issue?