📄 00000011.htm

📁 一份很好的linux入门资料
💻 HTM
📖 第 1 页 / 共 2 页
字号:
12 下一页
<HTML><HEAD>  <TITLE>BBS水木清华站∶精华区</TITLE></HEAD><BODY><CENTER><H1>BBS水木清华站∶精华区</H1></CENTER>发信人:&nbsp;midi&nbsp;(迷笛),&nbsp;信区:&nbsp;Linux&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>标&nbsp;&nbsp;题:&nbsp;Re:&nbsp;Oracle&nbsp;Net8&nbsp;网络配置和联接&nbsp;<BR>发信站:&nbsp;BBS&nbsp;水木清华站&nbsp;(Mon&nbsp;Feb&nbsp;14&nbsp;01:12:58&nbsp;2000)&nbsp;<BR>&nbsp;<BR>Oracle&nbsp;8i不用在Listener中指定SID的Binding，因为它会自己动态绑定。&nbsp;<BR>&nbsp;<BR>如果希望使用O8i的功能--JServ--如果不用它，还不如直接用Oracle&nbsp;8.0.5:-)&nbsp;<BR>那么还得在Listener里配置IIOP的服务。确省口netasst可能不会指出，但&nbsp;<BR>使用者应该知道：2481，因为许多例子用到它。如果要用JServ，即便你&nbsp;<BR>把你的库配置程Dedicate型的，Oracle仍然会用MTS方式给JServ提供服务。&nbsp;<BR>我在Redhat6.1上把库配置成MTS方式时，经常导致Lisenter和SID不能绑定，&nbsp;<BR>原因不详。因此还是建议采用Dedicate型，但要在initSID.ora中检查是否&nbsp;<BR>有MTS&nbsp;Dispatcher&nbsp;Entry给IIOP服务。&nbsp;<BR>&nbsp;<BR>如果采用Dedicate方式，在bdump目录下的alert_SID.log里会大量重复产生&nbsp;<BR>错误信息：&nbsp;<BR>Load&nbsp;Indicator&nbsp;not&nbsp;supported&nbsp;by&nbsp;OS&nbsp;!&nbsp;<BR>Sun&nbsp;Feb&nbsp;13&nbsp;12:06:08&nbsp;2000&nbsp;<BR>Load&nbsp;Indicator&nbsp;not&nbsp;supported&nbsp;by&nbsp;OS&nbsp;!&nbsp;<BR>Sun&nbsp;Feb&nbsp;13&nbsp;12:06:42&nbsp;2000&nbsp;<BR>Load&nbsp;Indicator&nbsp;not&nbsp;supported&nbsp;by&nbsp;OS&nbsp;!&nbsp;<BR>Sun&nbsp;Feb&nbsp;13&nbsp;12:07:15&nbsp;2000&nbsp;<BR>Load&nbsp;Indicator&nbsp;not&nbsp;supported&nbsp;by&nbsp;OS&nbsp;!&nbsp;<BR>Sun&nbsp;Feb&nbsp;13&nbsp;12:07:49&nbsp;2000&nbsp;<BR>此属正常。&nbsp;<BR>&nbsp;<BR>tnsping可以检验Listener是否安装配置正确。但如果要检查JServ，还是&nbsp;<BR>用sess_sh比较好&nbsp;<BR>sess_sh&nbsp;-u&nbsp;scott/tiger&nbsp;-s&nbsp;sess_iiop://localhost:2481:SID&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>【&nbsp;在&nbsp;zixia&nbsp;(親親青青河邊草)&nbsp;的大作中提到:&nbsp;】&nbsp;<BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Oracle&nbsp;Net8&nbsp;网络配置和联接&nbsp;</I><BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;１）服务器端配置Listener：&nbsp;</I><BR>∶<I>&nbsp;添加Listeners&nbsp;,&nbsp;设置选择&nbsp;DataBase&nbsp;Name方式，填写2个参数&nbsp;{&nbsp;HomeDir&nbsp;=&nbsp;/ora/&nbsp;,&nbsp;&nbsp;</I><BR>∶<I>&nbsp;SID&nbsp;</I><BR>∶<I>&nbsp;２）启动Net8服务lsnrctl&nbsp;start&nbsp;</I><BR>∶<I>&nbsp;３）停止Net8服务lsnrctl&nbsp;stop&nbsp;</I><BR>∶<I>&nbsp;４）参数文件摘要&nbsp;</I><BR>∶<I>&nbsp;５）客户端配置：添加&nbsp;Net&nbsp;Service&nbsp;Name&nbsp;，同Windows客户端一样格式&nbsp;</I><BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;１）服务器端配置Listener：&nbsp;</I><BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;执行/ora/bin/netasst&nbsp;</I><BR>∶<I>&nbsp;填写描述-&gt;首选Oracle服务：&nbsp;</I><BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;。PROTOCOL&nbsp;=&nbsp;TCP&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;。HOST&nbsp;=&nbsp;172.17.2.22&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;。PORT&nbsp;=&nbsp;1521&nbsp;</I><BR>∶<I>&nbsp;&nbsp;查看生成的&nbsp;Net8&nbsp;Server配置文件：listener.ora&nbsp;</I><BR>∶<I>&nbsp;[oracle@lin&nbsp;admin]$&nbsp;more&nbsp;listener.ora&nbsp;</I><BR>∶<I>&nbsp;#&nbsp;LISTENER.ORA&nbsp;Configuration&nbsp;File:/ora/network/admin/listener.ora&nbsp;</I><BR>∶<I>&nbsp;#&nbsp;Generated&nbsp;by&nbsp;Oracle&nbsp;Net8&nbsp;Assistant&nbsp;</I><BR>∶<I>&nbsp;LISTENER&nbsp;=&nbsp;</I><BR>∶<I>&nbsp;(DESCRIPTION&nbsp;=&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;(ADDRESS&nbsp;=&nbsp;(PROTOCOL&nbsp;=&nbsp;TCP)(HOST&nbsp;=&nbsp;172.17.2.22)(PORT&nbsp;=&nbsp;1521))&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;(PROTOCOL_STACK&nbsp;=&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(PRESENTATION&nbsp;=&nbsp;TTC)&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SESSION&nbsp;=&nbsp;NS)&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;)&nbsp;</I><BR>∶<I>&nbsp;&nbsp;)&nbsp;</I><BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;SID_LIST_LISTENER&nbsp;=&nbsp;</I><BR>∶<I>&nbsp;&nbsp;(SID_LIST&nbsp;=&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;(SID_DESC&nbsp;=&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;&nbsp;(ORACLE_HOME&nbsp;=&nbsp;/ora)&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;&nbsp;(SID_NAME&nbsp;=&nbsp;ora8)&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;)&nbsp;</I><BR>∶<I>&nbsp;)&nbsp;</I><BR>∶<I>&nbsp;###&nbsp;如果指明监听服务的&quot;全局名&quot;，则有类似这一行：(GLOBAL_DBNAME&nbsp;=&nbsp;ora8)&nbsp;</I><BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;２）启动Net8服务lsnrctl&nbsp;start&nbsp;</I><BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;首先你可以这样取得帮助：&nbsp;</I><BR>∶<I>&nbsp;[oracle@lin&nbsp;/ora]$&nbsp;lsnrctl&nbsp;</I><BR>∶<I>&nbsp;LSNRCTL&gt;&nbsp;help&nbsp;</I><BR>∶<I>&nbsp;然后开始启动：start&nbsp;</I><BR>∶<I>&nbsp;[oracle@lin&nbsp;bin]$&nbsp;lsnrctl&nbsp;start&nbsp;</I><BR>∶<I>&nbsp;联接时，机器会逐步告诉你正在启动…,正在联接…,已经联接的状态,最后他说成功啦!&nbsp;&nbsp;</I><BR>∶<I>&nbsp;下?&nbsp;</I><BR>∶<I>&nbsp;LSNRCTL&nbsp;for&nbsp;Linux:&nbsp;Version&nbsp;8.1.5.0.0&nbsp;-&nbsp;Production&nbsp;on&nbsp;19-NOV-99&nbsp;22:02:54&nbsp;</I><BR>∶<I>&nbsp;(c)&nbsp;Copyright&nbsp;1998&nbsp;Oracle&nbsp;Corporation.&nbsp;All&nbsp;rights&nbsp;reserved.&nbsp;</I><BR>∶<I>&nbsp;Starting&nbsp;/ora/bin/tnslsnr:&nbsp;please&nbsp;wait...&nbsp;</I><BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;TNSLSNR&nbsp;for&nbsp;Linux:&nbsp;Version&nbsp;8.1.5.0.0&nbsp;-&nbsp;Production&nbsp;</I><BR>∶<I>&nbsp;System&nbsp;parameter&nbsp;file&nbsp;is&nbsp;/ora/network/admin/listener.ora&nbsp;</I><BR>∶<I>&nbsp;Log&nbsp;messages&nbsp;written&nbsp;to&nbsp;/ora/network/log/listener.log&nbsp;</I><BR>∶<I>&nbsp;Listening&nbsp;on:&nbsp;(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521&nbsp;</I><BR>∶<I>&nbsp;))&nbsp;</I><BR>∶<I>&nbsp;(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))&nbsp;</I><BR>∶<I>&nbsp;&nbsp;</I><BR>∶<I>&nbsp;Connecting&nbsp;to&nbsp;(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521&nbsp;</I><BR>∶<I>&nbsp;))&nbsp;</I><BR>∶<I>&nbsp;(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))&nbsp;</I><BR>∶<I>&nbsp;STATUS&nbsp;of&nbsp;the&nbsp;LISTENER&nbsp;</I><BR>∶<I>&nbsp;------------------------&nbsp;</I><BR>∶<I>&nbsp;Alias&nbsp;LISTENER&nbsp;</I><BR>∶<I>&nbsp;Version&nbsp;TNSLSNR&nbsp;for&nbsp;Linux:&nbsp;Version&nbsp;8.1.5.0.0&nbsp;-&nbsp;Production&nbsp;</I><BR>∶<I>&nbsp;Start&nbsp;Date&nbsp;19-NOV-99&nbsp;22:02:54&nbsp;</I><BR>∶<I>&nbsp;Uptime&nbsp;0&nbsp;days&nbsp;0&nbsp;hr.&nbsp;0&nbsp;min.&nbsp;0&nbsp;sec&nbsp;</I><BR>∶<I>&nbsp;Trace&nbsp;Level&nbsp;off&nbsp;</I><BR>∶<I>&nbsp;Security&nbsp;OFF&nbsp;</I><BR>∶<I>&nbsp;SNMP&nbsp;OFF&nbsp;</I><BR>∶<I>&nbsp;Listener&nbsp;Parameter&nbsp;File&nbsp;/ora/network/admin/listener.ora&nbsp;</I><BR>∶<I>&nbsp;Listener&nbsp;Log&nbsp;File&nbsp;/ora/network/log/listener.log&nbsp;</I><BR>∶<I>&nbsp;Services&nbsp;Summary...&nbsp;</I><BR>∶<I>&nbsp;ora8&nbsp;has&nbsp;1&nbsp;service&nbsp;handler(s)&nbsp;</I><BR>
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -