ora 9.i asp.net cannot connect



Hey experts,

I have ASP.NET 1.1 , IIS and oracle client 9.1 installed on 4 servers
(all w2k3). On all servers we have an website that connects to 4
different databases (all on AIX). The 4 servers are test1, development,
production, test2
I use a config file with the databasenames, userid and Password to
connect to 4 different databases. The rest is identical.
BUT. When I use "test1" and "dev" it works fine on any of the servers.
When I use "test2" it doesn't work on any of the servers.
I was able to get "Production" running after a lot of uninstalling
installing, rebooting, changing security on the ora\bin directory.
Suddenly it worked on one server but not on any other.
Sometimes it says cannot find protocol and sometimes it states that the
datbase cannot be found. Using TNSPING or SQLPLUS I can allways connect
to all databases on all servers.
Does anybody know where I should be looking to correct this
unpredictable situation? I'm at a complete loss here.

Ivo

.



Relevant Pages

  • RE: Moving SQL Server 2000 to a new machine
    ... Currently I do have a test domain which is isolated from our production ... The 2003 servers running SQL Server 2000 will be name the same as ... databases and selected user databases on the production servers are being ...
    (microsoft.public.sqlserver.server)
  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SAN (NetApp SnapMirror) replicated Exchange databases usability
    ... to stage Exchange 2007 servers at siteB with SG's and databases that are ... This is achieved by having Exchange ...
    (microsoft.public.exchange.design)
  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... that be the case then I would still work to consolidate the databases ...
    (comp.databases.oracle.server)

Loading