I was having this error when another user was trying to connect to the database on the same user. The database was actually running as user oraA and the user who was trying to connect to it was oraB.
To fix it this is what I did:
1. Shutdown the database and listener as user oraA
2. As root user, added oinstall as primary group for oraA user:
3. Connected as oraA user and changed the permission or oracle binary as follows:
After doing some analysis, it was found that user oraA did not had oinstall as it primary group while oraB was having it. And the permission on $ORACLE_HOME/bin/oracle was -rwxr-xr-x
To fix it this is what I did:
1. Shutdown the database and listener as user oraA
2. As root user, added oinstall as primary group for oraA user:
# usermod -g oinstall oraA
3. Connected as oraA user and changed the permission or oracle binary as follows:
$ chmod 6751 $ORACLE_HOME/bin/oracle
$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oraA oinstall 196020393 Nov 29 2009 oracle
4. Started the listener and the database
5. Tested the connectivity from user oraB and it all worked.
No comments:
Post a Comment