Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Interesting Situation

Re: Interesting Situation

From: <J.Velikanovs_at_alise.lv>
Date: Thu, 5 Aug 2004 19:28:35 +0300
Message-ID: <OF6F6FDA15.404ABB48-ONC2256EE7.0059C744-C2256EE7.005B4394@alise.lv>


I am pretty sure ghosts and demons (joke ;) Be more serious try within DB D2 run:
select machine from v$session;
It can give you a hint.
.
You can try to check dinamic Listener registration (services staff in Oracle Net)
.
Jurijs
+371 9268222 (+2 GMT)



Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

On 05.08.2004 18:16:40 oracle-l-bounce 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_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
>-----------------------------------------------------------------



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:33:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US