Re: Primary cannot log into standby ora-16191

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Thu, 14 Feb 2013 21:48:43 -0500
Message-ID: <CAABGLuJd-2g4=iYBLbjDn5wXwj2VUfxssEuocYeSRZB2J8tG6A_at_mail.gmail.com>

Howard,
First how the connectivity to the Primary database using TNS service? [From Primary or Standby: $sqlplus sys/****_at_prim as sysdba], Are you able to connect? Then there is no problem with the password file from the primary database.

And perform the same step to test the connectivity from Primary to Standby using TNS service as [From Primary: $sqlplus sys/*****_at_standby as sysdba],

Already other folks given useful information on Password case sensitivity/Re-create password file, Along with this i recommend you to check MOS note *Troubleshooting ORA-16191 and ORA-1017 in Data Guard Log Transport Services [ID 1368170.1]*

Thanks & Regards,
Nassyam Basha.

On Thu, Feb 14, 2013 at 7:53 PM, De DBA <dedba_at_tpg.com.au> wrote:

> In my experience they need to be _identical_ on the primary and the
> standby site. I've had instances where recreating password files on the
> primary and the standby with the _same_password_ did not allow the standby
> and the primary to communicate. Subsequent copying of the password file
> from the primary to the standby repaired that instantly!
>
> My 2c.
>
> Cheers,
> Tony
>
> On 15/02/13 00:00, Fuad Arshad wrote:
> >
> > if you have not changed your sys password you can move your orapw file
> from the
> > 10 home to the 11 homes. i've seen in some cases that is the case.
> > if you dont have an orapw$SID files you will need that on both primary
> and
> > standby
> >
> >
> > ----- Original Message ----
> > From: Howard Latham<howard.latham_at_gmail.com>
> > To: ORACLE-L<oracle-l_at_freelists.org>
> > Sent: Thu, February 14, 2013 4:34:51 AM
> > Subject: Primary cannot log into standby ora-16191
> >
> > Plat REDHAT LInux DB 11.2
> > My Primary - just upgraded for 10 to 11 cannot connect to the standby on
> > another box.
> >
> > There's something you have to do with the Orapwd file. It is documented
> but
> > sometimes not correctly.
> >
> > My Primary - just upgraded for 10 to 11 cannot connect to the standby on
> > another box.
> >
> > Is it that the $ORACLE_HOME string should be used or not used? when doing
> > an ORAPWD? Anyone remember off-hand.?
> >
> >
> > I can usually remember this but I have brain ache this morning - not sure
> > why!
> >
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Thanks & Regards,
Nassyam Basha.


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

Received on Fri Feb 15 2013 - 03:48:43 CET