配置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/product/11.4.0/dbhome_1/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/product/11.4.0/dbhome_1/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 – 查看状态
错误 TNS-12543,TNS-12560
解决办法:确认listener.ora 和 tnsnames.ora中的host设置正确,再重启lsnrctl
lsnrctl exit
lsnrctl start