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@xxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 05.08.2004 19:06 Please respond to oracle-l To: oracle-l@xxxxxxxxxxxxx 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 --- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------