Re: Oracle 8i, RH 6.1, "not logged on", and FREE BEER

From: Brice Ruth <Brice.Ruth_at_penguinboots.com>
Date: Fri, 11 Feb 2000 11:55:27 -0600
Message-ID: <38A44D0F.134BDCBF@penguinboots.com>

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

             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

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) Received on Fri Feb 11 2000 - 11:55:27 CST