Change the Oracle Home

I have Oracle 9i with 4 Databases All Databases is runing well  there is no problem
but I need to change Oracle home  
c:\Oracle\ora92   to  c:\ora9i

I have Microsoft Windows [Version 5.2.3790]

 
How to do this in a fast way

bye

LVL 2
patmoliAsked:
Who is Participating?
 
LindaCConnect With a Mentor Commented:
Start - Control Panel - system - Advance - Environment Variable

New:  ORACLE_HOME
 c:\ora9i

New:  TNS_ADMIN
 c:\ora9i \network\admin

ok

and

ok.
0
 
Mark GeerlingsDatabase AdministratorCommented:
You don't!

This value is recorded in lots of places (registry entries, configuration files, parameter files, etc.) and CANNOT be easily changed!

What reason or advantage do see for changing this?
0
 
joebednarzCommented:
Agree with mark... don't just move your Oracle program files.  There is an option that is usually in the "Oracle Installation Products" folder of your start menu that has an item called "Home Selector"... but this is so you can specify which version of Oracle you want to be the default... i.e., 9i, 9iR2, 10g, etc.  This will set up in your path which version of Oracle has its BIN directory first, message files, etc.

Are you by chance maybe trying to move the DATAFILES for the databases?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
patmoliAuthor Commented:
Hi,
I know Oracle Home Information stored lots of places (registry entries, configuration files, parameter files, etc.). The reson to change the Oracle home because I have 4 servers all of three servers have oracle home is c:\ora9i  and only one server is have c:\oracle\ora92 and when I am make a Script
and run want to run all of server 3 servers is ok but for the 4th server have different Oralce home
I need to edit first adn then run thats why I want to change Oracle home

bye

0
 
Mark GeerlingsDatabase AdministratorCommented:
You will have to continue to edit the script files for this server.  
0
 
patmoliAuthor Commented:
Hi,
If I shutdown all my Database on that server and then re-install the Oracle9i again
and after that edit Init.ora files of each database and chage the Oracle home
and then start again all database do you think it works

bye
0
 
Mark GeerlingsDatabase AdministratorCommented:
Sure, that may work.  I just assumed that you didn't want to do a full Oracle re-install.
0
 
patmoliAuthor Commented:
Hi,

I didn't want to full Oracle re-install but I think I have no other way
or may be.

bye
0
 
joebednarzCommented:
Sounds like a lot of work to me so you don't have to modify one script...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.