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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > 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. > > [EMAIL PROTECTED] > > > > > > -----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" <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).