| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> oracle >> Oracle listener jing tai zhu ce he dong tai zhu ce zong jie
 

Oracle listener jing tai zhu ce he dong tai zhu ce zong jie

2008-08-14 23:14:21 编辑來源:互联网 评论
 
本文为【Oracle listener静态注册和动态注册总结】的拼音翻译版
  yi 、 shen me shi zhu ce ?
  zhu ce jiu shi jiang shu ju ku zuo wei yi ge fu wu zhu ce dao jian ting cheng xu 。 ke hu duan bu xu yao zhi dao shu ju ku ming he shi li ming , zhi xu yao zhi dao gai shu ju ku dui wai ti gong de fu wu ming jiu ke yi shen qing lian jie dao shu ju ku 。 zhe ge fu wu ming ke neng yu shi li ming yi yang , ye you ke neng bu yi yang 。
  zai shu ju ku fu wu qi qi dong guo cheng zhong , shu ju ku fu wu qi hui xiang jian ting cheng xu zhu ce xiang ying de fu wu ( wu lun he shi qi dong yi ge shu ju ku , mo ren di dou you liang tiao xin xi zhu ce dao jian ting qi zhong : shu ju ku fu wu qi dui ying de shi li he fu wu 。)
  xiang dang yu shi zhe yang : zai shu ju ku fu wu qi he ke hu duan zhi jian you yi jian ting cheng xu (Listener), zai jian ting cheng xu zhong , hui ji lu xiang ying shu ju ku dui ying de fu wu ming ( yi ge shu ju ku ke neng dui ying you duo ge fu wu ming ), dang ke hu duan xu yao lian jie shu ju ku shi , zhi xu yao ti gong fu wu ming , jiu ke yi jian li ke hu duan he fu wu qi zhi jian de lian jie 。
  er 、 jing tai zhu ce
  jing tai zhu ce jiu shi shi li qi dong shi du qu listener.ora wen jian de pei zhi , jiang shi li he fu wu zhu ce dao jian ting cheng xu 。 wu lun he shi qi dong yi ge shu ju ku , mo ren di dou you liang tiao xin xi zhu ce dao jian ting qi zhong : shu ju ku fu wu qi dui ying de shi li he fu wu 。
  jing tai zhu ce shi ,listener.ora zhong de GLOBAL_DBNAME xiang wai ti gong fu wu ming ,listener.ora zhong de SID_NAME ti gong zhu ce de shi li ming 。
  cai qu jing tai zhu ce fang fa shi ,listener.ora zhong de nei rong ru xia :
  SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
  (PROGRAM = extproc)
  )
  (SID_DESC =
  (GLOBAL_DBNAME =orcl)
  (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
  (SID_NAME =orcl)
  )
  (SID_DESC =
  (GLOBAL_DBNAME =orcl1)
  (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
  (SID_NAME =orcl)
  )
  )
  gai wen jian biao ming shu ju ku shi dan shi li de , shi li ming wei orcl, xiang wai ti gong le liang ge fu wu :orcl he orcl1
  san 、 dong tai zhu ce
  dong tai zhu ce shi zai instance qi dong de shi hou PMON jin cheng gen ju init.ora zhong de instance_name,service_names liang ge shen shu jiang shi li he fu wu dong tai zhu ce dao listener zhong 。
  shou xian yao zai init.ora zhong zhi ding instance_name,service_names liang ge shen shu de zhi 。 zai sqlplus xia tong guo show parameter service_names he show parameter instance_name ke yi cha kan zhe liang ge shen shu de zhi 。
  zhu ce dao jian ting qi zhong de shi li zhi cong init.ora wen jian zhong de instance_name shen shu qu de 。 ru guo gai shen shu mei you she ding zhi , na me ta jiang qu init.ora wen jian zhong de db_name de zhi 。
  zhu ce dao jian ting qi zhong de fu wu zhi cong init.ora wen jian zhong de shen shu service_names qu de 。 ru guo gai shen shu mei you she ding zhi , shu ju ku jiang pin jie init.ora wen jian zhong de db_name he db_domain de zhi lai zhu ce zi ji 。 ru guo xuan ze ti gong service_names zhi , nin ke yi shi yong wan quan xian ding de ming cheng ( bi ru orcl.oracle.com) huo suo xie de ming cheng ( bi ru orcl)。 ru guo xuan ze suo xie de ming cheng bing she zhi le db_domain shen shu , zhu ce dao jian ting qi zhong de fu wu jiang shi service_name zhi he db_domain zhi de pin jie 。 li ru xia mian de she zhi jiang dao zhi fu wu orcl.oracle.com bei zhu ce dao jian ting qi zhong :
  db_domain=oracle.com
  service_names=orcl ;
  cai qu dong tai zhu ce fang fa shi ,listener.ora zhong de nei rong ru xia :
  SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
  (PROGRAM = extproc)
  )
  )
  ke xuan ze de shi , nin ke yi zai service_names shen shu zhong zhi ding duo ge fu wu zhi , zhi zhi jian yong dou hao ge kai , zhe dui yu gong xiang fu wu qi pei zhi shi hen you yong de 。
  dong tai zhu ce mo ren zhi zhu ce dao mo ren de jian ting qi shang ( ming cheng shi LISTENER、 duan kou shi 1521、 xie yi shi TCP), ru guo xu yao xiang fei mo ren jian ting zhu ce , ze xu yao pei zhi local_listener shen shu !
  ru guo mei you xian shi she zhi service_names he instance_name de zhi , na me jin dang shu ju ku zai jian ting qi yun xing zhi hou qi dong shi , dong tai zhu ce cai hui fa sheng ; zai zhe zhong qing kuang xia , ru guo jian ting qi hou lai fa sheng le chong qi , dong tai zhu ce xin xi jiang hui diu shi 。 xian ran , zui hao zai suo you de shu ju ku qi dong zhi qian xian qi dong jian ting qi , zhe yang jiu hui bi mian mei you xian shi she zhi service_names he instance_name de zhi shi , ruo chong qi jian ting qi dai lai de dong tai zhu ce xin xi diu shi de qing kuang 。
  wei chu shi hua shen shu service_names he instance_name she zhi xian shi de zhi shi ge zhi de ke qu de fang fa he jian yi 。 yin wei ru guo jian ting qi zai shu ju ku yun xing guo cheng zhong yao chong xin qi dong , jin dang ni zai init.ora wen jian zhong xian shi di she zhi le service_names he instance_name de zhi shi , mei ge shu ju ku de PMON jin cheng cai hui zai hen duan de shi jian zhi nei wan cheng dong tai zhu ce 。
  si 、 cha xun mou fu wu shi jing tai zhu ce huan shi dong tai zhu ce
  ke yi shi yong ming ling lsnrctl status lai cha kan mou fu wu shi jing tai zhu ce huan shi dong tai zhu ce 。
  shi li zhuang tai wei UNKNOWN zhi shi biao ming ci fu wu shi jing tai zhu ce de she zhi 。 zhe shi jian ting qi yong lai biao ming ta bu zhi dao guan yu gai shi li de ren he xin xi , zhi you dang ke hu fa chu lian jie qing qiu shi , ta cai jian cha gai shi li shi fou cun zai 。
  dong tai zhu ce de shu ju ku tong guo zhuang tai xin xi zhong de zhuang tai READY huo zhuang tai BLOCKED( dui yu yi ge bei yong shu ju ku ) lai zhi ming 。 bu guan guan bi he shi shu ju ku , dong tai zhu ce de shu ju ku dou hui dong tai di cong jian ting qi zhu xiao , er yu zhi xiang guan de xin xi jiang cong zhuang tai lie biao zhong xiao shi 。 zhe yang , bu guan shu ju ku shi zai yun xing huan shi yi jing guan bi , jian ting qi zong shi zhi dao ta de zhuang tai 。 gai xin xi jiang bei yong yu lian jie qing qiu de hui tui (fallback) he fu zai ping heng 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

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

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

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

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

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

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

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

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

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

 
 
yi 、 shen me shi zhu ce ? zhu ce jiu shi jiang shu ju ku zuo wei yi ge fu wu zhu ce dao jian ting cheng xu 。 ke hu duan bu xu yao zhi dao shu ju ku ming he shi li ming , zhi xu yao zhi dao gai shu ju ku dui wai ti gong de fu wu ming jiu ke yi shen qing lian jie dao shu ju ku 。 zhe ge fu wu ming ke neng yu shi li ming yi yang , ye you ke neng bu yi yang 。 zai shu ju ku fu wu qi qi dong guo cheng zhong , shu ju ku fu wu qi hui xiang jian ting cheng xu zhu ce xiang ying de fu wu ( wu lun he shi qi dong yi ge shu ju ku , mo ren di dou you liang tiao xin xi zhu ce dao jian ting qi zhong : shu ju ku fu wu qi dui ying de shi li he fu wu 。) xiang dang yu shi zhe yang : zai shu ju ku fu wu qi he ke hu duan zhi jian you yi jian ting cheng xu (Listener), zai jian ting cheng xu zhong , hui ji lu xiang ying shu ju ku dui ying de fu wu ming ( yi ge shu ju ku ke neng dui ying you duo ge fu wu ming ), dang ke hu duan xu yao lian jie shu ju ku shi , zhi xu yao ti gong fu wu ming , jiu ke yi jian li ke hu duan he fu wu qi zhi jian de lian jie 。 er 、 jing tai zhu ce jing tai zhu ce jiu shi shi li qi dong shi du qu listener.ora wen jian de pei zhi , jiang shi li he fu wu zhu ce dao jian ting cheng xu 。 wu lun he shi qi dong yi ge shu ju ku , mo ren di dou you liang tiao xin xi zhu ce dao jian ting qi zhong : shu ju ku fu wu qi dui ying de shi li he fu wu 。 jing tai zhu ce shi ,listener.ora zhong de GLOBAL_DBNAME xiang wai ti gong fu wu ming ,listener.ora zhong de SID_NAME ti gong zhu ce de shi li ming 。 cai qu jing tai zhu ce fang fa shi ,listener.ora zhong de nei rong ru xia : SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME =orcl) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (SID_NAME =orcl) ) (SID_DESC = (GLOBAL_DBNAME =orcl1) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (SID_NAME =orcl) ) ) gai wen jian biao ming shu ju ku shi dan shi li de , shi li ming wei orcl, xiang wai ti gong le liang ge fu wu :orcl he orcl1 san 、 dong tai zhu ce dong tai zhu ce shi zai instance qi dong de shi hou PMON jin cheng gen ju init.ora zhong de instance_name,service_names liang ge shen shu jiang shi li he fu wu dong tai zhu ce dao listener zhong 。 shou xian yao zai init.ora zhong zhi ding instance_name,service_names liang ge shen shu de zhi 。 zai sqlplus xia tong guo show parameter service_names he show parameter instance_name ke yi cha kan zhe liang ge shen shu de zhi 。 zhu ce dao jian ting qi zhong de shi li zhi cong init.ora wen jian zhong de instance_name shen shu qu de 。 ru guo gai shen shu mei you she ding zhi , na me ta jiang qu init.ora wen jian zhong de db_name de zhi 。 zhu ce dao jian ting qi zhong de fu wu zhi cong init.ora wen jian zhong de shen shu service_names qu de 。 ru guo gai shen shu mei you she ding zhi , shu ju ku jiang pin jie init.ora wen jian zhong de db_name he db_domain de zhi lai zhu ce zi ji 。 ru guo xuan ze ti gong service_names zhi , nin ke yi shi yong wan quan xian ding de ming cheng ( bi ru orcl.oracle.com) huo suo xie de ming cheng ( bi ru orcl)。 ru guo xuan ze suo xie de ming cheng bing she zhi le db_domain shen shu , zhu ce dao jian ting qi zhong de fu wu jiang shi service_name zhi he db_domain zhi de pin jie 。 li ru xia mian de she zhi jiang dao zhi fu wu orcl.oracle.com bei zhu ce dao jian ting qi zhong : db_domain=oracle.com service_names=orcl ; cai qu dong tai zhu ce fang fa shi ,listener.ora zhong de nei rong ru xia : SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) ) ke xuan ze de shi , nin ke yi zai service_names shen shu zhong zhi ding duo ge fu wu zhi , zhi zhi jian yong dou hao ge kai , zhe dui yu gong xiang fu wu qi pei zhi shi hen you yong de 。 dong tai zhu ce mo ren zhi zhu ce dao mo ren de jian ting qi shang ( ming cheng shi LISTENER、 duan kou shi 1521、 xie yi shi TCP), ru guo xu yao xiang fei mo ren jian ting zhu ce , ze xu yao pei zhi local_listener shen shu ! ru guo mei you xian shi she zhi service_names he instance_name de zhi , na me jin dang shu ju ku zai jian ting qi yun xing zhi hou qi dong shi , dong tai zhu ce cai hui fa sheng ; zai zhe zhong qing kuang xia , ru guo jian ting qi hou lai fa sheng le chong qi , dong tai zhu ce xin xi jiang hui diu shi 。 xian ran , zui hao zai suo you de shu ju ku qi dong zhi qian xian qi dong jian ting qi , zhe yang jiu hui bi mian mei you xian shi she zhi service_names he instance_name de zhi shi , ruo chong qi jian ting qi dai lai de dong tai zhu ce xin xi diu shi de qing kuang 。 wei chu shi hua shen shu service_names he instance_name she zhi xian shi de zhi shi ge zhi de ke qu de fang fa he jian yi 。 yin wei ru guo jian ting qi zai shu ju ku yun xing guo cheng zhong yao chong xin qi dong , jin dang ni zai init.ora wen jian zhong xian shi di she zhi le service_names he instance_name de zhi shi , mei ge shu ju ku de PMON jin cheng cai hui zai hen duan de shi jian zhi nei wan cheng dong tai zhu ce 。 si 、 cha xun mou fu wu shi jing tai zhu ce huan shi dong tai zhu ce ke yi shi yong ming ling lsnrctl status lai cha kan mou fu wu shi jing tai zhu ce huan shi dong tai zhu ce 。 shi li zhuang tai wei UNKNOWN zhi shi biao ming ci fu wu shi jing tai zhu ce de she zhi 。 zhe shi jian ting qi yong lai biao ming ta bu zhi dao guan yu gai shi li de ren he xin xi , zhi you dang ke hu fa chu lian jie qing qiu shi , ta cai jian cha gai shi li shi fou cun zai 。 dong tai zhu ce de shu ju ku tong guo zhuang tai xin xi zhong de zhuang tai READY huo zhuang tai BLOCKED( dui yu yi ge bei yong shu ju ku ) lai zhi ming 。 bu guan guan bi he shi shu ju ku , dong tai zhu ce de shu ju ku dou hui dong tai di cong jian ting qi zhu xiao , er yu zhi xiang guan de xin xi jiang cong zhuang tai lie biao zhong xiao shi 。 zhe yang , bu guan shu ju ku shi zai yun xing huan shi yi jing guan bi , jian ting qi zong shi zhi dao ta de zhuang tai 。 gai xin xi jiang bei yong yu lian jie qing qiu de hui tui (fallback) he fu zai ping heng 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
温柔美女韩雪写真
杨幂全新写真
网易红人PLMM草梅队长
河智苑Compagna09春装
看 这就是我的学校
惠山古迹区
雪后看花仙
元宵烟火
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有