Error while trying to create Recovery Catalog

From: Bruce <brucemcgill.nyc_at_gmail.com>
Date: 16 Mar 2006 05:00:44 -0800
Message-ID: <1142514044.378774.271730@i39g2000cwa.googlegroups.com>

Hi,

I get an Error when I try to create Recovery Catalog in Oracle 9i on Red Hat Linux 7.2:

Here are the steps I followed to create recovery catalog:

SQL> create tablespace rman_ts datafile

     '$HOME/ORADATA/u01/rman_01_db01.dbf'
     size 20M default storage
     (initial 100K next 100K pctincrease 0)

SQL> create user rman_db01 identified by rman_db01
     default tablespace rman_ts
     quota unlimited on rman_ts;

SQL> grant recovery_catalog_owner to rman_db01; SQL> grant connect, resource to rman_db01;

$ rman catalog rman_db01/rman_db01_at_db01
This is when I get the following error:

Recovery Manager: Release 9.2.0.4.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. 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-12154: TNS:could not resolve service name

I have started the listener and the database is open.

Regards,
Bruce Received on Thu Mar 16 2006 - 07:00:44 CST