| moving ORACLE_HOME [message #60968] |
Wed, 17 March 2004 07:05  |
Bala S
Messages: 4
Registered: November 2003
|
Junior Member |
|
|
Hello all,
a simple question.
Can i move ORACLE_HOME directory to a different directory in unix and access oracle without any problems.
For e.g if i move ORACLE_HOME from /tools/oracle/8.1.7 to /tools/ora817, do i have to change any other configuration other than ORACLE_HOME environment variable and /etc/oratab file.
regards,
Bala
|
|
|
|
|
|
|
|
|
|
| Re: moving ORACLE_HOME [message #61010 is a reply to message #60970] |
Fri, 19 March 2004 05:58  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
As Bala mentioned, better install the binaries in the desired folder.
Here is the plan
1. Shutdown DB
2. Install Oracle in desired place (I would make sure it is the same version level, down to patch level)
3. Make chnages in the following
a. .profile (set ORACLE_HOME, PATH, LIBPATHs)
b. /etc/oratab
4. Rename the original folder where Oracle was present just to be sure that nothing in there is being used
/tools/oracle/8.1.7 -> /tools/oracle/8.1.7.notused
5. Fireup the DB.
6. If all is fine, delete folder /tools/oracle/8.1.7.notused
Good Luck.
--
Sanjay
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
