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:32:31 +0300
Message-ID: <OF20BD68B1.990B3CD2-ONC2256EE7.005A9B27-C2256EE7.005B9FDB@alise.lv>


It is as it intended to work.
Theoretically you can have 10 different databases + one listener. All databases will provide handlers for one service. I client have been configured to connect to specific service then listener redirect this client to one of the 10 DB-es. .
If you have R/O application, then it can work as shared nothing RAC :) .
.
Jurijs
+371 9268222 (+2 GMT)



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

Sanjay Mishra <smishra_97_at_yahoo.com>
Sent by: oracle-l-bounce_at_freelists.org
05.08.2004 19:06
Please respond to oracle-l  

        To:     oracle-l_at_freelists.org
        cc: 
        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
>



> 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
>


>
   

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_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:37:30 CDT

Original text of this message

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