DBA Blog

  Quest的产品还是很强大的，可以监控几乎所有的东西，比如就系统类的windows,linux,unix，应用类的oracle，mysql，DB2等等。具体的介绍大家可以看Quest的官方网站。
Quest的另一个亮点就是它那华丽，生动的界面让人赏心悦。不过比较遗憾的是目前这个是收费的产品（有少量的free，比如mysql监控）。
      介绍下Quest其中的一个产品－Spotlight On linux or oracle，这个用来监控在linux环境的oracle的状态。
       其实Spotlight On linux or oracle的工作原理和实现方式非常的简单，安装也非常的简单（这个客户端是安装在windows平台下），根据提示一步一步往下走就ok了，简单是下配置，在监控oracle之前，我们要确认客户端是否安装了oracle的client，如果没有要先安装oracle的client。假设我们已经安装了，主要的步骤就是配置oracle 的tnsnames.ora文件，使得它们之间可以互相通信。
  tnsname.ora

  # tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

RAC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rdb1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rdb2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

NUAGE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.120)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = nuage)
    )
  )

DBRAC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dbrac)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

NUAGE1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = nuage)
      (INSTANCE_NAME = nuage2)
    )
  )

NUAGE1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = nuage)
      (INSTANCE_NAME = nuage1)
    )
  )


soleil =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = nuage)
    )
  )

asm  =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = +ASM)
         (UR = A )
    )
  )


FX =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rdb1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rdb2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = fx)
    )
  )

fxasm =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rdb1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rdb2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = +ASM)
         (UR = A )
    )
  )

这么要注意的就是二个ASM的写法。
查看图片查看图片查看图片