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

Thread: creating users

  1. #1
    Join Date
    Nov 2000
    Posts
    175
    Hello Everyone,

    I need some opinions with some logical reasons behind them.

    I have two versions or Oracle on the same Unix Server. Is it better to have two users (OraVer#1, OraVer#2) which each have there own environments when signing on which is automatically sourced. OR Is it better to have only one Oracle user on the box and source their environment everytime you log on? Is either way a standard?

    Thanks in advance
    Kathy

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Better is a relative term.

    Better for me is one user and two different $ORACLE_HOME's. This way, when I upgrade from version x to version y I don't have to worry about file permissions in my data directories. In order to get the right environment, I use the oraenv script (coraenv in /bin/csh).
    Jeff Hunter

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Smile switch_home OR select_sid

    We use 'switch_home' OR 'select_sid' for our DBA GROUP management server having all the versions from 734 to 817 for testing purposes.

    Here you go:
    <font face=courier>
    server1% more switch_home
    # @(#)cshrc 1.11 89/11/29 SMI
    umask 022
    setenv ORAENV_ASK NO
    #
    echo " 1. LLLL (Oracle 7.3.4)"
    echo " 2. MMMM (Oracle 7.3.4)"
    echo " 3. PPPP (Oracle 8.0.5)"
    echo " 4. QQQQ (Oracle 8.0.5)"
    echo " 5. RRRR (Oracle 8.1.5)"
    echo " 6. SSSS (Oracle 8.0.5)"
    echo " "
    echo -n "Please select by number <6> : "
    set ans = $<
    if ( $ans == "1" ) then
    setenv ORACLE_SID LLLL
    source /usr/bin/coraenv
    else if ( $ans == "2" ) then
    setenv ORACLE_SID MMMM
    source /usr/bin/coraenv
    else if ( $ans == "3" ) then
    setenv ORACLE_SID PPPP
    source /usr/bin/coraenv
    else if ( $ans == "4" ) then
    setenv ORACLE_SID QQQQ
    source /usr/bin/coraenv
    else if ( $ans == "5" ) then
    setenv ORACLE_SID RRRR
    source /usr/bin/coraenv
    else if ( $ans == "6" ) then
    setenv ORACLE_SID SSSS
    source /usr/bin/coraenv
    else
    # ............DEFAULT IT TO ONE YOU WANTED............
    setenv ORACLE_SID ZZZZ
    source /usr/bin/coraenv
    endif
    #
    #end of file

    </font>

    set an alias for this script and make it handy...

    [Edited by sreddy on 01-13-2001 at 01:29 PM]

  4. #4
    Join Date
    Nov 2000
    Posts
    175
    WOW, thanks for the great advice, this may solve my confusion.

    Just for clarification.

    This script is actually:
    your entire oraenv file (that reside in /usr/lbin), thats all thats inside of it
    OR just an addition to your oraenv file, you have other items in there also

    FYI, I am trying to change items inside an oraenv file that I copied from another server, while installing 806 and 816 together on a different server.

    Thanks

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    tns_admin

    make sure you have the right TNS_ADMIN path in local modifications at the end of coraenv/oraenv scripts.

    Thats it pretty much. Rest everything will be Okey. We use it every day.

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