Re: Help needed with database creation

Hi Paul,

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
Paul Davies wrote in message <370a25b8.0_at_newsread3.dircon.co.uk>...
>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
>
>
>
Received on Tue Apr 06 1999 - 12:48:03 CDT