ORA-27140 error after creating another user
Recently, I did an installation of Oracle 10g on an AIX 10.2.0 machine using user 'oracle.' Everything was running fine using 'oracle' until I created another user, i.e., ora1 to login. I received the following error: "ORA-27140: attach to post/wait facility failed."
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 8 15:04:43 2005 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-27140: attach to post/wait facility failedI have browsed other sites for help but still am not able to solve it.
After you installed Oracle, did you run the $ORACLE_HOME/root.sh script as the root user? If after running this script, you still have a problem, then do the following:
cd $ORACLE_HOME/bin ls -l oracle
Your permissions should appear as follows:
-rwsr-s--x 61M Jun 21 2005 oracle
If not, then issue the following as 'oracle':
chmod 6751 oracle