Shulou(Shulou.com)06/01 Report--

Some time ago, when I was disabled and used exp for data migration, because the oracle user did not have the permission to write to the directory, I accidentally changed / U01 directly when I used the chown-R oracle:oinstall command to modify the permissions of the subdirectory under the linux.

The overall permission of the directory was changed, and I was confused in an instant. So the whole screen is jumping with modified directories and files.

The Times made the following error while executing the exp command:

EXP-00056: ORACLE error 27140 encountered

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 = 1020 (asmadmin), current egid = 1000 (oinstall)

When connecting to the database, TNS reported the following error.

But the business continues and is not affected. At the same time, view the $ORACLE_HOME/bin/oracle file permissions under oracle:

-rwxr-x--x 1 oracle oinstall 239626641 Mar 3 2017 oracle

Solution:

Modify $ORACLE_HOME/bin/oracle permission under oracle user

[oracle@dba_oracle1 dbhome_1] $pwd

/ u01/app/oracle/product/11.2.0/dbhome_1

[oracle@dba_oracle1 dbhome_1] $cd bin

[oracle@dba_oracle1 bin] $pwd

/ u01/app/oracle/product/11.2.0/dbhome_1/bin

[oracle@dba_oracle1 bin] $chown-R oracle:asmadmin oracle

After modification

-rwxr-x--x 1 oracle asmadmin 239626641 Mar 3 2017 oracle

Modifying file properties

[oracle@dba_oracle1 ~] $chmod 6751 $ORACLE_HOME/bin/oracle

[oracle@dba_oracle1 bin] $ls-la oracle

-rwsr-s--x 1 oracle asmadmin 239626641 Mar 3 2017 oracle

Done

The problems that occurred before the revision were solved, and there were no other problems.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.