upgrade question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: upgrade question

  1. #1
    Join Date
    Oct 2000
    Posts
    90

    Wink

    Assuming I want to udgrade one database which of the two below is the right way to start.
    Assuming the database name is MYDATABASE
    Also Assuming this is my oracle home:
    ORACLE_HOME=/oracle/orc/db/product/8.1.5;


    EXAMPLE ONE
    ------------------
    ORACLE_HOME=/oracle/orc/db/product/8.1.5;export ORACLE_HOME
    ORACLE_SID=MYDATABASE;export ORACLE_SID
    PATH=$PATH:$ORACLE_HOME/bin;export PATH
    LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH


    EXAMPLE TWO
    --------------------
    ORACLE_HOME=/oracle/orc/pp/product/8.1.5;export ORACLE_HOME
    ORACLE_SID=MYDATABASE;export ORACLE_SID


    which of the above examples is the right step before copying the init file to the new oracle home?


    dorothy

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The first one would be your best choice. Also include the CLASSPATH also in the settings.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2000
    Posts
    90
    What do you mean by CLASSPATH?
    is it this
    PATH=$PATH:$ORACLE_HOME/bin;export PATH ?

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Class path is used to specify where the java libraries are at.

    here you go.

    CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib
    export CLASSPATH


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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