Re: Change 8.1.7 EE install to 8.1.7 SE

I've never had good experiences with Oracle de-installing things - It takes forever and it is never complete.

I'd suggest defining new ORACLE_HOME and ORACLE_BASE, and deleting or renaming /var/opt/oracle/oraInst.loc, which otherwise would point to the existing ORACLE_BASE.

Then you can do a fresh install (installer won't know about existing product) and copy the instance specific files (dbs, network/admin, etc).

If everything works out you can then just blow away the old installation.

-Peter

Schmoltzie wrote:
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<u61hrc7m9mr0a_at_corp.supernews.com>...
> > "Schmoltzie" <schmoltzie_at_hotmail.com> wrote in message
> > news:853faaeb.0202051713.3ac2f3b6_at_posting.google.com...
> > > I need to remove an 8.1.7 EE installation and replace it with a 8.1.7
> > > SE installation on the same Solaris 8 server, without losing the data.
> > >
> > > My Plan:
> > > 1. Shutdown all instances and stop listner
> > > 2. mv $ORACLE_HOME /u01/app/oracle/product/8.1.7.orig
> > > 3. Install 8.1.7 SE
> > > 4. Copy over tnsname.ora, listner.ora, init<SID>.ora from EE install
> > > to SE install
> > > 5. Startup all instances and listner
> > >
> > > Does anyone see any problems with this?
> > >
> > > Chris Davis
> >
> > Sure, as you are not deinstalling EE the installer will think it is still
> > there.
> > Information about what is installed is *not* in the Oracle_home hierarchy
> > You need to backup and deinstall.
> > Please try to follow official and proven methods that will work instead of
> > shortcuts to hack you in.
> >
> > Hth
>
> Thanks Sybrand,
> Good point about the installed products info not being in ORACLE_HOME.
> So, here's the new plan .......
> 1. Shutdown all instances and stop listner
> 2. cp $ORACLE_HOME /u01/app/oracle/product/8.1.7.orig
> 3. cp $ORACLE_BASE /u01/app/oracle/admin.orig
> 4. De-install all oracle products
> 3. Install 8.1.7 SE
> 4. Copy over tnsname.ora, listner.ora, init<SID>.ora, etc ... from EE
> install to SE install
> 5. Startup all instances and listner
>
> Any one see any problems with this?
> Thanks,
>
> Chris Davis
Received on Thu Feb 07 2002 - 10:14:29 CST