Re: DBMS_APPLICATION_INFO Error ..

From: Alfons Riesebeek <A.Riesebeek_at_wxs.nl>
Date: 30 Jul 1998 06:55:40 GMT
Message-ID: <6pp5dc$n8a$1@hdxf08.telecom.ptt.nl>

I think you should run catproc again under the "sys" account. But maybe first you can clean up ( DBMS*) objects under the system account because i don't think there should be anything else at database creation time.
But maybe someone else in this news group can confirm this.

Regards,
Alfons

hojoonpark <hojoonpark_at_postman.lg.co.kr> schrijfbewerkingen: > Hello Everyone !!
>
> Currently, we are running Oracle 7.3.3.0.0 on a NCR with UNIX SVR4.0.
>
> I run the catproc.sql with 'system' user privileges.
> (But this script must be run by 'sys' or INTERNAL)
>
> But I got this error message lists.
>
> Error accessing package DBMS_APPLICATION_INFO
> ERROR:
> ORA-06509: PL/SQL: ICD vector missing for this package
> ORA-06512: at "SYSTEM.DBMS_APPLICATION_INFO", line 22
> ORA-06512: at line 1
>
> Error accessing package DBMS_APPLICATION_INFO
> You may need to install the Oracle Procedural option
> SET APPINFO requires Oracle Server Release 7.2 or later
>
> I know that catproc.sql must be run by 'sys' or Internal user
> but i didn't.
>
> What should I do ?
> And When I run the Catproc.sql ? and Why ?
>
> Please Help me.
>
>
Received on Thu Jul 30 1998 - 01:55:40 CDT