00000011.htm

一份很好的linux入门资料

∶<I>&nbsp;The&nbsp;command&nbsp;completed&nbsp;successfully&nbsp;</I><BR>
∶<I>&nbsp;以上提示说，1个服务被处理，命令成功完成。&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;３）停止Net8服务lsnrctl&nbsp;stop&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;最简单的方法是&nbsp;[oracle@lin&nbsp;/ora]$&nbsp;lsnrctl&nbsp;stop&nbsp;</I><BR>
∶<I>&nbsp;有时侯，进程出了差错，tnslsnr没有响应，像WindowsNT常犯的毛病一&nbsp;样，&nbsp;</I><BR>
∶<I>&nbsp;这里有一个强硬的手段：先找出它的进程号，然后&nbsp;kill掉！&nbsp;</I><BR>
∶<I>&nbsp;[oracle@lin&nbsp;/ora]$&nbsp;ps&nbsp;-ef|grep&nbsp;tns&nbsp;</I><BR>
∶<I>&nbsp;oracle&nbsp;1331&nbsp;1&nbsp;0&nbsp;15:51&nbsp;?&nbsp;00:00:00&nbsp;/ora/bin/tnslsnr&nbsp;LISTENER&nbsp;-inher&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;或使用更少的参数也能找到tnslsnr:&nbsp;</I><BR>
∶<I>&nbsp;[oracle@lin&nbsp;/ora]$&nbsp;ps&nbsp;-e&nbsp;</I><BR>
∶<I>&nbsp;PID&nbsp;TTY&nbsp;TIME&nbsp;CMD&nbsp;</I><BR>
∶<I>&nbsp;1331&nbsp;?&nbsp;00:00:00&nbsp;tnslsnr&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;现在杀死PID&nbsp;=&nbsp;1331的进程：&nbsp;</I><BR>
∶<I>&nbsp;[oracle@lin&nbsp;/ora]$&nbsp;kill&nbsp;1331&nbsp;</I><BR>
∶<I>&nbsp;LSNRCTL象&nbsp;SVRMGRL一样，是一个服务器管理程序，有不少参数，或者说是&nbsp;子程序，带星&nbsp;</I><BR>
∶<I>&nbsp;号&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;[oracle@lin&nbsp;bin]$&nbsp;lsnrctl&nbsp;stop&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:50&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;&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;The&nbsp;command&nbsp;completed&nbsp;successfully&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;Listeners&nbsp;=DataBase&nbsp;Name&nbsp;=&nbsp;Global&nbsp;DB&nbsp;Name&nbsp;=ora8,&nbsp;HomeDir&nbsp;=&nbsp;/ora/&nbsp;,SID&nbsp;=ora8&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;[oracle@lin&nbsp;oracle]$&nbsp;cd&nbsp;/ora/net*/ad*&nbsp;</I><BR>
∶<I>&nbsp;[oracle@lin&nbsp;admin]$&nbsp;ls&nbsp;</I><BR>
∶<I>&nbsp;listener.ora&nbsp;namesini.sql&nbsp;samples&nbsp;sqlnet.ora&nbsp;</I><BR>
∶<I>&nbsp;namesdrp.sql&nbsp;namesupg.sql&nbsp;sqlnet.fdf&nbsp;tnsnames.ora&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;下面是在&nbsp;Windwos&nbsp;NT/98&nbsp;上远程控制&nbsp;TNSLSNR&nbsp;的情形(图略)。&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;４）参数文件摘要&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;[oracle@lin&nbsp;admin]$&nbsp;more&nbsp;/u01/app/oracle/admin/ora8/pfile/initora8.ora&nbsp;</I><BR>
∶<I>&nbsp;db_name&nbsp;=&nbsp;ora8&nbsp;</I><BR>
∶<I>&nbsp;instance_name&nbsp;=&nbsp;ora8&nbsp;##&nbsp;&quot;事例名&quot;是关键字&nbsp;</I><BR>
∶<I>&nbsp;service_names&nbsp;=&nbsp;ora8&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;control_files&nbsp;=&nbsp;(&quot;/u01/app/oracle/oradata/ora8/control01.ctl&quot;,&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;&quot;/u01/app/oracle/&nbsp;</I><BR>
∶<I>&nbsp;db_block_buffers&nbsp;=&nbsp;8192&nbsp;</I><BR>
∶<I>&nbsp;shared_pool_size&nbsp;=&nbsp;4194304&nbsp;</I><BR>
∶<I>&nbsp;log_checkpoint_interval&nbsp;=&nbsp;10000&nbsp;</I><BR>
∶<I>&nbsp;log_checkpoint_timeout&nbsp;=&nbsp;1800&nbsp;</I><BR>
∶<I>&nbsp;processes&nbsp;=&nbsp;50&nbsp;</I><BR>
∶<I>&nbsp;log_buffer&nbsp;=&nbsp;163840&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;log_archive_start&nbsp;=&nbsp;true&nbsp;</I><BR>
∶<I>&nbsp;log_archive_dest_1&nbsp;=&nbsp;&quot;location=/u01/app/oracle/admin/ora8/arch&quot;&nbsp;</I><BR>
∶<I>&nbsp;log_archive_format&nbsp;=&nbsp;%t_%s.dbf&nbsp;</I><BR>
∶<I>&nbsp;#&nbsp;切记打开回滚段&nbsp;</I><BR>
∶<I>&nbsp;rollback_segments&nbsp;=&nbsp;(r01,&nbsp;r02,&nbsp;r03,&nbsp;r04)&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;#&nbsp;global_names&nbsp;=&nbsp;false&nbsp;###&nbsp;监听服务无需指明&quot;全局名&quot;&nbsp;</I><BR>
∶<I>&nbsp;#&nbsp;oracle_trace_enable&nbsp;=&nbsp;true&nbsp;</I><BR>
∶<I>&nbsp;#&nbsp;define&nbsp;directories&nbsp;to&nbsp;store&nbsp;trace&nbsp;and&nbsp;alert&nbsp;files&nbsp;</I><BR>
∶<I>&nbsp;background_dump_dest&nbsp;=&nbsp;/u01/app/oracle/admin/ora8/bdump&nbsp;</I><BR>
∶<I>&nbsp;core_dump_dest&nbsp;=&nbsp;/u01/app/oracle/admin/ora8/cdump&nbsp;</I><BR>
∶<I>&nbsp;user_dump_dest&nbsp;=&nbsp;/u01/app/oracle/admin/ora8/udump&nbsp;</I><BR>
∶<I>&nbsp;db_block_size&nbsp;=&nbsp;2048&nbsp;</I><BR>
∶<I>&nbsp;remote_login_passwordfile&nbsp;=&nbsp;exclusive&nbsp;</I><BR>
∶<I>&nbsp;os_authent_prefix&nbsp;=&nbsp;&quot;&quot;&nbsp;</I><BR>
∶<I>&nbsp;compatible&nbsp;=&nbsp;&quot;8.1.5&quot;&nbsp;##&nbsp;也可以兼容&nbsp;&quot;8.0.5&quot;&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;5)客户端网络配置&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;[oracle@lin&nbsp;admin]$&nbsp;more&nbsp;tnsnames.ora&nbsp;</I><BR>
∶<I>&nbsp;#&nbsp;TNSNAMES.ORA&nbsp;Configuration&nbsp;File:/ora/network/admin/tnsnames.ora&nbsp;</I><BR>
∶<I>&nbsp;#&nbsp;Generated&nbsp;by&nbsp;Oracle&nbsp;Net8&nbsp;Assistant&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;使用net8助理,结果自动保存在&nbsp;tnsnames.ora&nbsp;中，&nbsp;</I><BR>
∶<I>&nbsp;[oracle@lin&nbsp;/ora]$&nbsp;netass*&nbsp;添加Service:&nbsp;名称ora8，参数如下：&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;PROTOCOL=TCP&nbsp;HOST=172.17.2.22&nbsp;PORT=1521&nbsp;Oracle_SID=ora8&nbsp;</I><BR>
∶<I>&nbsp;机器解释成一个Oracle服务器地址包：&nbsp;</I><BR>
∶<I>&nbsp;(&nbsp;DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521))&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;&nbsp;(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))&nbsp;</I><BR>
∶<I>&nbsp;)&nbsp;</I><BR>
∶<I>&nbsp;一般说来，客户端采用Windows9x/NT/2000,因为这里软件开发容易，程序员和工具较为普&nbsp;</I><BR>
∶<I>&nbsp;及&nbsp;</I><BR>
∶<I>&nbsp;Windows&nbsp;客户端网络配置与此类似，其内容见于:&nbsp;\OraNT\net80\Admin\tnsname.ora&nbsp;</I><BR>
∶<I>&nbsp;ORA8.WORLD&nbsp;=&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;&nbsp;(DESCRIPTION&nbsp;=&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;&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;&nbsp;&nbsp;(CONNECT_DATA&nbsp;=&nbsp;(SID&nbsp;=&nbsp;ora8))&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;&nbsp;)&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;-------------------------------------------&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;在Windows2000(beta3专业版)中安装Personal&nbsp;Oeacle8.05时，监听服务安装失败，&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;只要理解以上oracle结构原理，可以手工复制Net8文件，修改配置：&nbsp;</I><BR>
∶<I>&nbsp;copy&nbsp;CD-ROM\.\NT_x86\server\lsnrctl80.exe,tnslsnr80.exe,tnsping80.exe&nbsp;&nbsp;&nbsp;</I><BR>
∶<I>&nbsp;C:\orant\&nbsp;</I><BR>
∶<I>&nbsp;copy&nbsp;CD-ROM\.\listener.ora&nbsp;&nbsp;C:\orant\net80\admin&nbsp;</I><BR>
∶<I>&nbsp;我不久前有这么一次经历。&nbsp;</I><BR>
∶<I>&nbsp;&nbsp;</I><BR>
&nbsp;<BR>
&nbsp;<BR>
--&nbsp;<BR>
※&nbsp;来源:·BBS&nbsp;水木清华站&nbsp;smth.org·[FROM:&nbsp;210.39.3.50]&nbsp;<BR>


<CENTER><H1>BBS水木清华站∶精华区</H1></CENTER>



</BODY>

</HTML>