Oracle Database Discussions

RDBMS Version: 10g
Operating System and Version: Windows Server 2003
Error Number (if applicable): VTO-2014, VBO-1508, ORA-29900, ORA-06540, ORA-06553
Product (i.e. SQL*Loader, Import, etc.): Oracle 10g Enterprise Manager Console
Product Version: 10.1.0.2.0


Hi,

For some reason, after adding some 'roles' and 'privileges' to SYS schema on the Enterprise Manager (java console) on Oracle10g database, the EM raises the below errors whenever we try to create users using "Create Like". Creating users using just "Create" seems fine.

Looks like the SYS schema got corrupted..Not really sure what happened. Unfortunately, this is a production database and hence needs to be fixed pretty quick. I would really appreciate if any of you familiar with this issue can guide me.

If problem cant be fixed without a reinstall, is there a way we can just restore the SYS schema as it was installed?

Any other work-arounds?

Error messages:
VTO-2014:Server object could not be instantiated. Please disconnect and try again.
VBO-1508: An error has occured and the server object could not be initialized. Please disconnect and try again.
ORA-2990: Operator binding does not exist
ORA-06540: PL/SQL: compilation error
ORA-06553: PLS-907: Cannot load library unit SYS.XMLSEQUENCEFROMTYPE (referenced by SYS.XMLSEQUENCE)