Re: Oracle 10 on Solaris 10 - ORA-06553 error

From: ddf <oratune_at_msn.com>
Date: Fri, 13 May 2011 15:13:19 -0700 (PDT)
Message-ID: <2b53cf95-5f63-4e2c-ba31-4d83f0b91fca_at_n11g2000yqf.googlegroups.com>

On May 13, 12:27 pm, neilsolent <n..._at_solenttechnology.co.uk> wrote:
> I have installed Oracle 10 on Solaris 10 (x86).
> I try to access it - "sqlplus system/manager" and get the following
> error:
>
> ERROR:
> ORA-06553: PLS-213: package STANDARD not accessible
>
> ERROR:
> ORA-06553: PLS-213: package STANDARD not accessible
>
> Error accessing package DBMS_APPLICATION_INFO
>
> Any ideas?
>
> I'm just trying to play with Oracle, and I haven't got to 1st base
> yet. I hope to one day create a table and maybe even insert some
> data :-)

Errors like these are usually due to the catalog not being built; you need to run a few scripts in $ORACLE_HOME/rdbms/admin post database creation:

_at_?\rdbms\admin\catalog
_at_?\rdbms\admin\catexp7
_at_?\rdbms\admin\catproc
_at_?\rdbms\admin\caths
_at_?\rdbms\admin\catrep
_at_?\rdbms\admin\catrepr

rem accept password 'Enter SYSTEM user password: ' connect system/&password
_at_?\sqlplus\admin\pupbld

The ? is shorthand for $ORACLE_HOME in sqlplus. Connect as sys as sysdba then run the above six scripts; connect as system then run the last script. Your errors should go away.

David Fitzjarrell Received on Fri May 13 2011 - 17:13:19 CDT