how to change $ORACLE_HOME

From: Mani Maran <mmaran01_at_csd.eds.com>
Date: 1995/10/03
Message-ID: <44s09b$p2m_at_maverick.tad.eds.com>#1/1


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

Good Luck

---
Mani Maran                                           EDS Consultant
Voice: 214-828-7572.... Fax: 841-6886                999 Haskel
Commercial Services Division, Southland Account  Dallas, Texas 75... USA
"Opinions expressed herein are not necessarily supported by my employer."
Received on Tue Oct 03 1995 - 00:00:00 CET

Original text of this message