Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

ERROR ora-01921 when run catalog.sql

Deanna Tran
Frequent Advisor

ERROR ora-01921 when run catalog.sql

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
Honored Contributor

Re: ERROR ora-01921 when run catalog.sql


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.

Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Kawah Cheung

Re: ERROR ora-01921 when run catalog.sql


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.

If in doubt, ask!