配置和自动启动Oracle的监听(lsnrctl)
来源:互联网 发布:有向图自动布局算法 编辑:程序博客网 时间:2024/06/06 07:06
配置Oracle lsnrctl 和自动启动
1.设置主机名称
[root@www ~]# cat /etc/sysconfig/networkNETWORKING=yesHOSTNAME=www.redhat6.com
2.设置主机名称与IP地址的对应
[root@www ~]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.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]$ lsnrctlLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2013 21:56:57Copyright (c) 1991, 2011, Oracle. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> helpThe following operations are availableAn 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:Norcl:/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 sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 29 21:49:56 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select status from v$instance;STATUS------------OPEN
[oracle@www ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2013 22:03:23Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=www.redhat6.com)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date 29-NOV-2013 21:25:24Uptime 0 days 0 hr. 37 min. 59 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/network/admin/listener.oraListener Log File /u01/app/diag/tnslsnr/www/listener/alert/log.xmlListening 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 iptablesiptables 0:off1:off2:on3:on4:on5:on6:off[root@www ~]# chkconfig iptables off[root@www ~]# chkconfig --list | grep iptablesiptables 0:off1:off2:off3:off4:off5:off6:off
关闭selinux:
1 永久方法 – 需要重启服务器修改/etc/selinux/config文件中设置SELINUX=disabled ,然后重启服务器。2 临时方法 – 设置系统参数使用命令setenforce 0附:setenforce 1 设置SELinux 成为enforcing模式setenforce 0 设置SELinux 成为permissive模式
- 配置和自动启动Oracle的监听(lsnrctl)
- 【转】配置和自动启动Oracle的监听(lsnrctl)
- Oracle LSNRCTL------监听器的启动和关闭
- Oracle lsnrctl--监听器的启动和关闭
- 在Linux下Oracle LSNRCTL--监听器的启动和关闭
- oracle 监听 lsnrctl 命令
- oracle 监听启动的时候 lsnrctl start 的显示 什么服务read unknown 之类的解释
- ORACLE服务器监听程序LSNRCTL
- oracle监听器启动lsnrctl status例程的状态为unknown
- Linux下oracle启动/关闭监听(bash:lsnrctl:command not found)
- Oracle 监听lsnrctl命令启动报错(TNS-12537,TNS-12560,TNS-00507)
- Linux下oracle启动/关闭监听(bash:lsnrctl:command not found)
- Oracle监听lsnrctl查询状态详解
- Oracle监听lsnrctl查询状态详解
- linux下设置自动启动和关闭oracle实例、监听
- 开机自动启动单实例oracle和监听
- linux设置oracle数据库和监听开机自动启动
- 安装oracle后,配置监听和oracle自启动
- USB描述符详解
- 第十五节cocosdx的定时器
- dos窗口下删除.svn文件的命令
- 【第七课:C++和opencv】图像的膨胀+控制条
- 第十六节自动配置cpp文件的mk
- 配置和自动启动Oracle的监听(lsnrctl)
- 对于循环不变式证明的总结
- PreTranslateMessage作用和使用方法
- nm命令
- 经典SQL语句大全
- 一种简单,快速,精准的sin/cos函数模拟,及as3实现
- JavaScript操作Java对象
- frame框架设计网页
- 高效的JS字符串拼接