| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> oracle >> Oracle quan ju shu ju ku ming 、 huan jing bian liang he sid de qu bie
 

Oracle quan ju shu ju ku ming 、 huan jing bian liang he sid de qu bie

2008-08-15 05:14:49 编辑來源:互联网 评论
 
本文为【Oracle全局数据库名、环境变量和sid的区别】的拼音翻译版
  yi 、 shu ju ku ming
  shen me shi shu ju ku ming
  shu ju ku ming jiu shi yi ge shu ju ku de biao shi , jiu xiang ren de shen fen zheng hao yi yang 。 ta yong shen shu DB_NAME biao shi , ru guo yi tai ji qi shang zhuang le duo quan shu ju ku , na me mei yi ge shu ju ku dou you yi ge shu ju ku ming 。 zai shu ju ku an zhuang huo chuang jian wan cheng zhi hou , shen shu DB_NAME bei xie ru shen shu wen jian zhi zhong 。 ge shi ru xia :
  DB_NAME=myorcl
  ...
  zai chuang jian shu ju ku shi jiu ying kao lv hao shu ju ku ming , bing qie zai chuang jian wan shu ju ku zhi hou , shu ju ku ming bu yi xiu gai , ji shi yao xiu gai ye hui hen ma fan 。 yin wei , shu ju ku ming huan bei xie ru kong zhi wen jian zhong , kong zhi wen jian shi yi er jin zhi xing shi cun chu de , yong hu wu fa xiu gai kong zhi wen jian de nei rong 。 jia she yong hu xiu gai le shen shu wen jian zhong de shu ju ku ming , ji xiu gai DB_NAME de zhi 。 dan shi zai Oracle qi dong shi , you yu shen shu wen jian zhong de DB_NAME yu kong zhi wen jian zhong de shu ju ku ming bu yi zhi , dao zhi shu ju ku qi dong shi bai , jiang fan hui ORA-01103 cuo wu 。 shu ju ku ming de zuo yong
  shu ju ku ming shi zai an zhuang shu ju ku 、 chuang jian xin de shu ju ku 、 chuang jian shu ju ku kong zhi wen jian 、 xiu gai shu ju jie gou 、 bei fen yu hui fu shu ju ku shi dou xu yao shi yong dao de 。
  you hen duo Oracle an zhuang wen jian mu lu shi yu shu ju ku ming xiang guan de , ru :
  winnt: d:\oracle\product\10.1.0\oradata\DB_NAME\...
  Unix: /home/app/oracle/product/10.1.0/oradata/DB_NAME/...
  pfile:
  winnt: d:\oracle\product\10.1.0\admin\DB_NAME\pfile\ini.ora
  Unix: /home/app/oracle/product/10.1.0/admin/DB_NAME/pfile/init$ORACLE_SID.ora
  gen zong wen jian mu lu :
  winnt: /home/app/oracle/product/10.1.0/admin/DB_NAME/bdump/...
  ling wai , zai chuang jian shu ju shi ,careate database ming ling zhong de shu ju ku ming ye yao yu shen shu wen jian zhong DB_NAME shen shu de zhi yi zhi , fou ze jiang chan sheng cuo wu 。
  tong yang , xiu gai shu ju ku jie gou de yu ju alter database, dang ran ye yao zhi chu yao xiu gai de shu ju ku de ming cheng 。
  ru guo kong zhi wen jian sun huai huo diu shi , shu ju ku jiang bu neng jia zai , zhe shi yao chong xin chuang jian kong zhi wen jian , fang fa shi yi nomount fang shi qi dong shi li , ran hou yi create controlfile ming ling chuang jian kong zhi wen jian , dang ran zhe ge ming ling zhong ye shi zhi zhi DB_NAME。
  huan you zai bei fen huo hui fu shu ju ku shi , dou xu yao yong dao shu ju ku ming 。
  zong zhi , shu ju ku ming hen chong yao , yao zhun que li jie ta de zuo yong 。 cha xun dang qian shu ju ming
  fang fa yi :select name from v$database;
  fang fa er :show parameter db
  fang fa san : cha kan shen shu wen jian 。 xiu gai shu ju ku ming
  qian mian jian yi : ying zai chuang jian shu ju ku shi jiu que ding hao shu ju ku ming , shu ju ku ming bu ying zuo xiu gai , yin wei xiu gai shu ju ku ming shi yi jian bi jiao fu duo de shi qing 。 na me xian zai jiu lai shuo ming yi xia , ru he zai yi chuang jian shu ju zhi hou , xiu gai shu ju ku ming 。 bu zhou ru xia :
  1. guan bi shu ju ku 。
  2. xiu gai shu ju ku shen shu wen jian zhong de DB_NAME shen shu de zhi wei xin de shu ju ku ming 。
  3. yi NOMOUNT fang shi qi dong shi li , xiu jian kong zhi wen jian ( you guan chuang jian kong zhi wen jian de ming ling yu fa , qing shen kao oracle wen dang ) er 、 shu ju ku shi li ming
  shen me shi shu ju ku shi li ming ?
  shu ju ku shi li ming shi yong yu he cao zuo xi tong jin xing lian xi de biao shi , jiu shi shuo shu ju ku he cao zuo xi tong zhi jian de jiao hu yong de shi shu ju ku shi li ming 。 shi li ming ye bei xie ru shen shu wen jian zhong , gai shen shu wei instance_name, zai winnt ping tai zhong , shi li ming tong shi ye bei xie ru zhu ce biao 。
  shu ju ku ming he shi li ming ke yi xiang tong ye ke yi bu tong 。
  zai yi ban qing kuang xia , shu ju ku ming he shi li ming shi yi dui yi de guan xi , dan ru guo zai oracle bing xing fu wu qi jia gou ( ji oracle shi shi ying yong ji qun ) zhong , shu ju ku ming he shi li ming shi yi dui duo de guan xi 。 zhe yi dian zai di yi pian zhong yi you tu li shuo ming 。 cha xun dang qian shu ju ku shi li ming
  fang fa yi :select instance_name from v$instance;
  fang fa er :show parameter instance
  fang fa san : zai shen shu wen jian zhong cha xun 。 shu ju ku shi li ming yu ORACLE_SID
  sui ran liang zhe dou biao shi oracle shi li , dan liang zhe shi you qu bie de 。instance_name shi oracle shu ju ku shen shu 。 er ORACLE_SID shi cao zuo xi tong de huan jing bian liang 。ORACLD_SID yong yu yu cao zuo xi tong jiao hu , ye jiu shi shuo , cong cao zuo xi tong de jiao du fang wen shi li ming , bi xu tong guo ORACLE_SID。 zai winnt bu tai ,ORACLE_SID huan xu cun zai yu zhu ce biao zhong 。
  qie ORACLE_SID bi xu yu instance_name de zhi yi zhi , fou ze , ni jiang hui shou dao yi ge cuo wu , zai unix ping tai , shi “ORACLE not available”, zai winnt ping tai , shi “TNS: xie yi shi pei qi cuo wu ”。 shu ju ku shi li ming yu wang luo lian jie
  shu ju ku shi li ming chu le yu cao zuo xi tong jiao hu wai , huan yong yu wang luo lian jie de oracle fu wu qi biao shi 。 dang ni pei zhi oracle zhu ji lian jie chuan de shi hou , jiu xu yao zhi ding shi li ming 。 dang ran 8i yi hou ban ben de wang luo zu jian yao qiu shi yong de shi fu wu ming SERVICE_NAME。 zhe ge gai nian jie xia lai shuo ming 。
  san 、 shu ju ku yu ming
  shen me shi shu ju ku yu ming ?
  zai fen bu gong shu ju ku xi tong zhong , bu tong ban ben de shu ju ku fu wu qi zhi jian , bu lun yun xing de cao zuo xi tong shi unix huo shi windows, ge fu wu qi zhi jian dou ke yi tong guo shu ju ku lian lu jin xing yuan cheng fu zhi , shu ju ku yu ming zhu yao yong yu oracle fen bu shi huan jing zhong de fu zhi 。 ju li shuo ming ru :
  quan guo jiao tong yun zheng xi tong de fen bu shi shu ju ku , qi zhong :
  fu jian jie dian : fj.jtyz
  fu jian xia men jie dian : xm.fj.jtyz
  jiang xi : jx.jtyz
  jiang xi shang rao :sr.jx.jtyz
  zhe jiu shi shu ju ku yu ming 。
  shu ju ku yu ming zai cun zai yu shen shu wen jian zhong , ta de shen shu shi db_domain. cha xun shu ju ku yu ming
  fang fa yi :select value from v$parameter where name = 'db_domain';
  fang fa er :show parameter domain
  fang fa san : zai shen shu wen jian zhong cha xun 。 quan ju shu ju ku ming
  quan ju shu ju ku ming = shu ju ku ming + shu ju ku yu ming , ru qian shu fu jian jie dian de quan ju shu ju ku ming shi :oradb.fj.jtyz si 、 shu ju ku fu wu ming
  shen me shi shu ju ku fu wu ming ?
  cong oracle9i ban ben kai shi , yin ru le yi ge xin de shen shu , ji shu ju ku fu wu ming 。 shen shu ming shi SERVICE_NAME。
  ru guo shu ju ku you yu ming , ze shu ju ku fu wu ming jiu shi quan ju shu ju ku ming ; fou ze , shu ju ku fu wu ming yu shu ju ku ming xiang tong 。 cha xun shu ju ku fu wu ming
  fang fa yi :select value from v$parameter where name = 'service_name';
  fang fa er :show parameter service_name
  fang fa san : zai shen shu wen jian zhong cha xun 。 shu ju ku fu wu ming yu wang luo lian jie
  cong oracle8i kai ru de oracle wang luo zu jian , shu ju ku yu ke hu duan de lian jie zhu ji chuan shi yong shu ju ku fu wu ming 。 zhi qian yong de shi ORACLE_SID, ji shu ju ku shi li ming 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
yi 、 shu ju ku ming shen me shi shu ju ku ming shu ju ku ming jiu shi yi ge shu ju ku de biao shi , jiu xiang ren de shen fen zheng hao yi yang 。 ta yong shen shu DB_NAME biao shi , ru guo yi tai ji qi shang zhuang le duo quan shu ju ku , na me mei yi ge shu ju ku dou you yi ge shu ju ku ming 。 zai shu ju ku an zhuang huo chuang jian wan cheng zhi hou , shen shu DB_NAME bei xie ru shen shu wen jian zhi zhong 。 ge shi ru xia : DB_NAME=myorcl ... zai chuang jian shu ju ku shi jiu ying kao lv hao shu ju ku ming , bing qie zai chuang jian wan shu ju ku zhi hou , shu ju ku ming bu yi xiu gai , ji shi yao xiu gai ye hui hen ma fan 。 yin wei , shu ju ku ming huan bei xie ru kong zhi wen jian zhong , kong zhi wen jian shi yi er jin zhi xing shi cun chu de , yong hu wu fa xiu gai kong zhi wen jian de nei rong 。 jia she yong hu xiu gai le shen shu wen jian zhong de shu ju ku ming , ji xiu gai DB_NAME de zhi 。 dan shi zai Oracle qi dong shi , you yu shen shu wen jian zhong de DB_NAME yu kong zhi wen jian zhong de shu ju ku ming bu yi zhi , dao zhi shu ju ku qi dong shi bai , jiang fan hui ORA-01103 cuo wu 。 shu ju ku ming de zuo yong shu ju ku ming shi zai an zhuang shu ju ku 、 chuang jian xin de shu ju ku 、 chuang jian shu ju ku kong zhi wen jian 、 xiu gai shu ju jie gou 、 bei fen yu hui fu shu ju ku shi dou xu yao shi yong dao de 。 you hen duo Oracle an zhuang wen jian mu lu shi yu shu ju ku ming xiang guan de , ru : winnt: d:\oracle\product\10.1.0\oradata\DB_NAME\... Unix: /home/app/oracle/product/10.1.0/oradata/DB_NAME/... pfile: winnt: d:\oracle\product\10.1.0\admin\DB_NAME\pfile\ini.ora Unix: /home/app/oracle/product/10.1.0/admin/DB_NAME/pfile/init$ORACLE_SID.ora gen zong wen jian mu lu : winnt: /home/app/oracle/product/10.1.0/admin/DB_NAME/bdump/... ling wai , zai chuang jian shu ju shi ,careate database ming ling zhong de shu ju ku ming ye yao yu shen shu wen jian zhong DB_NAME shen shu de zhi yi zhi , fou ze jiang chan sheng cuo wu 。 tong yang , xiu gai shu ju ku jie gou de yu ju alter database, dang ran ye yao zhi chu yao xiu gai de shu ju ku de ming cheng 。 ru guo kong zhi wen jian sun huai huo diu shi , shu ju ku jiang bu neng jia zai , zhe shi yao chong xin chuang jian kong zhi wen jian , fang fa shi yi nomount fang shi qi dong shi li , ran hou yi create controlfile ming ling chuang jian kong zhi wen jian , dang ran zhe ge ming ling zhong ye shi zhi zhi DB_NAME。 huan you zai bei fen huo hui fu shu ju ku shi , dou xu yao yong dao shu ju ku ming 。 zong zhi , shu ju ku ming hen chong yao , yao zhun que li jie ta de zuo yong 。 cha xun dang qian shu ju ming fang fa yi :select name from v$database; fang fa er :show parameter db fang fa san : cha kan shen shu wen jian 。 xiu gai shu ju ku ming qian mian jian yi : ying zai chuang jian shu ju ku shi jiu que ding hao shu ju ku ming , shu ju ku ming bu ying zuo xiu gai , yin wei xiu gai shu ju ku ming shi yi jian bi jiao fu duo de shi qing 。 na me xian zai jiu lai shuo ming yi xia , ru he zai yi chuang jian shu ju zhi hou , xiu gai shu ju ku ming 。 bu zhou ru xia : 1. guan bi shu ju ku 。 2. xiu gai shu ju ku shen shu wen jian zhong de DB_NAME shen shu de zhi wei xin de shu ju ku ming 。 3. yi NOMOUNT fang shi qi dong shi li , xiu jian kong zhi wen jian ( you guan chuang jian kong zhi wen jian de ming ling yu fa , qing shen kao oracle wen dang ) er 、 shu ju ku shi li ming shen me shi shu ju ku shi li ming ? shu ju ku shi li ming shi yong yu he cao zuo xi tong jin xing lian xi de biao shi , jiu shi shuo shu ju ku he cao zuo xi tong zhi jian de jiao hu yong de shi shu ju ku shi li ming 。 shi li ming ye bei xie ru shen shu wen jian zhong , gai shen shu wei instance_name, zai winnt ping tai zhong , shi li ming tong shi ye bei xie ru zhu ce biao 。 shu ju ku ming he shi li ming ke yi xiang tong ye ke yi bu tong 。 zai yi ban qing kuang xia , shu ju ku ming he shi li ming shi yi dui yi de guan xi , dan ru guo zai oracle bing xing fu wu qi jia gou ( ji oracle shi shi ying yong ji qun ) zhong , shu ju ku ming he shi li ming shi yi dui duo de guan xi 。 zhe yi dian zai di yi pian zhong yi you tu li shuo ming 。 cha xun dang qian shu ju ku shi li ming fang fa yi :select instance_name from v$instance; fang fa er :show parameter instance fang fa san : zai shen shu wen jian zhong cha xun 。 shu ju ku shi li ming yu ORACLE_SID sui ran liang zhe dou biao shi oracle shi li , dan liang zhe shi you qu bie de 。instance_name shi oracle shu ju ku shen shu 。 er ORACLE_SID shi cao zuo xi tong de huan jing bian liang 。ORACLD_SID yong yu yu cao zuo xi tong jiao hu , ye jiu shi shuo , cong cao zuo xi tong de jiao du fang wen shi li ming , bi xu tong guo ORACLE_SID。 zai winnt bu tai ,ORACLE_SID huan xu cun zai yu zhu ce biao zhong 。 qie ORACLE_SID bi xu yu instance_name de zhi yi zhi , fou ze , ni jiang hui shou dao yi ge cuo wu , zai unix ping tai , shi “ORACLE not available”, zai winnt ping tai , shi “TNS: xie yi shi pei qi cuo wu ”。 shu ju ku shi li ming yu wang luo lian jie shu ju ku shi li ming chu le yu cao zuo xi tong jiao hu wai , huan yong yu wang luo lian jie de oracle fu wu qi biao shi 。 dang ni pei zhi oracle zhu ji lian jie chuan de shi hou , jiu xu yao zhi ding shi li ming 。 dang ran 8i yi hou ban ben de wang luo zu jian yao qiu shi yong de shi fu wu ming SERVICE_NAME。 zhe ge gai nian jie xia lai shuo ming 。 san 、 shu ju ku yu ming shen me shi shu ju ku yu ming ? zai fen bu gong shu ju ku xi tong zhong , bu tong ban ben de shu ju ku fu wu qi zhi jian , bu lun yun xing de cao zuo xi tong shi unix huo shi windows, ge fu wu qi zhi jian dou ke yi tong guo shu ju ku lian lu jin xing yuan cheng fu zhi , shu ju ku yu ming zhu yao yong yu oracle fen bu shi huan jing zhong de fu zhi 。 ju li shuo ming ru : quan guo jiao tong yun zheng xi tong de fen bu shi shu ju ku , qi zhong : fu jian jie dian : fj.jtyz fu jian xia men jie dian : xm.fj.jtyz jiang xi : jx.jtyz jiang xi shang rao :sr.jx.jtyz zhe jiu shi shu ju ku yu ming 。 shu ju ku yu ming zai cun zai yu shen shu wen jian zhong , ta de shen shu shi db_domain. cha xun shu ju ku yu ming fang fa yi :select value from v$parameter where name = 'db_domain'; fang fa er :show parameter domain fang fa san : zai shen shu wen jian zhong cha xun 。 quan ju shu ju ku ming quan ju shu ju ku ming = shu ju ku ming + shu ju ku yu ming , ru qian shu fu jian jie dian de quan ju shu ju ku ming shi :oradb.fj.jtyz si 、 shu ju ku fu wu ming shen me shi shu ju ku fu wu ming ? cong oracle9i ban ben kai shi , yin ru le yi ge xin de shen shu , ji shu ju ku fu wu ming 。 shen shu ming shi SERVICE_NAME。 ru guo shu ju ku you yu ming , ze shu ju ku fu wu ming jiu shi quan ju shu ju ku ming ; fou ze , shu ju ku fu wu ming yu shu ju ku ming xiang tong 。 cha xun shu ju ku fu wu ming fang fa yi :select value from v$parameter where name = 'service_name'; fang fa er :show parameter service_name fang fa san : zai shen shu wen jian zhong cha xun 。 shu ju ku fu wu ming yu wang luo lian jie cong oracle8i kai ru de oracle wang luo zu jian , shu ju ku yu ke hu duan de lian jie zhu ji chuan shi yong shu ju ku fu wu ming 。 zhi qian yong de shi ORACLE_SID, ji shu ju ku shi li ming 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
我们约会吧
漂亮白皙的模特
好纯好美的女生
靓丽的网络美女
痞子的甘南日记
疑是银河落九天
雪域坝上四——纯美色
冬日恋歌——西城杨柳弄轻柔
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有