Team coding: ORA-00604 and ORA-00001

Toad for Oracle & DevOps Toolkit
1

Hi,

Trying to install Team Coding to the database and have run into the below errors when I view output having run the installation script -

ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_DEFROLE1) violated

I have attached a screen shot of this.

Thanks,

Gavin

output_error_TC
output_error_TC539×645 97.4 KB

2

Hi Gavin,

Based on your screenshot, it looks like you're trying to install Team Coding using the SYS user and there are already a lot of default roles defined. It's possible there is a duplicate role in the list of default roles in that ALTER statement. There's an Oracle support document that talks about this kind of error:

https://support.oracle.com/knowledge/Oracle%20Database%20Products/2615078_1.html

I would take a look at the roles listed in that ALTER statement to see if there are any duplicate roles defined in the list. You can see this by selecting "Create Install Script for Database" in the Team Coding Configuration window. Alternatively, another way around this would be to install Team Coding to the TOAD schema using a different user who has DBA privileges or privileges to create objects in other schemas.

I hope this information helps in identifying the cause of the issue in your environment. Please feel free to let us know if you run into any other issues.

-John

3

Hey John,

Thank you for your reply and thorough explanation.

I used an alternative user with DBA privileges and TC was installed successfully!

Best wishes,

Gavin