listener

oracle 监听配置

静态注册监听&动态注册监听（配置）

1. vim /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
LISTENER=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.44.100)(PORT=1521)))

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=pod)
(SID_NAME=pod)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
(PROGRAM=extproc)
)
)


#LISTENER1=
# (DESCRIPTION=
# (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.44.100)(PORT=1522)))

#SID_LIST_LISTENER1=
# (SID_LIST=
# (SID_DESC=
# (GLOBAL_DBNAME=pod)
# (SID_NAME=pod)
# (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
# (PROGRAM=extproc)
# )
# )

2.vim /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

POD =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.44.100) (PORT=1521))
(CONNECT_DATA=
(SID=pod)
(GLOBAL_NAME=pod)
(service_name=pod)
(server=dedicated))
)


#TEST =
# (DESCRIPTION=
# (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.44.100) (PORT=1522))
# (CONNECT_DATA=
# (SID=pod)
# (GLOBAL_NAME=pod)
# (service_name=test)
# (server=dedicated))
# )

3.[oracle@pod ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 22 11:25:54 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system set local_listener=pod;

System altered.

SQL> alter system register;

System altered.

SQL> show parameter listener

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string POD
remote_listener string

SQL> alter system set service_names=pod;

System altered.

SQL> show parameter service_name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string POD

4.[oracle@pod admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-JAN-2015 11:27:18

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.44.100)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 22-JAN-2015 11:22:56
Uptime 0 days 0 hr. 4 min. 22 sec
Trace Level off

第1页下一页