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
Printable View
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
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
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
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)
Quote:
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.
Hi, Halo,
Can I keep both listener running (start listener from different version), if yes, does Net*8 know which one to use?
Quote:
Originally posted by Halo
The installer will append a second entry to the oratab file with the correct variables.Quote:
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.
I agreeQuote:
Q:
what's the easiest way to switch 2 versions?
I believe using . oraenv
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.Quote:
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
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.
Quote:
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.
thanks, great help.