DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2000

    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.

  2. #2
    Join Date
    Feb 2001
    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 rohitsn@altavista.com

    Rohit Nirkhe,Oracle DBA,OCP 8i

  3. #3
    Join Date
    Sep 2000
    Thanks for the reply. I got a solution, I changed permissions on $ORACLE_HOME/bin : chmod -R 6751 $ORACLE_HOME/bin and it worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.