catalog.sql error

hello expert,

 catalog.sql is run on live database 7.3.4 database the user compliant of problems

how can i undo the changes and return database to normal
jomfraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
could you be more precise on what error(s) you get?
and also when the error occurs exactly?
0
slightwv (䄆 Netminder) Commented:
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.
0
jomfraAuthor Commented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

slightwv (䄆 Netminder) Commented:
Who are you connected as when you run that statement?
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
dba_role_privs is owned by sys, so you might try:

desc sys.dba_role_privs
0
jomfraAuthor Commented:
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
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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)
0
jomfraAuthor Commented:
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
0
johnsoneSenior Oracle DBACommented:
As SYSTEM run catdbsyn.  That may work.
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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!
0
slightwv (䄆 Netminder) Commented:
You need to run system scripts like catalog.sql as SYS.  It may cause problems if you don't.

Are you a member of the DBA group?

My 7.x is pretty rusty but see if you can connect internal.  'internal' and sys are the same.  Try the following from a command prompt:

svrgmrl

SVRMGRL> connect internal
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.