【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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!