Re: 7.3.2 installation on Solaris 2.5 problem

Thanks, Chris;
i tried dbmsutil.sql - it failed; i got another advice from usenet to run catproc.sql - it did not help either; basically, all sql statemente creating packages fail - looks like something very basic is missing.

Thanks again

Vlad

Chris Jones wrote:
>
> Vladimir Stavitsky <vlads_at_lvalue.com> writes:
>
> > today i went through my second installation of Oracle 7.3.2
> > on Solaris 2.5.
 

> > The only problem is an error message i get when i start
> > sqlplus. This error does not prevent sqlplus from doing all the
> > regular stuff correctly, but i am still worried if this thing is
> > going to backfire later on. Here's this error message:
> >
> > Error accessing package DBMS_APPLICATION_INFO
> > ERROR:
> > ORA-00900: invalid SQL statement
> >
> > 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
>
> You are correct saying that SQL*Plus will do it's normal stuff despite
> this error. However, since this is a 7.3 db you should have the
> DBMS_APPLICATION_INFO package, and it should work. Try calling the
> package "manually" in a PL/SQL block (see the Tuning Guide for info on
> this package):
>
> begin
> dbms_application_info.set_module('Manual test', NULL);
> end;
>
> I expect this will fail with the same ORA-900. Try running
> dbmsutil.sql within svrmgrl to fix the immediate problem. However, it
> sounds like the install is not complete and Support may advise you to
> run some more or all of the data dictionary scripts again.
>
> Chris
 

-- 
---------------------------------------------------------------------
        ... occurrences like this will be few and far between ...

vlads_at_webvalue.com           Vlad Stavitsky          vlads_at_lvalue.com
---------------------------------------------------------------------