【oracle 11g】配置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/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