Re: strange oracle problem - please help!!

Can you post the tnsnames.ora from the web server box and the listener.ora from the prod and dev servers? Also, if the tnsnames.ora does not specify IP addresses, but uses machine names can you give details of the name resolution methods (DNS, WINS etc).

When the system is up an running, have you had a look at the connections from the web server? Can you see the sessions against database?

WCK wrote:

> yes.. i have checked all possibilities.. tnsnames, odbc, listener, etc.
> all to no avail. my vendor is baffled and oracle support has given up on my
> side.
> what can possibly happen that can cause this type of strange problem?
>
> is it possible that the data somehow never get committed throughout the
> entire 4 days?
>
> Gordon Cartwright wrote in message <3A810148.13C46DD2_at_yahoo.co.uk>...
> >You don't say what makes you think the .99 database is affected, or where
 the
> >webserver software runs. Assuming the web server is on a different machine,
> >check the config on that box to see which DB it is connecting to.
> >
> >WCK wrote:
> >
> >> My oracle 8.0.6 is running all on NT 4.0 SP6a.
> >>
> >> my environment is like this;
> >> 190.1.1.99 - production environment; PROD instance and database.
> >> 190.1.1.201 - develop environment; PROD instance and database.
> >>
> >> when I am doing shutdown on 190.1.1.201 via svrmgr30, it seems to affect
 the
> >> .99. any idea why this happen? i thought the svrmgr30 affect the local
> >> database environment, even the tnsnames.ora on the .201 doesn't have an
> >> entry for the PROD production but is referred as 99PROD.
> >>
> >> I think it cause a massive connection misdirection as my web server
> >> applications reported alot of errors and seems to respond to the work
 that
> >> I was doing in the development environment.
> >>
> >> How can this be explained? listener? network? spoofing?
> >>
> >> Please help. I am out of ideas already.
> >> abramswee_at_yahoo.com
> >
Received on Thu Feb 08 2001 - 17:15:54 CST