Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: VCS and Dataguard

Re: VCS and Dataguard

From: David Turner <>
Date: Thu, 13 Jul 2006 10:17:24 -0700 (PDT)
Message-ID: <>

I filed a tar with Oracle and believe I have a fix for the problem. However, I don't fully understand the problem nor the solution yet. Just that CRS appeared to be getting in the way. I'll send another email when I do. Oracle suggested I run  

 $ORACLE_HOME/bin/localconfig delete  

 Here's what Oracle wrote:  

 The minimal version of the CSS (ocssd local version) is installed when the software is installed a  nd is started up using the init
 scripts so first there is no extra maintainence or monitoring the customer needs to do for this process anyways. This is requi  red for access to the OCR when having an ASM configuration or when having a CRS   configuration where this does not remain a "local" configuration as the daemon  runs out of the CRS home.  

 You can use the command "$ORACLE_HOME/bin/localconfig delete" which would clear the  local configuration.    

 If anyone understands this better feel free to comment. Dataguard is performing switchover nicely. Today I'll attempt to setup the Global Clustering Option which allows failover locally and globally.  


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

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


Received on Thu Jul 13 2006 - 12:17:24 CDT

Original text of this message