Re: server manager / catsvrmg.sql / dba role problems

Hello James,

On Mon, 27 Jan 1997 16:23:36 +0100, James Dickson <James.Dickson_at_mail.esrin.esa.it> wrote:

-->In Server Manager (motif), when clicking on objects for
-->more information, I get the error:
-->
--> MGR-02157 action UserGetSysPrivs failed.
--> Maybe catsvrmg.sql not run or not a DBA
-->
--> ORA-00942 table or view does not exist
-->
-->The Oracle Server Manager User's Guide release 2.0 advises
-->me on page B-20 to run catsvrmg.sql as SYS then connect as
-->a user with default role DBA. I have done this but the error
-->persists. The only way to see the objects is to connect to
-->svrmgr as SYS, but I would like to connect via another userid
-->with the DBA role.
-->
-->Any ideas?
-->
-->And what table or view does not exist?
-->
-->Thanks,
--> James
-->
-->--
-->james_at_valhall.esrin.esa.it

I think you need to RUN CATDBSYN.SQL under your account (if you are a DBA ofcourse)

I had the same problem and Oracle advised me to run this scripts.

Good luck.

Greatings,

Erik Oosterling

101756,3156 <-> Compuserve
101756.3156_at_compuserve.com <-> Internet
ErikO_at_cmg.nl <-> Internet Received on Wed Jan 29 1997 - 00:00:00 CST