Re: I need to change the instance name (to Dennis)

I am almost 100% sure.
Because i have the application also running in the 8.1.6.

Thanks Friends

Eriovaldo

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 07, 2002 12:18 PM

> Right
>
> BUT: make sure you do not use any option that does not exist in the
standard
> edition
> but existed in the enterprise edition.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, May 07, 2002 12:18 PM
>
>
> >
> > Dennis :
> >
> > Thanks for your answer.
> > Well, I need to downgrade my database, changing EE for SE, so ...
> > The most problem is that the v$instance is used in the aplication.
> > I saw in the metalink a document that helps to change the db_name and
not
> > the instance_name, understand..
> > so ...
> > I thought to create the new one, with the new name and migrate to it and
> > after it to change the name to the old one...
> > Like that, i shouldn't change the application .
> >
> > But i hope that the best way is :
> >
> > Deinstall and install the new version.
> > And to migrate it fully.
> >
> > Right ?
> >
> > Regards
> > Eriovaldo
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, May 06, 2002 11:53 AM
> >
> >
> > > Eriovaldo - Often the lot of a DBA is to balance value and risk. Here,
> you
> > > must ask yourself - what is the value of retaining the same instance
> name,
> > > and what are the risks to my production environment? If you perceive
the
> > > value to be high and the risks low, then go for it. But often
> (especially
> > > after you've been stung a few times) it seems that the value wasn't so
> > great
> > > after all. How long can you have your production site down? What
happens
> > if
> > > something goes wrong and you have them down quite a bit longer than
you
> > > estimated? You can lower the risk to your production site by creating
> the
> > > new instance (different name), and getting it all prepared before you
> take
> > > the production site down for the export. If most of your users access
> the
> > > instance via SQL*Net (Net8), you can put an alias there, so they don't
> > have
> > > to change a thing.
> > > Of course, if your boss says "do it or else", then the value/risk
> > > equation changes dramatically.
> > > Dennis Williams
> > > DBA
> > > Lifetouch, Inc.
> > > dwilliams_at_lifetouch.com
> > >
> > >
> > > -----Original Message-----
> > > Sent: Sunday, May 05, 2002 5:18 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > Actualy, I am confused, because this is my production environment and
I
> > > need to get sucess in this operation.
> > >
> > > It is necessary, and i would like to keep the old name of instance,
> > because
> > > i will change the BD version.
> > > I think the best way is :
> > >
> > > 1.) backup the software and datafiles
> > > 2.) Export all the database
> > > 3.) Deinstanll the old software
> > > 4.) Install the new version
> > > 5.) Create the instance with the old name
> > > 6.) Import the database
> > >
> > > but it will take a while.
> > > I am looking for a fast way ,
> > >
> > > Understand ?
> > >
> > > Thanks
> > >
> > > Regards
> > >
> > > Eriovaldo
> > >
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Saturday, May 04, 2002 8:03 PM
> > >
> > >
> > > > Its actually the easiest part. However, I don't want to miss a step
> > > > so you best running off to Metalink. They actually have a note out
> > > > there on how to do it. Not quite up to date for 9i but close.
> > > >
> > > > You need to shutdown your database, change your oracle sid, rename
> your
> > > > init, if using an i version change the instance name and if desired
> the
> > > > service
> > > > name. Hum, me thinks that's it. I may be missing something though.
> > > > I feel like I am missing something.....
> > > >
> > > > However, the moral of the story is that its quite easy and I have
> > > > done it a couple of times. You need to make a decision on what to
> > > > do with your directories structures if you are using the
> > > > $ORACLE_BASE/admin/<sid>
> > > > structure. There is no technical reason to change it except for
> > > > your own sanity.
> > > >
> > > > -----Original Message-----
> > > > Andrietta
> > > > Sent: Saturday, May 04, 2002 12:23 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > > Friends :
> > > >
> > > > I need to change the instance name.
> > > > For example it is : DEVELOP and I need to put DEVELOPER.
> > > >
> > > > I know how to change the database name , but not the instance name
..
> > > >
> > > > Any idea ?
> > > >
> > > > Regards
> > > >
> > > > Eriovaldo
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Eriovaldo Andrietta
> > > > INET: eca_at_siteplanet.com.br
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > San Diego, California -- Public Internet access / Mailing
Lists
> > > > --------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from). You may
> > > > also send the HELP command for other information (like subscribing).
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Kimberly Smith
> > > > INET: ksmith2_at_myfirstlink.net
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > San Diego, California -- Public Internet access / Mailing
Lists
> > > > --------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from). You may
> > > > also send the HELP command for other information (like subscribing).
> > > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Eriovaldo Andrietta
> > > INET: eca_at_siteplanet.com.br
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: DENNIS WILLIAMS
> > > INET: DWILLIAMS_at_LIFETOUCH.COM
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Eriovaldo Andrietta
> > INET: eca_at_siteplanet.com.br
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
> INET: adaryechiel_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eriovaldo Andrietta
  INET: eca_at_siteplanet.com.br

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).