Bo's Oracle Station

查看: 2160|回复: 1

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

[复制链接]

17

主题

32

帖子

140

积分

版主

Rank: 7Rank: 7Rank: 7

积分
140
发表于 2016-9-3 00:32:39 | 显示全部楼层 |阅读模式
/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



回复

使用道具 举报

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2016-9-3 09:12:30 | 显示全部楼层
1. 配置文件其实只有 /u01/app/oracle/product/11.2.0/grid/network/admin里的才真正生效。
2. lsnrctl stop; lsnrctl start 再看看
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 16:50 , Processed in 0.029000 second(s), 24 queries .

快速回复 返回顶部 返回列表