配置和自动启动Oracle的监听(lsnrctl) |
您所在的位置：网站首页 › 监听程序怎么配置网络 › 配置和自动启动Oracle的监听(lsnrctl) |
|
配置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:: # # 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模式
|
| CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |