| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Interesting Situation
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra
Sent: Thursday, August 05, 2004 11:07 AM
To: oracle-l_at_freelists.org
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
>
> 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
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Aug 05 2004 - 11:30:48 CDT
 |
 |