啃爹的tnsping

啃爹的tnsping

配置好listener.ora 


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = prod)
      (ORACLE_HOME = /u01/oracle/db_1)
      (SID_NAME = prod)
    )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )


ADR_BASE_LISTENER = /u01


配置好tnsnames.ora


PROD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER= DEDICATED )
      (SERVICE_NAME = prod )
    )
  )


LISTENER_PROD =
  (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521))


ping自己试试看：tnsping prod

。。 。。 。

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521))) (CONNECT_DATA = (SERVER= DEDICATED) (SERVICE_NAME = prod)))
OK (0 msec)

换种方式ping自己试试看：tnsping 192.168.10.20

。。 。。 。。

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.20)(PORT=1521)))
OK (0 msec)




看见没有？居然少一堆数据，尤其是 (SERVICE_NAME=)，没名称？


好吧，在tnsnanes.ora里添加这个


192.168.10.20 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER= DEDICATED )
      (SERVICE_NAME = prod )
    )
  )

再来，tnsping 192.168.10.20
。。 。。 。。
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521))) (CONNECT_DATA = (SERVER= DEDICATED) (SERVICE_NAME = prod)))
OK (0 msec)

好吧，既然如此，那么，在oracledataguard中，没有加上standby的，能tnsping通，但依旧得不到server_name。

所以，配置oracledataguard时，得加上standby的

所以，配置nagios时，得加上ip地址的