multi oracle version on one machine
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: multi oracle version on one machine

  1. #1
    Join Date
    Nov 2000
    Posts
    245
    I am planning to install 2 different oracle version on a machine.
    Could anyone give me a check list,
    what I need to prepare before and after install.
    How I switch between this 2 version?

    any input will be apprecaited.

    thanks

    jm

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Before installing things, be aware of the OFA architecture. Be very carefull of specifying the ORACLE_BASE/ b'cos oracle puts all its ORADATA files under this. So this where you have to carefull..

    Good luck.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2000
    Posts
    47
    Hi -

    Since I am limited to a single server for development and production, I go through this every time we migrate to a new release. The thing you need to ensure is that all of the ORACLE_XXX environment variables are correct for each process that wants to use a particular version. One easy way to do this is by installing the new version in a separate directory branch, modifying the oratab file appropriately for each SID, then using oraenv to set the complete environment for each process that wants to use a particular SID. Remember that you can set ORAENV_ASK="NO" in shell scripts for non-interactive jobs.

    An example of the (Unix) directory structure used here is:

    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=${ORACLE_BASE}/product/7.3.3 --- for 7.3.3
    ORACLE_HOME=${ORACLE_BASE}/product/8.0.6 --- for 8.0.6

    Tim

  4. #4
    Join Date
    Nov 2000
    Posts
    245
    Thanks for your guys repsonse.

    My environment is using OFA sturture. I don't see the problem.

    I am more concern about ORATAB, switch between 2 version, how about client site, tnsname, listener, ...do I have to upgrade too?

    Q:
    I remember when I installed oracle, oratab will created by installer. if I install the 2nd version oracle, does oratab will be overwritten or skip it?

    Q:
    what's the easiest way to switch 2 versions?

    Q:
    I assue tnsname need modifying, how about listener, I should
    use lower version or keep both?

    Q:
    can I only update server, client still keep lower version?
    can I mix (some clients use new verseion , some use old)




  5. #5
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Originally posted by jm
    Thanks for your guys repsonse.

    My environment is using OFA sturture. I don't see the problem.

    I am more concern about ORATAB, switch between 2 version, how about client site, tnsname, listener, ...do I have to upgrade too?

    Q:
    I remember when I installed oracle, oratab will created by installer. if I install the 2nd version oracle, does oratab will be overwritten or skip it?
    Not sure about this one.

    Q:
    what's the easiest way to switch 2 versions?
    I believe using . oraenv

    Q:
    I assue tnsname need modifying, how about listener, I should
    use lower version or keep both?
    You can keep both, they will be in their respective $O_H/network/admin

    Q:
    can I only update server, client still keep lower version?
    can I mix (some clients use new verseion , some use old)
    No problems here.




  6. #6
    Join Date
    Nov 2000
    Posts
    245

    Hi, Halo,

    Can I keep both listener running (start listener from different version), if yes, does Net*8 know which one to use?

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Halo
    Originally posted by jm
    Q:
    I remember when I installed oracle, oratab will created by installer. if I install the 2nd version oracle, does oratab will be overwritten or skip it?
    Not sure about this one.
    The installer will append a second entry to the oratab file with the correct variables.
    Q:
    what's the easiest way to switch 2 versions?
    I believe using . oraenv
    I agree
    Q:
    I assue tnsname need modifying, how about listener, I should
    use lower version or keep both?
    You can keep both, they will be in their respective $O_H/network/admin
    tnsnames.ora is the naming method for the client. The server only needs this information when connecting to another database or to itself via sql*net. I like to have one version of the tnsnames.ora file in the old $OH and create a link from the new $OH.

    The listener.ora file is the configuration file for the listener. I would have one listener for the entire machine and have configure both databases for it. You should use the latest version of oracle installed for version the listener.
    Q:
    can I only update server, client still keep lower version?
    can I mix (some clients use new verseion , some use old)
    No problems here.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Nov 2000
    Posts
    245

    thanks, great help.

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