RE: Rman connection error
Date: Mon, 7 Oct 2013 17:50:36 +0000
Message-ID: <1184E7EFAB1D1C47A5038D06F64BE92611913895_at_XM-MBX-02-PROD.ad.uchicago.edu>
Hello,
So I had 4 other installs of 11202 that were able to connect to the catalog without issue. I noticed there were a number of patches applies to the 11202 binaries on the system I was seeing the error. I relinked the binaries and now the connection works. I am not sure why I would have been receiving the ORA-01017 error, but looks like it is resolved now
Thanks
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Schmitt
Sent: Monday, October 07, 2013 12:19 PM
To: Jeffrey Beckstrom; ORACLE-L
Subject: RE: Rman connection error
Hello,
When I tried that I get the same error
>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Mon Oct 7 12:17:04 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect catalog mike/mike_at_CATPRD
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied
Thanks
From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
Sent: Monday, October 07, 2013 12:14 PM
To: ORACLE-L; sethmiller.sm_at_gmail.com; Michael Schmitt
Subject: RE: Rman connection error
By chance, if you start rman and from within RMAN issue a connect command does it work. We had that problem after a server failure and our network folks found a configuration error.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
>>> Michael Schmitt
>>> <mschmitt_at_uchicago.edu<mailto:mschmitt_at_uchicago.edu>> 10/7/13 12:47
>>> PM >>>
Hi Seth
The instance hosting the catalog is not a RAC database.
We have a Dataguard database(primary) running on server A. This database is connecting to the catalog running on instance CATPRD (let's say on server B) to run the backups. This is working fine so far without any connection issue. The database being backed up is running version 11202. The CATPRD database on server B is running 11203. The catalog that the primary database is running on was created with 11202
On server C which is where we want to run a restore test, when I attempt to connect to the rman catalog using 11202, that is when I receive the invalid username password error
>rman catalog mike/mike_at_CATPRD
Recovery Manager: Release 11.2.0.2.0 - Production on Mon Oct 7 09:41:55 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
recovery catalog database Password:
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================RMAN-00554: initialization of internal recovery manager package failed RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied
Thanks,
Mike
-----Original Message-----
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seth Miller
Sent: Monday, October 07, 2013 10:37 AM
To: ORACLE-L
Subject: Re: Rman connection error
Is the catalog a RAC database?
-- https://access.seg.att.com/redir/?krFI9LLK6QrFTKqehO9I04X7_fBite00U09rifVmeSfYKurLObbP3ybXbPVKVKItIvVsYKgGT2TwFSf-vaAWs01dLIII6QmnAkn67QjhOrjvdwIqid40blS1EwJm4fJelo6y3UNH4TfM-ub7Xa1J4SCrhKDuVEVppdJeyVnfk6 -- https://access.seg.att.com/redir/?56Wr2rXXxJ6WtXCzAsyr01eN_PVkDjw0e02mQz-lzJz_bDCXYyOYMUy-OY-rKrH7r7-nfbAaJMJUatz_DOFeD00jrXbb1J5BV55NxZ4QsCQTPob6Azh02Rtwq8blx3XjBm1Ew-cqNdPYfDyN-OwrjdFCQrFTKqemmjovNr . -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 07 2013 - 19:50:36 CEST