REPOST: Re: ora-12560 error when running IIS5 ASP pages

Comments embedded

"Karina Wang" <kwang_at_wi.rr.com> wrote in message news:697da9d.0112272039.24c9006b_at_posting.google.com...
> Hi,
>
> I ran into some database connection problems with the web site I am
> developing.
>
> The web site is hosted by IIS5 on a Win2000 server. The web pages are
> written in ASP, using ADODB to connect to the database(8.1.6) which
> resides on a different machine remotely. Oracle ODBC is being used to
> connect to the database.
>
> The application protection is set to Medium.
>
> 1. The web site is assigned an internet IP address and an intranet IP
> address (for testing purposes). On the web server, I have been able
> to connect to the web site using the INTERNET IP address. However, on
> any other workstations, I always get the ORA-12560 error.

The other workstations don't have a proper tnsnames.ora, so try to connect to the default database.
>
> 2. Some times when I connect to the web site using the INTRANET IP
> address, I also get the Ora-12560 or the ORA-12535 error (12535 often
> occurs after the 12560 error).
>
>

The INTERNET IP address has been hardcoded into the tnsnames.ora on the application servetr

> I had some guesses, but none seems to be conclusive:
> 1. Bad network connections to the database server. The database
> server is located at a remote site. The bandwidth between our site
> and the remote site (intranet) is very limited and we have seen a lot
> of slow down in connection. However, I have never experienced such
> problem with the connections from the developers' machines, which all
> connect to the same database server. In addition, this can not
> explain why I was never able to make a successful connection using the
> internet IP address from other workstations.

Usually not an issue
>
> 2. Multiple concurrent users on the web server. I did some tracing
> and found the error occurs even when there is only one connection
> attempt.

This is again not an issue. You would have received ORA-12500
>
> 3. Insufficient permissions on establishing TCP/IP connection to the
> web server. However, this does not explain why sometimes I can
> connect and why sometimes I can not.

This is not the issue as you connect from the application server to the database server, NOT the webserver.
>
> Any idea on the cause or how to diagnose the problem is greatly
> appreciated.
>
> Thank you.
>
> Karina

You shouldn't try to complicate it from the start by using 2 IP addresses. Try to get it working with one IP address first.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

========= WAS CANCELLED BY =======:
Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: "Sybrand Bakker" <postbus_at_sybrandb.demon.nl>
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <u2oia6ar3k4ree_at_corp.supernews.com>
Control: cancel <u2oia6ar3k4ree_at_corp.supernews.com>
Date: Mon, 31 Dec 2001 08:46:55 GMT
Organization: The World's Usenet -- http://www.Supernews.com
Lines: 2
Message-ID: <cancel.u2oia6ar3k4ree_at_corp.supernews.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009790227 28060 166.102.15.34 (31 Dec 2001 09:17:07 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 09:17:07 GMT
X-No-Archive: yes
Comment: Anarchy! Fuck You!
X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1
X-Unacanc3l: yes

This message was cancelled from within Mozilla...not