Unix login script to set SID
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Unix login script to set SID

  1. #1
    Join Date
    Nov 2002
    Posts
    5

    Unhappy Unix login script to set SID

    I have several databases (7) on one IBM AIX machine. How do I prompt the user at OS login for a "specific" SID? I've heard that other DBAs write a script for this, but I don't have a clue as to how to write a script to do this. Can anyone help? Or have a script to prompt for a specific SID at OS login.

    --Thanks.

  2. #2
    Join Date
    Nov 2001
    Posts
    335
    Use oraenv script located in $ORACLE_HOME/bin. Variable ORAENV_ASK=YES makes oraenv scripts conversational.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  3. #3
    Join Date
    Nov 2002
    Posts
    5
    I'll give ORAENV_ASK=YES a try! Thanks

  4. #4
    Join Date
    Nov 2001
    Posts
    335
    Problem with the previous posting is that it does not take into consideration different oracle homes. oraenv will set oracle_home for you as well as oratab file set correctly.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

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