Oracle probe + ASM - Connection details

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Trying to se the instance +ASM on Oracle probe.

 

All set ok based on the TNS file:

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DBDHPROD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.26)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHPROD)
    )
  )

DBPSPROD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.24)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBPSPROD)
    )
  )

RMAN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.111)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RMAN)
    )
  )

##### ADICIONADOS PARA O DATAGUARD ######
DBDHPROD_DG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.26)(PORT = 18001))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHPROD)
      (UR=A)
    )
)

DBDHDR1_DG=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.157)(PORT = 18001))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHDR1)
      (UR=A)
    )
)

DBPOCFC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST=172.16.2.38)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DBPOCFC)
    )
  )

ASM=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=172.16.2.26)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SERVICE_NAME=+ASM)
      (UR=A)
    )
  )

DBDHPROD_origem =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.26)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHPROD)
      (UR=A)
    )
  )

DBDHBKP_destino =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.61)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHBKP)
    )
  )

DBDHDEV_destino =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.61)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHDEV)
      (UR=A)
    )
  )

DBDHHOM_destino =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.61)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHHOM)
      (UR=A)
    )
  )

DBDHPROD_origem =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.26)(PORT = 18001))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHPROD)
      (UR=A)
    )
)

DBDHDR1_destino =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.157)(PORT = 18001))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHDR1)
      (UR=A)
    )
)

DBDHPROD_destino_14 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.224)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHPROD)
      (UR=A)
    )
  )

DBDHPROD_DG_PRY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.145)(PORT = 18001))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBDHPROD)
      (UR=A)
    )
)

 

Controller settings:

 

 

We already have another instance + ASM working fine

 

Environment

Release : 20.3

Component : UIM - ORACLE

Resolution

Need to create a new connection just for ASM separately