upgrade to new version
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: upgrade to new version

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    78

    Post

    This question sounds stupid, but the same it's got me thinking.
    In upgrade, do you have to hit ENTER at the shell after
    setting the environmental variable, SID,etc. Or all need to be done in
    one line? I other words, should it look like the EXAMPLE 1 or EXAMPLE 2?


    EXAMPLE ONE
    ------------
    ORACLE_HOME=/oracle/zed/news/product/8.1.6;export ORACLE_HOME
    ORACLE_SID=REPORTS;export ORACLE_SID
    PATH=$PATH:$ORACLE_HOME/bin;export PATH
    LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH
    CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib
    export CLASSPATH

    EXAMPLE TWO
    -------------
    nationalnews oracle REPORTS /home/oracle
    $ORACLE_HOME=;;export ORACLE_HOME

    nationalnews oracle REPORTS /home/oracle
    $ORACLE_SID=REPORTS;export ORACLE_SID

    nationalnews oracle REPORTS /home/oracle
    $PATH=$PATH:$ORACLE_HOME/bin;export PATH

    nationalnews oracle REPORTS /home/oracle
    $LD_LIBRARY_PATH=$ORACLE_HOME/lib;

    nationalnews oracle REPORTS /home/oracle
    $CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib
    export CLASSPATH

    nationalnews oracle REPORTS /home/oracle
    $


    P.S.
    nationalnews is the machine name.
    REPORTS is the database name
    O/S is SUN

  2. #2
    Join Date
    Sep 2000
    Posts
    47
    Not sure of you're exact question, but hope the following helps.

    Unix shells are line (carriage-return, line-feed) oriented. To put multiple commands on one line, separate them with semicolons ';' (as in Example 1).
    Entering:

    command 1; command 2

    is exactly the same as entering:

    command 1
    command 2

    To extend a command across more than one line, use a backslash '\'.

    Example 1 looks fine (for Bourne or Korn).

    Example 2 looks odd in that it appears to assign a value to a value. For example:
    $ORACLE_SID=REPORTS
    should read
    ORACLE_SID=REPORTS

    In general, the syntax is "VARIABLE=value; export VARIABLE" (assuming you want it be be global).

    Tim

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