Hi,
I am running Oracle 9.2.0 on SuSE Linux 8.0.
I am currently an OCA working toward OCP.
I cannot get RMAN working correctly in CATALOG mode. I have no problems in
NOCATALOG mode.
Here is actual text from me trying to use RMAN in CATALOG mode:
Daddy@00:33:50:~ $ rman target sys@ort3
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
target database Password:
connected to target database: ORT3 (DBID=2322176214)
RMAN> connect catalog rman@orrm
recovery catalog database Password:
connected to recovery catalog database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-02112: PCC:
SELECT..INTO returns too many rows
I can connect to rman@orrm and perform a SELECT table_name from USER_TABLES
in which I get 30 rows.
I am able to connect to sys@ort3. I can not seem to fully connect to the
recovery catalog via rman.
Anyone experience this problem before?
Sam
Oracle Certified Associate
Received on Wed Jan 08 2003 - 00:56:53 CST