关闭

配置和自动启动Oracle的监听(lsnrctl)

标签: oraclelsnrctl自动启动
13364人阅读 评论(0) 收藏 举报

配置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_SID:$ORACLE_HOME:<N|Y>:
#
# 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       	0:off	1:off	2:on	3:on	4:on	5:on	6:off
[root@www ~]# chkconfig iptables off
[root@www ~]# chkconfig --list | grep iptables
iptables       	0:off	1:off	2:off	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模式


 

1
0
查看评论

理解 oracle 的 “lsnrctl status”

先看看 lsnrctl status 的输出信息:     Services Summary...     Service "PLSExtPRoc" has 1 instance(s).  ...
  • cuiyan1982
  • cuiyan1982
  • 2015-05-06 16:23
  • 1172

lsnrctl status后即无任何反应,而SQL*Plus正常

错误信息:lsnrctl status后即无任何反应,而SQL*Plus正常 问题诊断:oracle 10.2.0.1.0的一个4518443的bug导致的,这个bug会自动创建一个子监听器,当出现这种情况时,监听就会挂起 解决方式: #查看LISTNER进程 ps -aux |gr...
  • orcldb
  • orcldb
  • 2012-06-18 11:22
  • 3959

Oracle Lsnrctl - 关于oracle监听器的命令和解释

转自:http://blog.csdn.net/zjliu1984/archive/2009/06/16/4273304.aspx       对于DBA来说,启动和关闭oracle监听器是很基础的任务,但是Linux系统管理员或者程序员有...
  • fm0517
  • fm0517
  • 2009-09-18 10:04
  • 28302

监听总结之3.监听命令:lsnrctl工具的三个命令start、stop和status都是分步执行的

首先,我们需要知道两个事情: 1、lsnrctl工具下的三个命令,分别是status、stop、start。 我们从三个命令执行后在屏幕上显示的结果来看,可以发现一个共性,就是都有“正在连接到”这句话 。 2、每次进入lsnrctl工具的环境时,lsnrctl工具都会自动读取一次listener.o...
  • haiross
  • haiross
  • 2013-11-07 14:51
  • 8968

lsnrctl status看不到监听注册的实例

作为一个初学者接触到ORACLE时,对监听的理解总是很模糊,经常遇到这样的问题:明明数据库已经起来了,监听也起来了,为啥lsnrctl status时,还是看不到监听注册的实例呢(如下图)?。现在学了有段时间了,对此也渐渐明朗了。下面是个人对这一问题的理解: 首先要清楚监听是用来干嘛的? ...
  • songyundong1993
  • songyundong1993
  • 2016-08-05 14:21
  • 2454

oracle监听器启动lsnrctl status例程的状态为unknown

以前同事问及为何数据库例程在监听器中状态为unnkown,这是何意.有何影响.查阅了资料,解决如下: # listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\listene...
  • Eason_oracle
  • Eason_oracle
  • 2016-11-11 10:42
  • 5481

Lsnrctl status/start 卡住问题及解决办法

Lsnrctl status/start hangs 转载请注明出处:http://blog.csdn.net/xiaofan23z Environment:  HPUX B11.31 + oracle 10.2.0.4 three nodes rac Symptom:...
  • xiaofan23z
  • xiaofan23z
  • 2012-04-09 11:03
  • 7651

Oracle LSNRCTL------监听器的启动和关闭

      对于DBA来说,启动和关闭oracle监听器是很基础的任务,但是Linux系统管理员或者程序员有时也需要在开发数据库中做一些基本的DBA操作,因此了解一些基本的管理操作对他们来说很重要。    &#...
  • zjliu1984
  • zjliu1984
  • 2009-06-16 14:31
  • 25799

oracle 监听 lsnrctl 命令

listener control 监听控制 因为你在键入 lsnrctl 回车之后,就进入到监听控制界面。 $lsnrctl start   --启动监听进程 $lsnrctl status  --显示监听进程 $lsnrctl stop &...
  • snowfoxmonitor
  • snowfoxmonitor
  • 2015-08-16 07:53
  • 3086

Oracle Lsnrctl - 关于oracle监听器的命令和解释

 转自:http://blog.csdn.net/zjliu1984/archive/2009/06/16/4273304.aspx         对于DBA来说,启动和关闭oracle监听器是很基础的任务,但是Linux系统管...
  • YaoXTao
  • YaoXTao
  • 2015-07-09 10:07
  • 3043
    个人资料
    • 访问:716751次
    • 积分:8987
    • 等级:
    • 排名:第2506名
    • 原创:182篇
    • 转载:125篇
    • 译文:1篇
    • 评论:109条
    博客专栏
    初识Qt

    文章:43篇

    阅读:147934
    文章分类
    最新评论