ALL IS WORKING :)

It all works now ... thanx to some offline help on the part of Jesus ... thanx a ton!

Brice

btw - the beer offer is still up - if ya want it, send me your addy.

Brice Ruth wrote:

> In an effort to help myself, I thought I'd look for any sqlplus scripts ...
> found sqlplus[123].sh in the rdbms/install/create directory ... so
> I thought "what the hey?" - I'll try 'em. No luck. They ran fine, but SQL+
> still outputs the same errors when I start up.
>
> -Brice
>
> Brice Ruth wrote:
>
> > I'm following the directions on the site listed below and I've gotten
> > through running the crdb1.sh and crdb2.sh scripts, I'm now trying to follow
> > the directions to create more redo log groups as instructed:
> >
> > +++
> > [oracle_at_prs_ntw_096 bin]$ sqlplus system/manager
> >
> > SQL*Plus: Release 8.1.5.0.0 - Production on Mon Jan 10
> > 14:43:34 2000
> >
> > (c) Copyright 1999 Oracle Corporation. All rights reserved.
> >
> > Connected to:
> > Oracle8i Enterprise Edition Release 8.1.5.0.2 - Production
> > With the Partitioning and Java options
> > PL/SQL Release 8.1.5.0.0 - Production
> >
> > SQL> alter database
> > 2 add logfile group 3
> > ('/home/oracle/app/oracle/oradata/8idb/redo03.log') size 4096K
> > 3 /
> >
> > Database altered.
> >
> > SQL> alter database
> > 2 add logfile group 4
> > ('/home/oracle/app/oracle/oradata/8idb/redo04.log') size 4096k
> > 3 /
> >
> > Database altered.
> > +++
> >
> > Problem: I get the following response when I run:
> >
> > +++
> > [oracle8i_at_serv1 install]$ sqlplus system/manager
> >
> > SQL*Plus: Release 8.1.5.0.0 - Production on Fri Feb 11 11:42:52 2000
> >
> > (c) Copyright 1999 Oracle Corporation. All rights reserved.
> >
> > ERROR:
> > ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
> >
> > Error accessing package DBMS_APPLICATION_INFO
> > ERROR:
> > ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
> >
> > Connected to:
> > Oracle8i Enterprise Edition Release 8.1.5.0.2 - Production
> > With the Partitioning and Java options
> > PL/SQL Release 8.1.5.0.0 - Production
> > +++
> >
> > I guess my question is: how do I create DBMS_STANDARD??
> >
> > Any help would be greatly appreciated!! : ) And since beer seems to be the
> > way to get help these days *chuckle* - name your poison & send me your
> > address :))
> >
> > Brice
> >
> > "Jesus M. Salvo Jr." wrote:
> >
> > > Check my sig below. I have encountered that error ... although there are
> > > a few others out there who have encountered the same error under a
> > > different condition that I cannot seem to replicate.
> > >
> > > --
> > > * Installing Oracle8i on RedHat 6.0:
> > > http://homepages.tig.com.au/~jmsalvo/linux/oracle8i.html
> > > * DBDependency project:
> > > http://homepages.tig.com.au/~jmsalvo/dbdependency/index.html
> >
> > --
> > +--+
> > "The use of COBOL cripples the mind; its teaching should,
> > therefore, be regarded as a criminal offense."
> > -- E. W. Dijkstra (1982)
>
> --
> +--+
> "The use of COBOL cripples the mind; its teaching should,
> therefore, be regarded as a criminal offense."
> -- E. W. Dijkstra (1982)

--
+--+
"The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense." -- E. W. Dijkstra (1982) Received on Fri Feb 11 2000 - 12:34:00 CST