how to change $ORACLE_HOME
From: MIS - Nick Price <nprice_at_date>
Date: 1995/09/27
Message-ID: <44cft9$vf4_at_icon1.intercon.net>#1/1
Date: 1995/09/27
Message-ID: <44cft9$vf4_at_icon1.intercon.net>#1/1
I need to change the location of $ORACLE_HOME on some databases here. Here is how I think it can be done:
- alter database backup controlfile to trace
- shutdown db
- remove existing control files
- change $ORACLE_HOME in PFILE and CONFIG file
- change $ORACLE_HOME in ORATAB
- set ORACLE_HOME to new location in environment (. oraenv)
- start SQLDBA and execute previous trace file to produce new control files;
I have tried this once and it worked OK. Now when I do this I get the following errors when executing the script to produce the new control files.
ORACLE instance started.
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'/database/system/PROD/system.dbf'
ORA-09782: sfifi: another instance has the same database mounted.
ORA-01507: database not mounted
Could someone please outline the necessary procedure and let me know what I am doing wrong ?
Thanks
Nick
-- +==============================================================================+Received on Wed Sep 27 1995 - 00:00:00 CET
+ Nick Price Technical Consultant +
+ Internet: nprice_at_7-Eleven.com Hong Kong Convenience Stores Ltd.+
+ Tel : +852 2802 6869 North Point +
+ Fax : +852 2802 1447 Hong Kong +
+==============================================================================+