Re: Dataguard Switchover needs intervention
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: peter.mclarty@xxxxxxxxxxx
- Date: Fri, 15 Apr 2005 17:01:21 +0200
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
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
