Re: Renaming Oracle Instance

--0__=ykFgb3j55Hej4AMcEkDBDApGXOxwKxurI2BIFQzyhr1YgMcipgY7Jp7e
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Assuming you are on UNIX ...

1. Shutdown the database
2. cp $ORACLE_HOME/dbs/initORCL.ora $ORACLE_HOME/dbs/initORA8.ora (assuming config and init files are merged)
3. ORACLE_SID=ORA8;export ORACLE_SID
4. svrmgrl < connect internal;startup
5. ps -ef | grep ORA8

Your new instance is running..

"magesh" <magesh_at_garoo.ne.jp> on 23/08/2000 12:34:11 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: milind/DBAMUM01/SHCIL/IN)

Subject: Renaming Oracle Instance

Hi All

  How to rename an Oracle Instance , Currently my Oracle instance is ORCL ,
Now i want to change it as ORA8.

Regards
Magesh

--0__=ykFgb3j55Hej4AMcEkDBDApGXOxwKxurI2BIFQzyhr1YgMcipgY7Jp7e
Content-type: text/html;

        name="att-1.htm"

Content-Disposition: attachment; filename="att-1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by0yMDIyLWpwIiBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZT4NCjxNRVRBIGNvbnRlbnQ9Ik1TSFRN TCA1LjAwLjI5MTkuNjMwNyIgbmFtZT1HRU5FUkFUT1I+DQo8U1RZTEU+PC9TVFlMRT4NCjwvSEVB RD4NCjxCT0RZIGJnQ29sb3I9I2ZmZmZmZj4NCjxESVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+ SGkgQWxsPC9GT05UPjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1B cmlhbCBzaXplPTI+Jm5ic3A7IEhvdyB0byByZW5hbWUmbmJzcDthbiAgT3JhY2xlIEluc3RhbmNl ICwgDQpDdXJyZW50bHkgbXkgT3JhY2xlIGluc3RhbmNlIGlzIE9SQ0wgLCBOb3cgaSB3YW50IHRv IGNoYW5nZSBpdCBhcyANCk9SQTguPC9GT05UPjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxE SVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+UmVnYXJkczwvRk9OVD48L0RJVj4NCjxESVY+PEZP TlQgZmFjZT1BcmlhbCBzaXplPTI+TWFnZXNoPC9GT05UPjwvRElWPjwvQk9EWT48L0hUTUw+DQo=

--0__=ykFgb3j55Hej4AMcEkDBDApGXOxwKxurI2BIFQzyhr1YgMcipgY7Jp7e--
Received on Wed Aug 23 2000 - 05:47:20 CDT