On Sat, May 04, 2002 at 03:03:19PM -0800, Kimberly Smith wrote: > 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.....
backup, backup you backups. > > 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). -- =============================================================== Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
