1、首先在客户机中安装oracle客户端
2、安装完之后打开服务器的监听
[oracle@zhang admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-APR-2014 12:55:53
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zhang)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 07-APR-2014 12:55:53
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zhang)(PORT=1521)))
The listener supports no services
The command completed successfully
如果是多实例的库,还需要修改一下shared_server_sessions和shared_servers参数的值,如果是单实例的库则无需配置,如果配置,参见上一个问题的解析
图形化配置
在客户机上打开net configuration assistant进入图形化配置界面
首先进行‘监听程序配置’
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_14224314702Vn6.png?x-oss-process=style/bb)
点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422431526uP77.png?x-oss-process=style/bb)
点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_14224315686LnZ.png?x-oss-process=style/bb)
监听名可以随意命名,按默认即可,点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422431604hwE6.png?x-oss-process=style/bb)
选TCP,点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422431805uFkZ.png?x-oss-process=style/bb)
默认,下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422432035wGJW.png?x-oss-process=style/bb)
默认,下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422432103spN9.png?x-oss-process=style/bb)
监听程序配置完成,点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422432260Ete6.png?x-oss-process=style/bb)
将点选在‘命名方法配置’一栏
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_14224324074QO1.png?x-oss-process=style/bb)
开始‘命名方法配置’,点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_14224324377xOM.png?x-oss-process=style/bb)
默认选‘本地命名’,点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422432480jwx4.png?x-oss-process=style/bb)
命名方法配置完成,点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422433820Otyr.png?x-oss-process=style/bb)
将小黑点选在‘本地Net服务名配置’一栏,开始配置本地Net服务名,点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422433848lLlL.png?x-oss-process=style/bb)
点添加,下一步
输入服务名,一般设为对应的实例名(理论上可以任意设置),点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422433899PM9P.png?x-oss-process=style/bb)
选择TCP点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_14224339222A2T.png?x-oss-process=style/bb)
填写主机名,主机名为数据库服务器的IP,其他默认,下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422433946dq5d.png?x-oss-process=style/bb)
选‘是,进行测试’,下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_142243397159Dq.png?x-oss-process=style/bb)
点更改登录,将正确的用户名和密码输入进行测试
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434010yNQV.png?x-oss-process=style/bb)
显示测试成功,即可确定监听配置成功,点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434036Hp47.png?x-oss-process=style/bb)
网络服务名,一把为对应的实例名,填上之后下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434079jB7J.png?x-oss-process=style/bb)
默认,下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434105ctj1.png?x-oss-process=style/bb)
Net服务名配置完毕,点下一步
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434133Ctdd.png?x-oss-process=style/bb)
点完成即完成监听的配置,然后通过Net manager查看
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434160442q.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434184N1fa.png?x-oss-process=style/bb)
配置完成之后在$ORACLE_HOME/network/admin目录下可以看到tnsname.ora的文件
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434215W2xJ.png?x-oss-process=style/bb)
打开查看
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434245ao7a.png?x-oss-process=style/bb)
以上即为配置后的tnsname.ora的内容
服务器上$ORACLE_HOME/network/admin中的内容为
![](http://img.blog.itpub.net/blog/attachment/201501/28/29802484_1422434277ex11.png?x-oss-process=style/bb)
手工配置监听
在客户机的$ORACLE_HOME/network/admin下编辑tnsname.ora文件,文件内容为
prod=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=tcp)(HOST=gc1)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=prod)
(SERVER=dedicated)
)
)
SAFE=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=tcp)(HOST=gc2)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=SAFE)
(SERVER=dedicated)
)
)
保存之后,修改一下shared_server_sessions和shared_servers参数的值即可
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29802484/viewspace-1418431/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29802484/viewspace-1418431/