RE: Streams archived_log downstream capture - ORA-16191
- From: "John Hallas" <john.hallas@xxxxxxxxxx>
- To: "April Sims" <sims@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Apr 2008 16:00:48 +0100
Thanks April but no success so far
I have followed all those steps but the only difference is that I see an
1031 rather than a 16191 error now
ORA-01031: insufficient privileges
PING[ARC0]: Heartbeat failed to connect to standby 'PERF03'. Error is
1031.
I have changed the password at both ends and recreated the password file
and I can connect back and forth using sqplus as sysdba
I can see a forum message problem that was identical but that was
resolved by doing an oradim (Windows) whereas I am on Linux.
-----Original Message-----
From: April Sims [mailto:sims@xxxxxxx]
Sent: 07 April 2008 14:19
To: John Hallas; oracle-l@xxxxxxxxxxxxx
Subject: Re: Streams archived_log downstream capture - ORA-16191
John,
I have encountered this in a DATA GUARD environment as well, see fix
below. This also fixed problems with Grid Control in 11g.
Data Collected
==============
ORA-16191: Primary log shipping client not logged on standby
Support Update
==============
The issue seems to be because of password mismatch between primary and
standby.
The password file has to have identical authentication info for both
primary and standby
If you change or create the password file using orapwd for SYS,it will
not work in 11G.
Action Plan
===========
Turn off the case sensitivity option by changing init.ora parameter
SEC_CASE_SENSITIVE_LOGON=FALSE.
Create password files on both servers using the same password and pass
ignorecase=Y to orapwd utility.
Make sure you use identical options during password file creation for
both primary and standby
>>> "John Hallas" <john.hallas@xxxxxxxxxx> 4/7/2008 6:28 AM >>>
I am trying to set up a Streams archived_log downstream capture between
two 11.1.0.6 databases and I am having problems in getting the archive
log files to transport over to the target database where they will be
read and applied.
The information included in this email and any files transmitted with it may
contain information that is confidential and it must not be used by, or its
contents or attachments copied or disclosed, to persons other than the intended
addressee. If you have received this email in error, please notify BJSS.
In the absence of written agreement to the contrary BJSS’ relevant standard
terms of contract for any work to be undertaken will apply.
Please carry out virus or such other checks as you consider appropriate in
respect of this email. BJSS do not accept responsibility for any adverse effect
upon your system or data in relation to this email or any files transmitted
with it.
BJSS Limited, a company registered in England and Wales (Company Number
2777575), VAT Registration Number 613295452, Registered Office Address, First
Floor, Coronet House, Queen Street, Leeds, LS1 2TW
--
//www.freelists.org/webpage/oracle-l
Other related posts:
