Ownsight

?找回密码
?立即注册
搜索
热搜: 活动 交友 discuz
查看: 914|回复: 0
打印 上一主题 下一主题

oracle 启动listener

[复制链接]

803

主题

903

帖子

3201

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
3201
跳转到指定楼层
楼主
发表于 2018-7-14 22:34:54 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
经常出现无法连接oracle的情况,尝试了各种办法,结果发现时监听没有打开,关键命令是
lsnrctl start??-- 启动监听
lsnrctl stop? ?-- 停止监听
lsnrctl status -- 查看状态

转自:https://blog.csdn.net/robertkun/article/details/17031281
配置Oracle lsnrctl 和自动启动1.设置主机名称


  • [root@www ~]# cat /etc/sysconfig/network



  • NETWORKING=yes



  • HOSTNAME=www.redhat6.com



2.设置主机名称与IP地址的对应


  • [root@www ~]# cat /etc/hosts



  • 127.0.0.1? ? localhost localhost.localdomain localhost4 localhost4.localdomain4



  • ::1? ?? ?? ? localhost localhost.localdomain localhost6 localhost6.localdomain6



  • 192.168.2.16 www.redhat6.com



3.修改:/u01/app/oracle/network/admin/listener.ora


  • [oracle@www admin]$ cat listener.ora



  • # listener.ora Network Configuration File: /u01/app/oracle/network/admin/listener.ora



  • # Generated by Oracle configuration tools.







  • LISTENER =



  • ??(DESCRIPTION_LIST =



  • ? ? (DESCRIPTION =



  • ? ?? ?(ADDRESS = (PROTOCOL = TCP)(HOST = www.redhat6.com)(PORT = 1521))



  • ? ? )



  • ??)











  • ADR_BASE_LISTENER = /u01/app



4.修改:/u01/app/oracle/network/admin/tnsnames.ora


  • [oracle@www admin]$ cat tnsnames.ora



  • # tnsnames.ora Network Configuration File: /u01/app/oracle/network/admin/tnsnames.ora



  • # Generated by Oracle configuration tools.







  • ORCL =



  • ??(DESCRIPTION =



  • ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))



  • ? ? (CONNECT_DATA =



  • ? ?? ?(SERVER = DEDICATED)



  • ? ?? ?(SERVICE_NAME = www.redhat6.com)



  • ? ? )



  • ??)



5.lsnrctl 的常用方法


  • [oracle@www admin]$ lsnrctl







  • LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2013 21:56:57







  • Copyright (c) 1991, 2011, Oracle.??All rights reserved.







  • Welcome to LSNRCTL, type "help" for information.



  • LSNRCTL> help



  • The following operations are available



  • An asterisk (*) denotes a modifier or extended command:







  • start? ?? ?? ?? ?? ?stop? ?? ?? ?? ?? ? status? ?? ?? ?? ???



  • services? ?? ?? ?? ?version? ?? ?? ?? ? reload? ?? ?? ?? ???



  • save_config? ?? ?? ?trace? ?? ?? ?? ?? ?spawn? ?? ?? ?? ?? ?



  • change_password? ???quit? ?? ?? ?? ?? ? exit? ?? ?? ?? ?? ?



  • set*? ?? ?? ?? ?? ? show*



lsnrctl start??-- 启动监听
lsnrctl stop? ?-- 停止监听
lsnrctl status -- 查看状态

6.设置Oracle数据库和lsnrct自动启动方法

(我的机器是RedHat6_64,Oracle11g)

6.1.编辑: /etc/oratab



  • [root@www ~]# cat /etc/oratab



  • #















  • # This file is used by ORACLE utilities.??It is created by root.sh



  • # and updated by either Database Configuration Assistant while creating



  • # a database or ASM Configuration Assistant while creating ASM instance.







  • # A colon, ':', is used as the field terminator.??A new line terminates



  • # the entry.??Lines beginning with a pound sign, '#', are comments.



  • #



  • # Entries are of the form:



  • #? ?$ORACLE_SIDORACLE_HOME::



  • #



  • # The first and second fields are the system identifier and home



  • # directory of the database respectively.??The third filed indicates



  • # to the dbstart utility that the database should , "Y", or should not,



  • # "N", be brought up at system boot time.



  • #



  • # Multiple entries with the same $ORACLE_SID are not allowed.



  • #



  • #



  • #orcl:/u01/app/oracle:N



  • orcl:/u01/app/oracle:Y? ? #这里把"N"改为"Y"



6.2.修改 /etc/rc.local



  • [root@www ~]# cat /etc/rc.local



  • #!/bin/sh



  • #



  • # This script will be executed *after* all the other init scripts.



  • # You can put your own initialization stuff in here if you don't



  • # want to do the full Sys V style init stuff.







  • touch /var/lock/subsys/local







  • # 添加下面两条



  • su - oracle -c 'dbstart'



  • su - oracle -c 'lsnrctl start'



6.3.重新启动系统.Oracle数据库正常启动.监听也启动了.



  • [oracle@www ~]$ sqlplus / as sysdba







  • SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 29 21:49:56 2013







  • Copyright (c) 1982, 2011, Oracle.??All rights reserved.











  • Connected to:



  • Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production



  • With the Partitioning, OLAP, Data Mining and Real Application Testing options







  • SQL> select status from v$instance;







  • STATUS



  • ------------



  • OPEN





  • [oracle@www ~]$ lsnrctl status







  • LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2013 22:03:23







  • Copyright (c) 1991, 2011, Oracle.??All rights reserved.







  • Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=www.redhat6.com)(PORT=1521)))



  • STATUS of the LISTENER



  • ------------------------



  • Alias? ?? ?? ?? ?? ?? ?? ?LISTENER



  • Version? ?? ?? ?? ?? ?? ? TNSLSNR for Linux: Version 11.2.0.3.0 - Production



  • Start Date? ?? ?? ?? ?? ? 29-NOV-2013 21:25:24



  • Uptime? ?? ?? ?? ?? ?? ???0 days 0 hr. 37 min. 59 sec



  • Trace Level? ?? ?? ?? ?? ?off



  • Security? ?? ?? ?? ?? ?? ?ON: Local OS Authentication



  • SNMP? ?? ?? ?? ?? ?? ?? ? OFF



  • Listener Parameter File? ?/u01/app/oracle/network/admin/listener.ora



  • Listener Log File? ?? ?? ?/u01/app/diag/tnslsnr/www/listener/alert/log.xml



  • Listening Endpoints Summary...



  • ??(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=www.redhat6.com)(PORT=1521)))



  • Services Summary...



  • Service "orcl" has 1 instance(s).



  • ??Instance "orcl", status READY, has 1 handler(s) for this service...



  • Service "orclXDB" has 1 instance(s).



  • ??Instance "orcl", status READY, has 1 handler(s) for this service...



  • The command completed successfully



其它问题:

关闭linux防火墙:



  • 暂时关闭:



  • service iptables stop







  • 永久性,需重启:



  • chkconfig iptables off







  • [root@www ~]# chkconfig --list | grep iptables



  • iptables? ?? ? ? ? ? ? 0ff? ? ? ? 1ff? ? ? ? 2n? ? ? ? 3n? ? ? ? 4n? ? ? ? 5n? ? ? ? 6ff



  • [root@www ~]# chkconfig iptables off



  • [root@www ~]# chkconfig --list | grep iptables



  • iptables? ?? ? ? ? ? ? 0ff? ? ? ? 1ff? ? ? ? 2ff? ? ? ? 3:off? ? ? ? 4:off? ? ? ? 5:off? ? ? ? 6:off



关闭selinux:



  • 1 永久方法 – 需要重启服务器



  • 修改/etc/selinux/config文件中设置SELINUX=disabled ,然后重启服务器。







  • 2 临时方法 – 设置系统参数



  • 使用命令setenforce 0



  • 附:



  • setenforce 1 设置SELinux 成为enforcing模式



  • setenforce 0 设置SELinux 成为permissive模式




您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表