Re: Newbie - help creating a new database on Oracle 8

In article <370a104c.0_at_newsread3.dircon.co.uk>,   "Paul Davies" <cobalt_at_dircon.co.uk> wrote:
> Hi
>
> I'm new to Oracle and am trying to create a new database on Oracle 8 on
> Linux.
>
> The database creation process appears to go according to plan.
>
> But when I log on to sqlplus (i've changed ORACLE_SID to reflect the new
> database) the following happens
>
> [oracle_at_localhost dbs]$ sqlplus SYS/CHANGE_ON_INSTALL
>
> SQL*Plus: Release 8.0.5.0.0 - Production on Tue Apr 6 14:47:23 1999
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-06553: PLS-213: package STANDARD not accessible
>
> Error accessing package DBMS_APPLICATION_INFO
> ERROR:
> ORA-06553: PLS-213: package STANDARD not accessible
>
> Connected to:
> Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
>
> SQL>
>
> *******
>
> Also trying to select * from dictionary brings up a message saying "table or
> view does not exist".
>
> Can someone please tell me why I am getting these error messages and why the
> dict tables have not been created?
>
> Thanks
>
> Paul
>

You need to run script $ORACLE_HOME/rdbms/admin/catproc as sys to build the pl/sql packages. Catalog builds the only the data dictionary views and synonyms.

Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 08 1999 - 12:45:46 CDT