欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 改变数据库实例名称 env : Windows + oracle8i ———————————- 1.Be sure database closed.if not ,please shutdown first. 2.利用oradim 可以创建服务， ORADIM -NEW -SID new
欢迎进入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 setti本文来源gaodai$ma#com搞$代*码*网(ng 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.
转载请注明原文链接：改变数据库实例名称
