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
Dig Deeper on Oracle database design and architecture
-
![]()
How to enable remote Oracle OS authentication with OS_AUTHENT_PREFIX
-
![]()
ORA-12514 error when connecting to the Oracle database through Toad
By: Brian Peasland
-
![]()
Solving the ORA-00904 error: invalid identifier in Oracle
By: Brian Peasland
-
![]()
Why am I receiving the ORA-12535 error when using a remote database?
