[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 596
  • Last Modified:

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
0
jomfra
Asked:
jomfra
  • 4
  • 3
  • 3
  • +1
1 Solution
 
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now