Q

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 failed
I 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 first published in May 2006
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close