RMAN register database problem

I,
I have create one new instance of 8i database that content recovery catalog for RMAN.
I have create a user rman, he have the connect, ressource, recovery_catalo_owner grants.
When I connect to the tool RMAN there's no problem.
But when i try to register a target database, there's problem.

RMAN> connect target XXX/XXX@XXX

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04005: error from target database: ORA-01031: insufficient privileges



I've create the database from system user, and create the user from system too.


did someone can help me.

Try the following at c:\> prompt. . .

RMAN target XXX/XXX@XXX catalog rman_db1/rman_db1@catdb

BTW, were u able to create the catalog using CREATE CATALOG command?

With regards.

http://www.plauder-smilies.de/person/hat.gif

thank,
I have already create the catalog with create catalog command.

when I try your purpose I got alvways the same problem.
did you have an idea.



oracle>rman target xxx/xxx@xxx catalog xxxx/xxxx@xxxx

Recovery Manager: Release 8.1.5.0.0 - Production

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: ORA-01031: insufficient privileges
oracle>

In think you have to connect to the target database as a user who has SYSDBA privileges.

Do you have your server & RMAN running on the same server?

Nizar

I,
i'm connecting to the target with the system account and my server and RMAN are one the same machine.
What can you expcet more, I don't realy understand why did I have insuffisant privilege.
thanks

Are u able to connect to the target db as sysdba apart from RMAN, using SQLPLUS?

yes I abble to do that thing.
so I don't realy know why I can't connect from within rman catalog to target database.

If this is the case, yet another option is there;

* Check the log when the catalog was created i.e., catalog.log for errors and

*drop all objects and start from the beginning i.e.,

1. Connect to catalog db(catdb) & create tbs(rman_tbs) for catalog

2. Create RMAN user(rman_db1) with default tbs as of 1(rman_tbs)

3. Grant connect, resource, recovery_catalog_owner to RMAN user.(rman_db1)

4. Ensure space of 5M in rollback segment and 20M in catalog tbs (rman_tbs).

5. At c:\> prompt type

RMAN catalog rman_db1/rman_db1@catdb msglog=catalog.log
create catalog tablespacerman_tbs;
exit;

6. Check catalog.log for errors.

7. At C:\> type, RMAN target xxx/xxx@xxx catalog rman_db1/rman_db1@catdb

8. register database;


Hope this helps. http://www.dbasupport.com/forums/

I have resolve my problem, I wasn't in the good env.
know i'm in my target env and I connect to the cat in the other env.
Then i just have the right to connect my target because I'm in the env of this one.
thank again for all your hlep that have make me think to this solution.

Set the remote_login_pssswordfile=exculise and use the
orapwd utility to create the password for internal .
connect to the rman and then connect to target or recovery.
otherwise users can see your passwords when u are connected ..