Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

65

积分

0

好友

31

主题
1#
发表于 2015-3-12 23:02:40 | 查看: 3133| 回复: 0
现在机器上有两个平面(两个VLAN的地址)
一个是
10.172.200.22  业务平面的
一个是
10.172.23.37   管理平面的


grid@testdbb:~> cat /etc/hosts
#
# hosts         This file describes a number of hostname-to-address
#               mappings for the TCP/IP subsystem.  It is mostly
#               used at boot time, when no name servers are running.
#               On small systems, this file can be used instead of a
#               "named" name server.
# Syntax:
#   
# IP-Address  Full-Qualified-Hostname  Short-Hostname
#

127.0.0.1       localhost
10.172.200.22 testdba
10.172.23.23 testdba-heart

10.172.200.30 testdbb
10.172.23.37 testdbb-heart

10.172.25.9 hdp3500e
10.172.23.23   testdba_manager
10.172.23.37   testdbb_manager
10.172.23.24   testdba_managerFloat
10.172.23.24   testdbb_managerFloat
10.172.200.23   testdba_ServiceFloat
10.172.200.23   testdbb_ServiceFloat
10.172.200.23 see_service
grid@testdbb:~> cd   /opt/oracrs/product/11gR2/grid/network/admin




因为当前的ASM(或者说grid)的listener.ora的配置



grid@testdbb:/opt/oracrs/product/11gR2/grid/network/admin> vi lis*ora

# listener.ora Network Configuration File: /opt/oracrs/product/11gR2/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))
      (ADDRESS = (PROTOCOL = TCP)(HOST = testdbb)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /opt/oracrs/base

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

#----ADDED BY TNSLSNR 27-OCT-2014 23:33:08---
LOGGING_LISTENER = OFF
#--------------------------------------------
SECURE_REGISTER_LISTENER = (IPC)
~
~
"listener.ora" 20L, 646C written                              
grid@testdbb:/opt/oracrs/product/11gR2/grid/network/admin> vi lis*ora



确实监听也正常哦

grid@testdbb:/opt/oracrs/product/11gR2/grid/network/admin> lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-FEB-2015 10:45:14

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                29-JAN-2015 06:17:26
Uptime                    18 days 6 hr. 27 min. 50 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracrs/product/11gR2/grid/network/admin/listener.ora
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGISTER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testdbb)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>



但关键现在

10.172.200.30 testdbb

10.172.200.30是业务平面地址,

我想通过管理平面地址去访问ASM实例,所以打算在listener.ora里面配置上管理地址

所以加上了这样一条配置,就是高亮标黄的部分

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))
      (ADDRESS = (PROTOCOL = TCP)(HOST = testdbb)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.172.23.37)(PORT = 1521))
    )

  )




问题是重启监听器,报错了



LSNRCTL> start
Starting /opt/oracrs/product/11gR2/grid/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /opt/oracrs/product/11gR2/grid/network/admin/listener.ora
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGISTER)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testdbb)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.172.23.37)(PORT=1521)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   Linux Error: 98: Address already in use

Listener failed to start. See the error message(s) above...





不太理解为何ASM要报这个错TNS-12542: TNS:address already in use



如果按照映射关系

testdbb 对应的是业务平面地址 10.172.200.30

不应当和管理平面地址 10.172.23.37 冲突才对啊



testdbb:~ # ifconfig |grep addr
eth0      Link encap:Ethernet  HWaddr 00:16:3E:00:00:BA  
          inet addr:10.172.23.37  Bcast:10.172.23.255  Mask:255.255.255.0
          inet6 addr: fe80::216:3eff:fe00:ba/64 Scope:Link
eth0:0    Link encap:Ethernet  HWaddr 00:16:3E:00:00:BA  
          inet addr:10.172.23.24  Bcast:10.172.23.255  Mask:255.255.255.0
eth1      Link encap:Ethernet  HWaddr 00:16:3E:00:00:BB  
          inet addr:10.172.200.30  Bcast:10.172.201.255  Mask:255.255.254.0
          inet6 addr: fe80::216:3eff:fe00:bb/64 Scope:Link
eth1:0    Link encap:Ethernet  HWaddr 00:16:3E:00:00:BB  
          inet addr:10.172.200.23  Bcast:10.172.201.255  Mask:255.255.254.0
eth2      Link encap:Ethernet  HWaddr 00:16:3E:00:00:BC  
          inet addr:10.172.25.31  Bcast:10.172.25.255  Mask:255.255.255.0
          inet6 addr: fe80::216:3eff:fe00:bc/64 Scope:Link
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
testdbb:~ # su - grid
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-17 20:05 , Processed in 0.047188 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569