关于网络的一些问题，求解

wuchunqiang

/u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC15212))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15212))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON



/u01/app/oracle/product/11.2.0/grid/network/admin/tnsnames.ora

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.example.com)
    )
  )

FOR15212 =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15212))
)

~                     


/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.example.com)
    )
  )

FOR15212 =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15212))
)




SQL> show parameter local_lis

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      FOR15212



[oracle@station55 admin]$ tnsping for15212

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 03-SEP-2016 08:31:58

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15212)))
OK (0 msec)


[oracle@station55 admin]$ lsnrctl services;

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-SEP-2016 08:32:24

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
The command completed successfully



1、网络是否是这样配置的？
2、为什么lsnrctl services 没显示PORT=15212

botang

1. 配置文件其实只有 /u01/app/oracle/product/11.2.0/grid/network/admin里的才真正生效。
2. lsnrctl stop; lsnrctl start 再看看