OracleNet8网络配置和联接

文章作者 100test 发表时间 2007:12:15 13:16:00
来源 100Test.Com百考试题网


1)服务器端配置Listener:
  添加Listeners , 设置选择 DataBase Name方式,填写2个参数 { HomeDir = /ora/ , SID =ora8 }
  2)启动Net8服务lsnrctl start
  3)停止Net8服务lsnrctl stop
  4)参数文件摘要
  5)客户端配置:添加 Net Service Name ,同Windows客户端一样格式
  1)服务器端配置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) www.bitsCN.com
   (SID_NAME = ora8)
   )
  )
  ### 如果指明监听服务的"全局名",则有类似这一行:(GLOBAL_DBNAME = ora8)
  2)启动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)) www_bitscn_com
  (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个服务被处理,命令成功完成。

相关文章


安装好Oracle后SQL*Plus的操作初步
如何在Oracle中建立汉字拼音对照表
从V$DB_CACHE_ADVICE中设置数据缓冲大小
OracleNet8网络配置和联接
澳大利亚华人论坛
考好网
日本华人论坛
华人移民留学论坛
英国华人论坛