Problem solve
Get help with specific problems with your technologies, process and projects.
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."
I am a newbie in Oracle. 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:
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
This was last published in May 2006
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments