created tablespace and user rmgr/rmgr in rcat db..granted recovery_catalog_owner role to rmgr..
now in another terminal i connectd to target database TEST through RMAN.. n gave the following command..
[oracle@oracle10g ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Apr 2 16:35:34 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1236579095)
But it is showing as connected to orcl database....
i am sure there is some error over heree...
den gave following command
connect catalog rmgr/rmgr@rcat
i got this error..
RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied..
1) Have you set up your environment variables correctly. You can only connect using "target /" if the ORACLE_SID and ORACLE_HOME are set correctly. If you "echo $ORACLE_SID" I'm guessing it will say "ORCL"...
To fix this, use oraenv and when prompted, type the SID you want to use. It will set the path correctly using the contents of the "/etc/oratab" for the SID you've specified.
Code: Select all
$ . oraenv
2) I'm guessing either your username/password is not rmgr/rmgr, or the alias "rcat" in your $ORACLE_HOME/network/admin/tnsnames.ora does not point to the database you think it does.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests