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

Thread: Su-Oracle

  1. #1
    Join Date
    Oct 2000


    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
    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
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    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
    Madrid, Spain
    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