Newbie Questions..

From: Craig Nelson <cnelson_at_127.0.0.1>
Date: 1998/02/18
Message-ID: <6cf0qa$n6d@clarknet.clark.net>#1/1

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