Re: Dataguard Switchover needs intervention

Peter,
I've no real world experience with the Broker/CLI, I use SQL*Plus and my
own scripts, so I can only guess here.

Did you set the SERVICE_NAMES parameter? The instance might have
de-registered itself from the listener on shutdown. I'd search for the
differences in your listener setup on both ends.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===


On Fri, 2005-04-15 at 01:56, Peter McLarty wrote:

> Hi
> I am configuring Dataguard for a customer and have an issue with the 
> switchover not being smooth
> 
> The configuration is as follows
> 
> Unix AIX 5.2
> Oracle 9.2.0.5
> 
> I have a primary and a single standby instance ellprd and elldrc located 
> on separate servers
> 
> CREATE CONFIGURATION 'egat' AS
> PRIMARY SITE IS 'mmmprd'
> RESOURCE IS 'mmmprd_db'
> HOSTNAME IS 'mmmprddbs'
> INSTANCE NAME IS 'ellprd'
> SERVICE NAME IS 'ellprd'
> SITE IS MAINTAINED AS PHYSICAL;
> 
> 
> 
> CREATE SITE 'mmmdrc'
> RESOURCE IS 'mmmdrc_db'
> HOSTNAME IS 'mmmdrcdbs'
> INSTANCE NAME IS 'elldrc'
> SERVICE NAME IS 'elldrc'
> SITE IS MAINTAINED AS PHYSICAL;
> 
> When i did the switchover from mmmprd to mmmdrc it seemed to work 
> correctly but when I then tried to swich then back I get the following 
> in dgmgrl
> 
> DGMGRL> switchover to mmmprd;
> Performing switchover NOW. Please wait...
> Operation requires restart of site "mmmdrc"
> Operation requires restart of site "mmmprd"
> Shutting down site mmmdrc...
> Unable to connect to database
> ORA-12523: TNS:listener could not find instance appropriate for the 
> client connection
> 
> Failed.
> You are no longer connected to ORACLE
> Please connect again.
> Unable to shut down mmmdrc
> You must restart site "mmmdrc" manually.
> You must restart site "mmmprd" manually.
> Switchover succeeded. New primary is "mmmprd"
> 
> 
> I then had to restart both intances to get DGbroker to report the 
> configuration was running ok.
> 
> Any ideas as to what might cause this
> 
> Cheers
> 
> Peter
> 
> --
> http://www.freelists.org/webpage/oracle-l




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

Other related posts: