Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Insufficient Privileges / Oracle Not Available
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:
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:
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:
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
![]() |
![]() |