SDEforLinux ORA-27140: attachtopost/waitfacilityfaile

Install SDE10forOracle on Linux, execute sqlplus under sde user error: ORA-27140: attachtopostwaitfacilityfailed while under oracle user

Install SDE10 for Oracle on Linux, execute sqlplus under sde user error: ORA-27140: attach to post/wait facility failed while under oracle user

When SDE10 for Oracle is installed on Linux, an error occurs when SQL plus is executed under the sde User:

ORA-27140: attach to post/wait facility failed

It is normal for oracle users.

The method for this error is as follows:

1. check whether it is a dba group.

This is generally the same as the oracle user group when creating an sde user.

2. chmod 6751 $ ORACLE_HOME/bin/oracle

After execution, the oracle file has the following permissions:
[Root @ rac2 bin] # pwd
/U01/app/oracle/10.2.0/db_1/bin
[Root @ rac2 bin] # ll oracle
-Rwsr-s -- x 1 oracle oinstall 112468374 04-06 oracle

This error is caused by the second reason. The strange thing is that chmod 775 cannot be used directly. You have to use the following command.

6751 ugoa permissions are set respectively.
The first six represents that u (owner) has read and write permissions and has no execution permissions.
The second digit 7 indicates that g (Group) has read, write, and execution permissions.
The third digit 5 indicates that o (other users) has read and execution permissions.
The fourth digit 1 indicates that a (owner, group, and other users) has the execution permission.
If a four-digit 6751 is represented as 675 in three digits, the fourth digit inherits the umask value.

Permission setting string in the following format: [ugoa...] [[+-=] [rwxX]...] [,...], u indicates the owner of the file, g indicates that the owner of the file belongs to the same group, o indicates that the owner of the file belongs to other people, and a indicates that all three are.

+ Adds a permission,-Indicates canceling the permission, and = indicates a unique permission.

R indicates that the file can be read, w indicates that the file can be written, and x indicates that the file can be executed only when the file is a subdirectory or the file has been set to executable.

-S: Set the owner or group ID of the process to the file owner during file execution.

-C: if the permission of the file has been changed, the change action is displayed.

-F: Do not display an error message if the file permission cannot be changed.

-V: displays details of permission changes.

-R: Change the permissions of all files and sub-directories in the current directory in the same way (that is, change one by one in the way of delivery)

-- Help: displays auxiliary instructions

-- Version: displays the version.