Re: sqlplus problem.

The problem is that there are probably 2 packages with this name, one for SYSTEM and one for SYS. When you log on as SYSTEM you'll find you're (SYSTEM's) package DBMS_APPLICATION_INFO. DO a select on the Datadictionary to see if there are two DBMS_APPLICATION_INFO. (one of SYS and one of SYSTEM and delete the package of SYSTEM.

On Sat, 12 Dec 1998 20:37:25 -0500, Ron Denham <MyEmail=ronnied_at_mindspring.com> wrote:

>If you don't run catalog.sql at a minimum (notice there are others like
>catproc.sql if you want to use stored procs, catrep for replication, etc.)
>you will not get the internal system structures you need. You always have
>to run catalog.sql. I always run catproc too at a minimum. The other
>catxxx.sql scripts are run as needed depending on the features I'm using.
>
>- Ron
>
>Manu Kambhampati wrote:
>
>> I am getting the following when I startup sqlplus as system/manager; I
>> just installed oracle server 7.3.2.1 on solaris. What is the following
>> message telling me?! Help!
>>
>> SQL*Plus: Release 3.3.2.0.0 - Production on Fri Dec 11 20:47:21 1998
>>
>> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>>
>> ERROR:
>> ORA-06553: PLS-213: package STANDARD not accessible
>>
>> Error accessing package DBMS_APPLICATION_INFO
>> ERROR:
>> ORA-06553: PLS-213: package STANDARD not accessible
>>
>> 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
>>
>> Connected to:
>> Oracle7 Server Release 7.3.2.3.0 - Production Release
>> PL/SQL Release 2.3.2.3.0 - Production
>>
>> ---
>>
>> thanks
>
Received on Tue Dec 15 1998 - 11:14:11 CST