改变数据库实例名称

王朝other·作者佚名  2006-11-24
窄屏简体版  字體: |||超大  

改变数据库实例名称

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 = <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.

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有  導航