RE: Rman connection error
Date: Mon, 7 Oct 2013 15:25:54 +0000
Message-ID: <1184E7EFAB1D1C47A5038D06F64BE92611913662_at_XM-MBX-02-PROD.ad.uchicago.edu>
I also forgot to add
From a different server using 11202 I am able to connect to the same catalog fine
> rman catalog mike/mike_at_CATPRD
Recovery Manager: Release 11.2.0.2.0 - Production on Mon Oct 7 10:23:07 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
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 10:06 AM
To: ORACLE-L
Subject: Rman connection error
Hi All,
Sorry, I must be missing something obvious here, but I am just not seeing it. I am able to login to our catalog database with sqlplus, but RMAN connection is throwing invalid username password. I have reset it a couple times, and then even exported/imported the catalog for the test below which throws the same error. Anyone have any insight into this? The catalog is an 11202 database that resides in an 11203 instance
You can see the output below.
> sqlplus mike/mike_at_CATPRD
SQL*Plus: Release 11.2.0.2.0 Production on Mon Oct 7 09:39:39 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select distinct(DB_ID) from rc_backup_set;
DB_ID
2081096298
2034525353
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
> rman catalog mike/mike_at_CATPRD
Recovery Manager: Release 11.2.0.2.0 - Production on Mon Oct 7 09:40:15 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
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
What is interesting is that if I use and 11203 rman client, I am able to get in to the catalog even though it recognizes the different version of the catalog
>rman catalog mike/mike_at_CATPRD
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Oct 7 09:58:13 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
PL/SQL package MIKE.DBMS_RCVCAT version 11.02.00.02 in RCVCAT database is not current PL/SQL package MIKE.DBMS_RCVMAN version 11.02.00.02 in RCVCAT database is not current
Thanks in advance for any help
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 07 2013 - 17:25:54 CEST