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

Thread: Missing user privileges on UNIX

  1. #1
    Join Date
    Jul 2000
    Posts
    6

    Thumbs down

    Hello all!

    I try to create a database with the dbassist tool from Oracle 8.1.5 under SCO UNIX. But even when I'm logged in as root after starting to create the database I got an error message that the user has no privileges. I can ignore this but then I get a lot of 'user is not logged on' messages. Somewhere there I stop
    Do I need a special DB or UNIX user? If yes, where do I have to create this user with what kind of privileges?

    Thanx for any help
    Greetings
    Marc

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    You dont create a database with root, you need to be logon as Oracle or any user that belongs to group DBA. Unless your root belongs to group DBA which is not very advisable, do as little tasks with root as possible!


  3. #3
    Join Date
    Jul 2000
    Posts
    6
    OK, thank you. It seems to work with user oracle but I needed to change all directories with chmod to be able to create the dirs with user oracle. Do I have wrong privileges on this user and if yes how to change them?

  4. #4
    Join Date
    Oct 2000
    Posts
    33
    yes, you have to chmod all the directories to make them accessable to the oracle user.

  5. #5
    Join Date
    Jul 2000
    Posts
    147
    If is a test database....

    chmod -R 777 /u01/........... it will change all in one line...

    Thanks

  6. #6
    Don't change recursive in ORACLE_HOME!!!!
    Because it's gonna change the setuid in some executables, especially oracle.
    Better, do a chown -R oracle:dba to the ORACLE_HOME
    Ramon Caballero, DBA, rcaballe@yahoo.com

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