29 Kasım 2018 Perşembe

[EN] ORA-27303: additional information: startup egid = 1000 (oinstall), current egid = 1300 (dba)


On one of our test database server we have 3 standalone databases. On 2 of them we saw following alertlog warnings and they were both down.

Thu Nov 29 11:04:27 2018
Errors in file /u02/app/oracle/diag/rdbms/dbx/DBX/trace/DBX_j000_38928500.trc:
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: Not owner
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 1000 (oinstall), current egid = 1300 (dba)
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process




We find out that UNIX group ownership of "oracle" file in DB_HOME/bin directory somehow changed.

Abnormal permissions:
-rwsr-s--x    1 oracle   dba       310184184 Sep 27 11:59 oracle

Normal permissions:
-rwsr-s--x    1 oracle   oinstall  310077325 Nov 11 2017  oracle

GRID_HOME/bin permissions was fine. But you should check them too. We gracefully shut down or aborted all databases and changed the ownership:

cd DB_HOME/bin
chown oracle:oinstall oracle
chmod 6751 oracle

Then started all databases and everything was fine.

Hiç yorum yok:

Yorum Gönder