Why getting some error after install Oracle database?(i17)

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@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?


Ans1:

there are several standard scripts that need to be run manually using
svrmgrl and connected as internal
They are
$ORACLE_HOME/rdbms/admin/catalog.sql
$ORACLE_HOME/rdbms/admin/catproc.sql
$ORACLE_HOME/rdbms/admin/catexp.sql

They can be run by @<filename>

The second script will resolve the first problem, the first script the
second problem. The third script is required for the exp utility.
Please don't forget to issue a spool command before you start using them,
otherwise any error message will be lost (not that anything should go wrong)

Hth,

Sybrand Bakker, Oracle DBA


Ans2:

also RUN  %ORACLE_HOME/dbs/pupbld.sql to build user profile;

Hosted by www.Geocities.ws

1