Re: how to change $ORACLE_HOME

From: Doug Harris <ah513_at_FreeNet.Carleton.CA>
Date: 1995/10/04
Message-ID: <DFwEwG.D2_at_freenet.carleton.ca>#1/1

   If you are running under Solaris this can be caused by having the init.ora parameter use_ism set to TRUE. You need to set use_ism=FALSE and then start up and cleanly shut down the database before you can start it up under a new ORACLE_HOME. This may also be relevant for other O/Ss so check for use_ism even if you are not running Solaris.

Mani Maran (mmaran01_at_csd.eds.com) writes:
>>
>> 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.
>>

>   Tried this once may be the problem. When you try the script once, the control file
> will be created and the database will be mounted and opened. So you may not be able to 
> mount the database again. Write back if this is not the scenario.

>> 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

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##

Received on Wed Oct 04 1995 - 00:00:00 CET