Oracle Net8 网络配置和联接

hqy823

一、配置步骤综述 １）服务器端配置Listener： 添加Listeners , 设置选择 DataBase Name方式，填写2个参数 { HomeDir = /ora/ , SID =ora8 } ２）启动Net8服务lsnrctl start ３）停止Net8服务lsnrctl stop ４）参数文件摘要 ５）客户端配置：添加 Net Service Name ，同Windows客户端一样格式 二、配置步骤介绍 １）服务器端配置Listener： 执行/ora/bin/netasst 填写描述->首选Oracle服务： 。PROTOCOL = TCP 。HOST = 172.17.2.22或主机名 。PORT = 1521 查看生成的 Net8 Server配置文件：listener.ora [oracle@lin admin]$ more listener.ora # LISTENER.ORA Configuration File:/ora/network/admin/listener.ora # Generated by Oracle Net8 Assistant LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.2.22)(PORT = 1521)) (PROTOCOL_STACK = (PRESENTATION = TTC) (SESSION = NS) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (ORACLE_HOME = /ora) (SID_NAME = ora8) ) ) ### 如果指明监听服务的"全局名"，则有类似这一行：(GLOBAL_DBNAME = ora8) ２）启动Net8服务lsnrctl start 首先你可以这样取得帮助： [oracle@lin /ora]$ lsnrctl LSNRCTL> help 然后开始启动：start [oracle@lin bin]$ lsnrctl start 联接时，机器会逐步告诉你正在启动…,正在联接…,已经联接的状态,最后他说成功啦! 下面是一些简要信息： LSNRCTL for Linux: Version 8.1.5.0.0 - Production on 19-NOV-99 22:02:54 (c) Copyright 1998 Oracle Corporation. All rights reserved. Starting /ora/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 8.1.5.0.0 - Production System parameter file is /ora/network/admin/listener.ora Log messages written to /ora/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521)) (PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521)) (PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 8.1.5.0.0 - Production Start Date 19-NOV-99 22:02:54 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /ora/network/admin/listener.ora Listener Log File /ora/network/log/listener.log Services Summary... ora8 has 1 service handler(s) The command completed successfully 以上提示说，1个服务被处理，命令成功完成。 ３）停止Net8服务lsnrctl stop 最简单的方法是 [oracle@lin /ora]$ lsnrctl stop 有时侯，进程出了差错，tnslsnr没有响应，像WindowsNT常犯的毛病一样， 这里有一个强硬的手段：先找出它的进程号，然后 kill掉！ [oracle@lin /ora]$ ps -ef|grep tns oracle 1331 1 0 15:51 ? 00:00:00 /ora/bin/tnslsnr LISTENER -inher 或使用更少的参数也能找到tnslsnr: [oracle@lin /ora]$ ps -e PID TTY TIME CMD 1331 ? 00:00:00 tnslsnr 现在杀死PID = 1331的进程： [oracle@lin /ora]$ kill 1331 LSNRCTL象 SVRMGRL一样，是一个服务器管理程序，有不少参数，或者说是 子程序，带星号的是一个外部程序。 [oracle@lin bin]$ lsnrctl stop LSNRCTL for Linux: Version 8.1.5.0.0 - Production on 19-NOV-99 22:02:50 (c) Copyright 1998 Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.2.22)(PORT=1521)) (PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))) The command completed successfully Listeners =DataBase Name = Global DB Name =ora8, HomeDir = /ora/ ,SID =ora8 [oracle@lin oracle]$ cd /ora/net*/ad* [oracle@lin admin]$ ls listener.ora namesini.sql samples sqlnet.ora namesdrp.sql namesupg.sql sqlnet.fdf tnsnames.ora