I created an application user appladm on UNIX to be able to access oracle. This user is not the owner of oracle. The user belong sto the dba group. I have set ORACLE_HOME, ORACLE_SID and all necessary variables. However start sqlplus on UNIX where oracle is installed. I enter the user name and password. I get the error ORACLE not available. The oracle owner goes in without any problems. What could the problem be.
ORACLE not available states that the Oracle database is down.Log in as user Oracle and start the database.Oracle will obivously login since he is the owner under which Oracle software is installed.
Please start the Oracle server and listener and then check from appladm user.And also include the appladm user under oinstall group.
The user appladm user should be in group : DBA as well as OINSTALL same as oracle user.
In case of any help please be free to ask me at email@example.com
Rohit Nirkhe,Oracle DBA,OCP 8i
Thanks for the reply. I got a solution, I changed permissions on $ORACLE_HOME/bin : chmod -R 6751 $ORACLE_HOME/bin and it worked.