Re: VCS and Dataguard

Dataguard now offers third party support for replication such as dataguard. I haven't even given VCS control of the database yet. I'm basically just working with a couple hosts fronted by a VIP replicating with dataguard to a standby. What I tried last night was replacing host=hog with host=hog01. Next, I setup dataguard between hog01 and hog03 and last I performed switchover. The switchover almost succeeds but the listener dies on the clustered hosts  

 Here's the listener.log  

 11-JUL-2006 23:58:30 * service_died * db01 * 12537  No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hog01)(PORT=1521)))  Listener completed notification to CRS on stop  

 Why the Cluster Ready Services message in the alert.log?  

 Also, could you send me a basic example of a listener.ora without dataguard? I just want to be sure I'm not missing something.  

 Thx, Dave

• Original Message ---- From: Alex Gorbachev <gorbyx_at_gmail.com> To: dnt9000_at_yahoo.com Cc: oracle-l_at_freelists.org Sent: Wednesday, July 12, 2006 1:10:44 AM Subject: Re: VCS and Dataguard

From what you described it's not very clear where your problem is. Dataguard should not have anything to do with VCS unless I there is something new in 10g. I'm working with 9i standby's with VCS but I believe that the concept is relevant to 10g as well.

What do you mean by "dataguard tries to find the listener on the actual hostname". Usually, you should give a connection descriptor for a listener and this one should point to the listener where your primary database is registered. So it has nothing to do with VCS. Could you provide more details on what errors you get, where and when?

2006/7/12, David Turner <dnt9000_at_yahoo.com>:
> I'm running Oracle 10G with Dataguard and Veritas Cluster Server 4.1 and have run into problems. In the VCS docs I'm told to set the host=<VIP> yet dataguard tries to find the listener on the actual hostname. For example
>
> vip=hog
> host1=hog01
> host2=hog02
>
> host3=hog03(The standby)
>
> hog is a virtual ip that points to hog01. I've set the listener to listen on hog and successfully connect with sqlplus from hog03 to db01.hog but can't get dataguard to find the listener. It keeps looking for the listener on hog01 instead of hog.
>
> Does anyone have a quick howto on VCS and Dataguard? I couldn't find much of anything on metalink and it will be a while before our system guys get through to Veritas.

-- 
Best regards,
Alex Gorbachev

http://blog.oracloid.com



--
http://www.freelists.org/webpage/oracle-l