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

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) Received on Fri Feb 11 2000 - 12:06:05 CST