📄 00000006.htm
字号:
<HTML><HEAD> <TITLE>BBS水木清华站∶精华区</TITLE></HEAD><BODY><CENTER><H1>BBS水木清华站∶精华区</H1></CENTER>发信人: zixia (親親青青河邊草), 信区: Linux <BR>标 题: Oracle Net8 网络配置和联接 <BR>发信站: BBS 水木清华站 (Sun Feb 13 13:39:37 2000) WWW-POST <BR> <BR>
<BR> Oracle Net8 网络配置和联接
<BR>
<BR>１）服务器端配置Listener：
<BR>添加Listeners , 设置选择 DataBase Name方式，填写2个参数 { HomeDir = /ora/ , <BR>SID
<BR>２）启动Net8服务lsnrctl start
<BR>３）停止Net8服务lsnrctl stop
<BR>４）参数文件摘要
<BR>５）客户端配置：添加 Net Service Name ，同Windows客户端一样格式
<BR>
<BR>１）服务器端配置Listener：
<BR>
<BR>执行/ora/bin/netasst
<BR>填写描述->首选Oracle服务：
<BR>
<BR> 。PROTOCOL = TCP
<BR> 。HOST = 172.17.2.22
<BR> 。PORT = 1521
<BR>
<BR>查看生成的 Net8 Server配置文件：listener.ora
<BR>[oracle@lin admin]$ more listener.ora
<BR># LISTENER.ORA Configuration File:/ora/network/admin/listener.ora
<BR># Generated by Oracle Net8 Assistant
<BR>LISTENER =
<BR>(DESCRIPTION =
<BR> (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.2.22)(PORT = 1521))
<BR> (PROTOCOL_STACK =
<BR> (PRESENTATION = TTC)
<BR> (SESSION = NS)
<BR> )
<BR> )
<BR>
<BR>SID_LIST_LISTENER =
<BR> (SID_LIST =
<BR> (SID_DESC =
<BR> (ORACLE_HOME = /ora)
<BR> (SID_NAME = ora8)
<BR> )
<BR>)
<BR>### 如果指明监听服务的"全局名"，则有类似这一行：(GLOBAL_DBNAME = ora8)
<BR>
<BR>２）启动Net8服务lsnrctl start
<BR>
<BR>首先你可以这样取得帮助：
<BR>[oracle@lin /ora]$ lsnrctl
<BR>LSNRCTL> help
<BR>然后开始启动：start
<BR>[oracle@lin bin]$ lsnrctl start
<BR>联接时，机器会逐步告诉你正在启动…,正在联接…,已经联接的状态,最后他说成功啦! <BR>下?
<BR>LSNRCTL for Linux: Version 8.1.5.0.0 - Production on 19-NOV-99 22:02:54
<BR>(c) Copyright 1998 Oracle Corporation. All rights reserved.
<BR>Starting /ora/bin/tnslsnr: please wait...
<BR>
<BR>TNSLSNR for Linux: Version 8.1.5.0.0 - Production
<BR>System parameter file is /ora/network/admin/listener.ora
<BR>Log messages written to /ora/network/log/listener.log
<BR>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521 <BR>))
<BR>(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
<BR>
<BR>Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521 <BR>))
<BR>(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
<BR>STATUS of the LISTENER
<BR>------------------------
<BR>Alias LISTENER
<BR>Version TNSLSNR for Linux: Version 8.1.5.0.0 - Production
<BR>Start Date 19-NOV-99 22:02:54
<BR>Uptime 0 days 0 hr. 0 min. 0 sec
<BR>Trace Level off
<BR>Security OFF
<BR>SNMP OFF
<BR>Listener Parameter File /ora/network/admin/listener.ora
<BR>Listener Log File /ora/network/log/listener.log
<BR>Services Summary...
<BR>ora8 has 1 service handler(s)
<BR>The command completed successfully
<BR>以上提示说，1个服务被处理，命令成功完成。
<BR>
<BR>３）停止Net8服务lsnrctl stop
<BR>
<BR>最简单的方法是 [oracle@lin /ora]$ lsnrctl stop
<BR>有时侯，进程出了差错，tnslsnr没有响应，像WindowsNT常犯的毛病一 样，
<BR>这里有一个强硬的手段：先找出它的进程号，然后 kill掉！
<BR>[oracle@lin /ora]$ ps -ef|grep tns
<BR>oracle 1331 1 0 15:51 ? 00:00:00 /ora/bin/tnslsnr LISTENER -inher
<BR>
<BR>或使用更少的参数也能找到tnslsnr:
<BR>[oracle@lin /ora]$ ps -e
<BR>PID TTY TIME CMD
<BR>1331 ? 00:00:00 tnslsnr
<BR>
<BR>现在杀死PID = 1331的进程：
<BR>[oracle@lin /ora]$ kill 1331
<BR>LSNRCTL象 SVRMGRL一样，是一个服务器管理程序，有不少参数，或者说是 子程序，带星 <BR>号
<BR>
<BR>[oracle@lin bin]$ lsnrctl stop
<BR>LSNRCTL for Linux: Version 8.1.5.0.0 - Production on 19-NOV-99 22:02:50
<BR>(c) Copyright 1998 Oracle Corporation. All rights reserved.
<BR>
<BR>Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521 <BR>))
<BR>(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
<BR>The command completed successfully
<BR>
<BR>
<BR>Listeners =DataBase Name = Global DB Name =ora8, HomeDir = /ora/ ,SID =ora8
<BR>
<BR>[oracle@lin oracle]$ cd /ora/net*/ad*
<BR>[oracle@lin admin]$ ls
<BR>listener.ora namesini.sql samples sqlnet.ora
<BR>namesdrp.sql namesupg.sql sqlnet.fdf tnsnames.ora
<BR>
<BR>下面是在 Windwos NT/98 上远程控制 TNSLSNR 的情形(图略)。
<BR>
<BR>４）参数文件摘要
<BR>
<BR>[oracle@lin admin]$ more /u01/app/oracle/admin/ora8/pfile/initora8.ora
<BR>db_name = ora8
<BR>instance_name = ora8 ## "事例名"是关键字
<BR>service_names = ora8
<BR>
<BR>control_files = ("/u01/app/oracle/oradata/ora8/control01.ctl", <BR>"/u01/app/oracle/
<BR>db_block_buffers = 8192
<BR>shared_pool_size = 4194304
<BR>log_checkpoint_interval = 10000
<BR>log_checkpoint_timeout = 1800
<BR>processes = 50
<BR>log_buffer = 163840
<BR>
<BR>log_archive_start = true
<BR>log_archive_dest_1 = "location=/u01/app/oracle/admin/ora8/arch"
<BR>log_archive_format = %t_%s.dbf
<BR># 切记打开回滚段
<BR>rollback_segments = (r01, r02, r03, r04)
<BR>
<BR># global_names = false ### 监听服务无需指明"全局名"
<BR># oracle_trace_enable = true
<BR># define directories to store trace and alert files
<BR>background_dump_dest = /u01/app/oracle/admin/ora8/bdump
<BR>core_dump_dest = /u01/app/oracle/admin/ora8/cdump
<BR>user_dump_dest = /u01/app/oracle/admin/ora8/udump
<BR>db_block_size = 2048
<BR>remote_login_passwordfile = exclusive
<BR>os_authent_prefix = ""
<BR>compatible = "8.1.5" ## 也可以兼容 "8.0.5"
<BR>
<BR>5)客户端网络配置
<BR>
<BR>[oracle@lin admin]$ more tnsnames.ora
<BR># TNSNAMES.ORA Configuration File:/ora/network/admin/tnsnames.ora
<BR># Generated by Oracle Net8 Assistant
<BR>
<BR>使用net8助理,结果自动保存在 tnsnames.ora 中，
<BR>[oracle@lin /ora]$ netass* 添加Service: 名称ora8，参数如下：
<BR>
<BR>PROTOCOL=TCP HOST=172.17.2.22 PORT=1521 Oracle_SID=ora8
<BR>机器解释成一个Oracle服务器地址包：
<BR>( DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521))
<BR> (PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))
<BR>)
<BR>一般说来，客户端采用Windows9x/NT/2000,因为这里软件开发容易，程序员和工具较为普 <BR>及
<BR>Windows 客户端网络配置与此类似，其内容见于: \OraNT\net80\Admin\tnsname.ora
<BR>ORA8.WORLD =
<BR> (DESCRIPTION =
<BR> (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.2.22)(PORT = 1521))
<BR> (CONNECT_DATA = (SID = ora8))
<BR> )
<BR>
<BR>-------------------------------------------
<BR> 在Windows2000(beta3专业版)中安装Personal Oeacle8.05时，监听服务安装失败， <BR>
<BR>只要理解以上oracle结构原理，可以手工复制Net8文件，修改配置：
<BR>copy CD-ROM\.\NT_x86\server\lsnrctl80.exe,tnslsnr80.exe,tnsping80.exe <BR>C:\orant\
<BR>copy CD-ROM\.\listener.ora C:\orant\net80\admin
<BR>我不久前有这么一次经历。
<BR> <BR>
<BR> <BR> <BR>-- <BR>※ 来源:·BBS 水木清华站 smth.org·[FROM: 202.112.45.46] <BR><CENTER><H1>BBS水木清华站∶精华区</H1></CENTER></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -