Re:Renaming Oracle Instance

From: <dgoulet_at_vicr.com>
Date: Wed, 23 Aug 2000 09:45:24 -0400
Message-Id: <10598.115364@fatcity.com>

Depends on what you want to rename. If you want to rename the global name then the 'alter database rename global_name to <whatever>;' will do the trick. If you want to change the sid, shutdown, rename init<sid>.ora & restart.

Dick Goulet

____________________Reply Separator____________________

Subject: Renaming Oracle Instance
Author: "magesh" <magesh_at_garoo.ne.jp>
Date: 8/22/00 11:04 PM

Hi All

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

Regards
Magesh
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-2022-jp" http-equiv=Content-Type>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi All</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>  How to rename an Oracle Instance ,
Currently my Oracle instance is ORCL , Now i want to change it as ORA8.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2>Magesh</FONT></DIV></BODY></HTML>
Received on Wed Aug 23 2000 - 08:45:24 CDT