Oracle 10g connectivity issue with .net 2.0 website hosted on win 2008 server
-
Hi guys, PLZ help me! Scenario - My client has 2 server machine. one is database server with oracle 10g database 64-bit. Another server(new one) is windows 2008 server which has an .net 2.0+3.5 website hosted. This website make use of System.data.oracleClient dll . Problem is that this app is not able to connect to oracle 10g database server though it is able to connect to some other 11g R2 database server. On this app server we have also tried to install oracle 10g 32-bit client but still can't access. Tnsping and sqlplus is working fine. Pls. suggest. Solution that we tried :- - Gave permission and added various users to oracle directory and sub-directory like IIS_Iuser,network service, anonymous etc. Possible culprit:- - Earlier on this app server oracle 11g 32-bit client was installed. So my client has although worked on to remove it by manually deleting folder , deleting registeries , extra home directories. but it looks like a possible reason to me.. Note - we use some internal ddl for dataaccess , so im not able to see actual error just some OLEDB exception. Pls help
-
Hi guys, PLZ help me! Scenario - My client has 2 server machine. one is database server with oracle 10g database 64-bit. Another server(new one) is windows 2008 server which has an .net 2.0+3.5 website hosted. This website make use of System.data.oracleClient dll . Problem is that this app is not able to connect to oracle 10g database server though it is able to connect to some other 11g R2 database server. On this app server we have also tried to install oracle 10g 32-bit client but still can't access. Tnsping and sqlplus is working fine. Pls. suggest. Solution that we tried :- - Gave permission and added various users to oracle directory and sub-directory like IIS_Iuser,network service, anonymous etc. Possible culprit:- - Earlier on this app server oracle 11g 32-bit client was installed. So my client has although worked on to remove it by manually deleting folder , deleting registeries , extra home directories. but it looks like a possible reason to me.. Note - we use some internal ddl for dataaccess , so im not able to see actual error just some OLEDB exception. Pls help
abhi17_6 wrote:
Problem is that this app is not able to connect to oracle 10g database server though it is able to connect to some other 11g R2 database server.
A connectivity issue is not normally a code issue. Causes - There is in fact no way to connect from server A to B. Perhaps because of firewall or IP routing. - The host and/or port used on the client is wrong. Simple test... - Log in to the client box. - Telnet to the Oracle box using the exact same host and port of the connection data. If telnet connects then you probably have connectivity. If not then it is one of the above - don't look at code until the telnet test works. It might work for you and not work for a server depending on the user the server runs under and how you logged in.
-
abhi17_6 wrote:
Problem is that this app is not able to connect to oracle 10g database server though it is able to connect to some other 11g R2 database server.
A connectivity issue is not normally a code issue. Causes - There is in fact no way to connect from server A to B. Perhaps because of firewall or IP routing. - The host and/or port used on the client is wrong. Simple test... - Log in to the client box. - Telnet to the Oracle box using the exact same host and port of the connection data. If telnet connects then you probably have connectivity. If not then it is one of the above - don't look at code until the telnet test works. It might work for you and not work for a server depending on the user the server runs under and how you logged in.
@jshell - we have installed oracle client 10g 32 bit also on web app server machine. and my client is able to do tnsping and use sqlplus here. Questions- - do i need to use telnet utility from my App server or from my oracle server machine? u mentioned client box, which one is it?
-
@jshell - we have installed oracle client 10g 32 bit also on web app server machine. and my client is able to do tnsping and use sqlplus here. Questions- - do i need to use telnet utility from my App server or from my oracle server machine? u mentioned client box, which one is it?