Cannot Use SQLPlus as a Non-Oracle User on AIX 64 Bit ORA-01034 and ORA-27121 (Doc ID 1058928.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.1.0.7 [Release 10.2 to 11.1]
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 16-Jul-2012***

Symptoms

On AIX 64-bit, using Oracle 10.2 or 11.1, unable to use SQLPLUS as any user other than the UNIX user Oracle. The following occurs:

ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
IBM AIX RISC System/6000 Error: 13: Permission denied

Symptoms associated with this issue are:

- no errors in alert.log
- cannot connect to sqlplus other than as UNIX user oracle
- platform is 212 AIX 64 Bit
- errors that occur in a core dump are
   ORA-1034: ORACLE not available
   ORA-27121: unable to determine size of shared memory segment


Changes

Running Oracle version 10.2.0.3, 10.2.0.4, 11.1.0.6 or 11.1.0.7

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms