Re: Oracle TNS error

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<9r9ta.12953$MJ5.6230_at_fed1read03>...
> Carol wrote:
> > Thanks for your replies
> >
> > I am sorry for not being clearer. I have 2 databases db1 and db2.
> > db1 is accessed by an internal network only, db2 is accesses by the
> > internal network and the other network, its only db2 that is having
> > the problems, db1 remains unaffected.
>
> So we can ignore db1 & concentrate on db2.
>
> Keep in mind that when bouncing the Oracle Listener,
> existing connections are NOT affected. The only "disruption"
> is that new connections can not be made while the listener
> is down.
>
> More fault isolation is needed.
> When the problem occurs, which set of users see the errors (first);
> the users on the internal or those on the "other" network?
>
> When the problem occurs what happens if/when you use SQL*PLUS
> and SQL*Net to acess db2 from both the internal network & the
> other network?

Checking the ORA-28546 error, I find dome postings that it may be related to a V7 client accessing a V9 database (in particular with db links).
Could it be one of your clients uses the V7 network stack?

Regards,
frank van Bortel Received on Sun May 04 2003 - 21:10:23 CEST