DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Not login in as applmgr

  1. #1
    Join Date
    Sep 2000
    Posts
    33
    Hi,

    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
    Location
    Bombay,India
    Posts
    530
    Hi,
    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

    Regards.
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  3. #3
    Join Date
    Sep 2000
    Posts
    33
    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