Re: Oracle 10 on Solaris 10 - ORA-06553 error
From: The Boss <nltaal_at_baasbovenbaas.demon.nl>
Date: Fri, 13 May 2011 16:57:00 -0700 (PDT)
Message-ID: <4b5ae73f-a89c-4164-822c-4da527234c47_at_e21g2000yqe.googlegroups.com>
On 14 mei, 00:13, ddf <orat..._at_msn.com> wrote:
> 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
Date: Fri, 13 May 2011 16:57:00 -0700 (PDT)
Message-ID: <4b5ae73f-a89c-4164-822c-4da527234c47_at_e21g2000yqe.googlegroups.com>
On 14 mei, 00:13, ddf <orat..._at_msn.com> wrote:
> 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
Strictly speaking, only 'catalog.sql' and 'catproc.sql' are mandatory
(note also the .sql prefix), the others are optional (and there are
more of them).
- catexp7.sql you will only need if you want to use the Oracle7 Export
format.
- caths.sql is used for Heterogeneous Services - catrep.sql can be used if you want Replication - catrepr.sql if after running catrep.sql you decide you don't needReplication anyway ...
For the OP: please have a look at this documentation: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/scripts.htm
More specifically, the first bullet points to the mandatory scripts, the second to the optionals and the third to the scripts for removing previous installed features.
HTH
-- JeroenReceived on Fri May 13 2011 - 18:57:00 CDT