欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入
改变数据库实例名称
env : windows + oracle8i
----------------------------------
1.be sure database closed.if not ,please shutdown first.
2.利用oradim 可以创建服务，
> oradim -new -sid newname -intpwd pwdnewname.pwd -startmode auto -pfile yourpfile,then you can see the new servcie .
3. be sure the oracle_sid is set in the registry correctly. goto
start button-->run-->type regedt32-->
goto the following directory tree within the registry -
hkey_local_machine -> software -> oracle -
highlight oracle - look on the left side look for oracle_sid =
to change you can highlight oracle_sid - right click on your mouse and
select modify.
enter the sid.
the above is only valid when using default_home, when you have another
home then you need to highlight that home under oracle key
usually home1-homex . no spaces can be entered after the = when setting oracle_sid
at the dos prompt, set oracle_sid=xyz should be used and not
set oracle_sid = xyz
4.be sure the new instance is started goto
start-->settings-->control panel-->services
and check if the database service is started.
5..in command line prompt, set oracle_sid=newname
6.startup the database ,then you can view v$instance,you will see your new instance name here.