配置和自動啟動Oracle的監聽(lsnrctl)

配置Oracle lsnrctl 和自動啟動

1.設定主機名稱

[root@www ~]# cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=www.bkjia.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.bkjia.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.bkjia.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.bkjia.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 -- 查看狀態

1 2 下一頁