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

loinooo

配置Oracle lsnrctl 和自动启动
1.设置主机名称
[iyunv@www ~]# cat /etc/sysconfig/network  
NETWORKING=yes  
HOSTNAME=www.redhat6.com  

2.设置主机名称与IP地址的对应
[iyunv@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
[iyunv@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
[iyunv@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  

[iyunv@www ~]# chkconfig --list | grep iptables  
iptables        0:off   1:off   2:on    3:on    4:on    5:on    6:off  
[iyunv@www ~]# chkconfig iptables off  
[iyunv@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模式  

linuxx

幻想你每天都陪在我身边.睡梦中都因你而笑