Su-Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Su-Oracle

  1. #1
    Join Date
    Oct 2000
    Posts
    42

    Question

    Can someone explian to me the purpose of doing (Su - Oracle) while working in a Unix environment? I know that with System, Sys, and Internal you can perform a lot of administrative duties within Oracle but why SU - Oracle or the Unix id Oracle is so important. Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    In most unix installations, the user "oracle" owns the oracle software. If the database needs to get started, the "oracle" user id does it, not system or sys.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    Posts
    417
    oracle is most likely an operating system user, while system and sys are database users. su oracle will log you into the oracle operating system user provided you know the password, so you can manage the database and related filesystems.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Oracle is an UNIX user
    if you do su oracle you can still login as oracle but .profile wont be read therefore the environment variables wont be changed
    if you do su - oracle .profile will be read

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