Insufficient Privileges / Oracle Not Available

From: Adley <adley194_at_gmail.com>
Date: 18 Jul 2006 00:25:23 -0700
Message-ID: <1153207523.909456.190140@s13g2000cwa.googlegroups.com>

Peace all,

I encountered something strange today.

Yesterday, due to some maintenance work, everything in the office must be shutdown. Including the Oracle servers. Today, though, when I tried to restart the instances, not one of them would start.

My Oracle is version 8.1.7 on AIX 4.3... it's a development machine.. one of the instances to be started is ELLTRN...

Scenario 1:

---

ORACLESID=elltrn> sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 18 14:35:46 2006

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name: / as sysdba
ERROR:
ORA-01031: insufficient privileges

Scenario 2:

---

ORACLESID=elltrn> sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 18 14:36:19 2006

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory

Scenario 3:

---

ORACLESID=elltrn> sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 18 14:37:29 2006

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges

I'm using the user 'oracle' to do all the above. The primary group is already 'dba' as can be seen below.

ORACLESID=elltrn> id
uid=203(oracle) gid=203(dba) groups=202(oinstall),204(mincomrt)

Do I need to somehow modify the init.ora file? Even though just yesterday everything was fine? Or is there something else I need to do?

Thanks a lot,
=adley= Received on Tue Jul 18 2006 - 02:25:23 CDT