资源描述:
《oracle数据库名实例等概念》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、oracle数据库名实例等概念Clearconcepts:dbname,instance_name,ORACLE_SID,dbdomain,globalname,servicename,Note:thewritingenvironmentisOraclelOgRelease2(10.2)1,databasename1.,theconceptofdatabasenameThenameofthedatabase(dbname)istheidentityofadatabase,justliketheIDnumberofaperson.Ifamachi
2、neisloadedwithafulldatabase,theneachdatabasehasadatabasename・Afterthedatabaseisinstalledorcreated,theparameterDBNAMEiswrittenintotheparameterfile・Fonnstasfollows:############################################DatabaseIdentificstion###########################################Dbcl
3、omain二〃〃Dbname=orclWhenyoucreateadatabase,youshouldconsideragooddatabasename,andafteryoucreatethedatabase,thedatabasenameshouldnotbemodified,evenifyouwanttomodifyitwillbeverytroublesome.Becausethedatabasenameisalsowrittenintothecontrolfile,thecontrolfileisstoredinbinaryform,
4、andtheusercannotmodifythecontentsofthecontrolfile・Assumethattheusermodifiesthedatabasenameintheparameterfile,whichmodifiesthevalueoftheDB_NAME・However,whenOraclestarts,the0RA-01103errorisreturnedbecausetheDB_NAMEintheparameterfiledoesnotmatchthedatabasenameinthecontrolfile,c
5、ausingthedatabasestartuptofai1.1.functionofdatabasenameDatabasenamesarerequiredwhenyouinstalldatabases,createnewdatabases,createdatabasecontrolfiles,modifydatastructures,andbackupandrestoredatabases・TherearemanyOracleinstallationfiledirectoriesthatarerelatedtodatabasenames,s
6、uchas:Winnt:FracleproductlO.2.OoradataDB_NAME...Unix:/home/app/oracle/product/10.2.0/oradata/DB_NAME/...Anotherexampleistheparameterfilepfile:Winnt:FracleproductlO.2.OadminDB_NAMEpf订einit.ora.54200885729Unix:/home/app/oracle/product/10.2.0/admin/DB_NAME/pfile/init$0RACLE_SID
7、.oraIfthecontrolfileisdamagedorlost,thedatabasewillnotbeloaded,thenyouhavetorecreatethecontrolfile,starttheinstancemethodisinnomountmode,andthenwiththecreatecontrolfilecommandtocreatethecontrolfile,ofcourse,mustalsobespecifiedintheorderofDB_NAME・1.modifythedatabasenameRecomm
8、endation:youshoulddeterminethedatabasenamewhencreatingthedatabase,andthedat