啃爹的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地址的