catalog.sql error

could you be more precise on what error(s) you get?
and also when the error occurs exactly?

While waiting for the answers to the questions above, I believe the short answer is:  no, you cannot rollback the run of catalog.sql.

If there ware errors causes because of it, my guess is the version of catalog.sql that ran wasn't for the version of the instance it was applied.

Also make sure there were no errors when it ran.  prior to running it you should spool the output. You can then check the output for errors.

Spool the output and run it again.

hello expert,

i seem as if i cannot get access to any of system tables

example

log on as system

desc dba_role_privs

ERROR at line 1:
ORA-00942: table or view does not exist

Who are you connected as when you run that statement?

dba_role_privs is owned by sys, so you might try:

desc sys.dba_role_privs

hello expert,

it seem like all the role has to predefined with sys

example

SQL> desc user_users
Object does not exist.
SQL> desc sys.user_users
 Name                            Null?    Type
 ------------------------------- -------- ----
 USERNAME                        NOT NULL VARCHAR2(30)
 USER_ID                         NOT NULL NUMBER
 DEFAULT_TABLESPACE              NOT NULL VARCHAR2(30)
 TEMPORARY_TABLESPACE            NOT NULL VARCHAR2(30)
 CREATED                         NOT NULL DATE
 
SQL>

all the roles has to be predefined with sys before i can query them are all the public synonyms

deleted

how can be able to query on these table with using sys

thanks

well, all those tables should have public synonyms, so there must have been something wrong with the execution of catalog.sql. rerun it (being logged in as sys)

hello expert,

i do not know the sys password but i know the system password

how can i run same with the system password

thanks

As SYSTEM run catdbsyn.  That may work.

>i do not know the sys password but i know the system password
then you have to ask the person that DOES know the sys password!