Skip to content

Category: Database Troubleshoot

“Wait for a undo record” OR “Wait for stopper event to be increased” database wait events

We faced a scenario in our database where users were complaining about database performance. Database seems to be hanging and queries were either stuck or not running at all.

It was also seen that UNDO tablespace consumption was increasing.

Leave a Comment

ORA-27300: OS system dependent operation:invalid_egid

In one of our EBS database we faced issue when connecting to SQLPLUS

Error message which was coming up was as below:

[oracle@dbserver bin]$ sqlplus apps/apps

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

ERROR:
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 = 11 (asmadmin), current egid =
17 (oinstall)

Leave a Comment