ORA-27303: additional information: startup egid

Problém

Sun Jan 24 15:56:06 2016
 Thread 1 cannot allocate new log, sequence 2677
 Private strand flush not complete
 Current log# 3 seq# 2676 mem# 0: /opt/app/oracle/oradata/ORCL/redo03.log
 Thread 1 advanced to log sequence 2677 (LGWR switch)
 Current log# 1 seq# 2677 mem# 0: /opt/app/oracle/oradata/ORCL/redo01.log

[oracle@orcl /]$ sqlplus / as sysdba
 SQL*Plus: Release 11.2.0.4.0 Production on Sun Jan 24 16:48:09 2016
 Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected.
 SQL> alter system switch logfile;
 alter system switch logfile
 *
 ERROR at line 1:
 ORA-01012: not logged on
 Process ID: 0
 Session ID: 0 Serial number: 0

SQL> shutdown immediate
 ORA-24324: service handle not initialized
 ORA-24323: value not allowed
 ORA-27140: attach to post/wait facility failed
 ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
 ORA-27301: OS failure message: Operation not permitted
 ORA-27302: failure occurred at: skgpwinit6
 ORA-27303: additional information: startup egid = 54321 (oinstall), current egid = 1000 (oracle)

Analýza

[oracle@orcl ~]$ ls -ltr /opt/
total 0
drwxrwxr-x. 4 oracle oinstall 38 May 22  2015 app
drwxr-xr-x. 3 root   root     21 May 22  2015 ORCLfmap
[oracle@orcl ~]$ ls -l  /opt/app/oracle/product
total 4
drwxrwxr-x. 3 oracle oracle     17 May 22  2015 11.2.0.4
drwxrwxrwx. 2 oracle oinstall 4096 Sep 15 21:12 instantclient_11_2

[oracle@orcl ~]$ ls -l /opt/app/oracle/product/11.2.0.4/db_1/bin/oracle
-rwxr-x--x. 1 oracle oracle 226806518 May 22  2015 /opt/app/oracle/product/11.2.0.4/db_1/bin/oracle

[oracle@orcl /]$ ls -l /opt/app/oracle/
total 4
drwxr-x---.  3 oracle oracle   17 Jul 21  2015 admin
drwxr-xr-x.  6 oracle oracle   56 May 22  2015 cfgtoollogs
drwxr-xr-x.  2 oracle oracle    6 May 22  2015 checkpoints
drwxrwxr-x. 11 oracle oracle 4096 May 22  2015 diag
drwxr-x---.  4 oracle oracle   28 Aug 24 13:11 fast_recovery_area
drwxr-x---.  3 oracle oracle   17 Aug 24 13:11 oradata
drwxr-----.  3 oracle oracle   17 Jun  4  2015 oradiag_oracle
drwxr-xr-x.  3 root   root     17 Sep 14 15:19 oradiag_root
drwxrwxr-x.  4 oracle oracle   46 Sep 15 21:13 product
[oracle@orcl /]$ ls -l /opt/app/
total 4
drwxrwxr-x. 11 oracle oinstall 4096 Sep 14 15:19 oracle
drwxrwx---.  5 oracle oracle     84 May 22  2015 oraInventory

Řešení

[oracle@orcl /]$ ps -ef | grep pmon
oracle     978     1  0  2015 ?        00:07:36 ora_pmon_ORCL
oracle   14185 12645  0 16:48 pts/2    00:00:00 grep --color=auto pmon
[oracle@orcl /]$ kill -9 978
[oracle@orcl /]$ ps -ef | grep pmon
oracle   14210 12645  0 16:49 pts/2    00:00:00 grep --color=auto pmon

chown oracle:oinstall /opt/app/oracle/product/11.2.0.4/db_1/bin/oracle
chown oracle:oinstall /opt/app/oracle/product/11.2.0.4/db_1/bin/tnslsnr

Kontrola

[oracle@orcl /]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Jan 24 16:49:12 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 6413680640 bytes
Fixed Size                  2265224 bytes
Variable Size            3389001592 bytes
Database Buffers         3003121664 bytes
Redo Buffers               19292160 bytes
Database mounted.
Database opened.
SQL> alter system switch logfile;

System altered.

SQL>

Komentáře