Re: RMAN register database problem ...

Anil Sikri,

I have implemented your second method using password file and the command (d) which was not working earliar is working now. Both method are working now. Thanks for helping me out.

• Janardhana Babu At 03:45 PM 4/28/00 -0800, Anil Sikri wrote:

>*********************** Original Message ****************************
>
>Dear list members,
>>> >
>>> > I have created a catalog database name : rcat, Connect string:
>>>fis_test_rcat.
>>> > The test database Name : rtest, Connect String: fis_test_rtest.
>>> > Both are Oracle 8.1.5 databases(64 bit) residing on the same box(HP-UX
>>>11.0).
>>> >
>>> > I have created user rman/rman in "rcat" database with default tablespace
>>> > rcvcat_ts and granted recovery_catalog_owner to rman, also granted
>>>connect,
>>> > resource to rman.
>>> >
>>> > I have created recovery catalog as follows:
>>> > $ rman (rman log=create_rman.log is not working, it simply hangs)
>>> > RMAN> connect catalog rman/rman_at_fis_test_rcat
>>> > RMAN> create catalog tablespace rcvcat_ts;
>>> >
>>> > Now, I need to register "rtest" database in "rcat".
>>> > When I issue the command suggested in the manual:
>>> > $ rman target / catalog rman/rman_at_fis_test_rcat , I get the following
>>>messages.
>>> > RMAN-06005 Connected to target database: RCAT(DBID: 166860994)
>>> > RMAN-06008 Connected to recovery catalog database.
>>> > RMAN>
>>> >
>>> > My target database is RTEST and not RCAT. The above stmt at RMAN-06005
>>>says
>>> > my target database is RCAT. I tried many ways to connect both target
>>> > database and catalog database inorder to register the target database
>>> > "RTEST" in catalog database "RCAT". But none of the stmts are connecting
>>>to
>>> > the target database.
>>> >
>>> > How can I register the target database "RTEST" in catalog database
>>> "RCAT"?
>>> > Any help is appreciated.
>>> >
>>> > Thanks,
>>> > -- Janardhana Babu
>******************************************************************
>
>********************* Solution *********************************
>
>Janardhan,
> I assume you are using O/S authentication since the RMAN
> recovery catalog and the target database are on the same
> machine.
> I think I know why you are not able to connect to the
> target database :
>
> 1) Make sure that before invoking RMAN, the ORACLE_SID has
> been set to the target database ( ORACLE_SID = rtest ).
> I have a feeling that your current ORACLE_SID is set to
> rcat instead of rtest which is why RMAN is assuming your
> target database is rcat.
> Now try rman target / catalog rman/rman_at_fis_test_rcat
> and it should work.
>
> 2) If the above approach doesn't help, try using password file
> instead. The password file method can be used in your case
> as well as when the recovery catalog is on a remote
> machine. Follow these steps to disable O/S authentication
> and enable password file :
> a) export ORACLE_SID=rtest ( target database )
> b) Disable the O/S authentication by setting
> REMOTE_OS_AUTHENTICATION = FALSE in the parameter
> file of the target database ( rtest )
> c) Now, create a password file using :
> orapwd file=$ORACLE_HOME/dbs/orapw
> password=<PASSWORD> entries = 3
> Note : You should name the password file orapw
> without which you will have problems ( at
> least I did ).
> d) Connect to the target database using :
> rman catalog rman/rman_at_fis_test_rcat
> target sys/<sys_passwd_of_target_db>@fis_test_rtest
>
>
>After connecting, you should be able to register the target database.
>Let me know if you have any problems.
>
>Anil Sikri
>Sr. Oracle DBA
>
>
>
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Anil Sikri
> INET: anil_sikri_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
Received on Mon May 01 2000 - 14:16:27 CDT