ERROR ora-01921 when run catalog.sql

[Deanna Tran]

I looked up this error, and it said :
ORA-01921 role name 'string' conflicts with another user or role name

Cause: There is already a user or role with that name.

Action: Specify a different role name.

Can you help me which user or role name is that refering to ? and how can i fix it the problem?

[Graham Cameron_1]

Deanna

What is the 'role_name' in the error message.

Catalog.sql is the first script run when a database is created and should only be run once. Maybe you are running it a 2nd or 3rd time and it is trying to create things which are already there.
The only "create role" in my catalog.sql (8i) is
"create role recovery_catalog_owner",
although it does call other scripts and I haven't scanned them all.

If this is what you see then you can ignore it but I repeat, catalog.sql only needs to run once, at database creation.

Graham

[Kawah Cheung]

Hi,

Error ORA-1921 is caused by the scripts called by catalog.sql finding the objects in the database. This error occurs if this is not the first time that you have run the catalog.sql script. Objects that are not effected by re-running catalog do not have a DROP statement.

This is a normal condition and is of no concern.

Also make sure you have _system_trig_enabled=false set in the pfile if you are upgrading, downgrading, installing, deinstall. See Oracle Note:149948.1.

Rgds,
Kawah