RE: Streams archived_log downstream capture - ORA-16191
Date: Mon, 7 Apr 2008 16:00:48 +0100
Message-ID: <E02CB9B2777CF8459C86C49B48C48EC603A5C06F@exchange.bjss.co.uk>
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_at_suu.edu]
Sent: 07 April 2008 14:19
To: John Hallas; oracle-l_at_freelists.org
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_at_bjss.co.uk> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 07 2008 - 10:00:48 CDT