Re: Newbie Questions..

You need to run catalog and catproc scripts. You should run them with server manager while connected internal (SYS). They are found in $ORACLE_HOME/rdbms/admin

Craig Nelson wrote:
>
> I just created a database instance under Oracle v7.3 (DGUX). There are
> other database instances that run fine (without these problems). Here's
> what is driving me NUTS!
>
> When I login via sqlplus, I get the following error:
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-06553: PLS-213: package STANDARD not accessible
>
> ---- ... why the hell not? The other instances can access this package!
> Do I have to somehow let Oracle know where it is?
>
> Next, I simply want to "select * from system.tab".
>
> SQL> select * from system.tab;
> select * from system.tab
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> --- . I thought system.tab always existed! I am logged on as
> system/manager.
>
> Anyone have any idea what is going on? I *am* going to the Oracle DBA
> classes (once I get through with MSCE). Once I get through these initial
> hurdles, I'll be much better off (I've done a great deal of SQL/PLSQL,
> just never set up a database from scratch).
>
> Thanks for any help!!
> Craig Nelson
> cnelson_at_clark.net
Received on Wed Feb 18 1998 - 00:00:00 CST