RE: Interesting Situation
- From: Riyaj Shamsudeen <rshamsud@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 05 Aug 2004 11:33:07 -0500
Do you have MTS on this database ? Check the MTS configuration, probably
that is pointing to the wrong listener..
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sanjay Mishra
Sent: Thursday, August 05, 2004 11:07 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Interesting Situation
Problem is resolved as I found that there are seven
Service handler been coming in the lsnrctl status and
this is Oracle 8. So I bounce the listener and
everything is fine now. Anybody can comment as how it
is linked that is redirecting the connection to
another database
Thanks
--- Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:
>
> I have two Database server D1 and D2 and both have
> Netscape web server like N1 and N2. I am running one
> of the Perl script on both N1 and N2. N1 is having
> all
> configuration pointed to D1 as local to the server
> and
> N2 is pointing to D2. Today I notice that if I
> Refresh
> this Perl script on N1 , it query the database D1
> and
> show the output on the page. But If I refresh few
> time, it goes to D2 and give me the output which is
> incorrect as D1 is secondary and contain offline
> content and D2 is primary and contain Live Data.
> THis
> happen after every few refreshes. Here is some of
> the
> troubleshootin been done
>
> 1) grep the Environment variable and all Host as
> well
> SID, TNS_ADMIN etc point to D1
> 2) Web server Access log also show that each refresh
> has gone to N1 and nothing been redirected to N2 as
> mine Local PC IP address is not coming on N2
> Webserver
> Log file
> 3) Listener.log on N1 shows that all connection on
> each refresh is going to Database D1 and when I am
> getting the False or wrong output of D2on D1 screen,
> I
> have seen that connection first been gone to D1 and
> then to D2
> 4) There is no public database link on D1
> 5) There is no eaxtra tnsnames.ora entry on D1 for
> any
> database except Local
>
>
> Any Other tip or thought
>
> TIA
> Sanjay
>
>
>
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - Send 10MB messages!
> http://promotions.yahoo.com/new_mail
>
----------------------------------------------------------------
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
----------------------------------------------------------------
> To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
-----------------------------------------------------------------
>
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
-- Attached file included as plaintext by Ecartis --
-- Desc: Signature
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
