I am getting the following error message: "Could not connect to database: NET: Invalid SID"

on the PRTG Server i installed Oracle Net and SQLPlus. I use the following tnsnames.ora entry in the file on the PRTG Server:

IJUE_RAC=
  (DESCRIPTION=
    (FAILOVER=yes)
    (LOAD_BALANCE=yes)
    (ADDRESS_LIST=
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=172.20.50.1)
        (PORT=1521)
      )
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=172.20.50.2)
        (PORT=1521)
      )
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=172.20.50.3)
        (PORT=1521)
      )
    )
    (CONNECT_DATA=
      (FAILOVER_MODE=
        (TYPE=select)
        (METHOD=basic)
        (RETRIES=10)
        (DELAY=5)
      )
      (SERVER=dedicated)
      (SERVICE_NAME=IJUE.db.logitek.at)
    )
  )

in the sensor i use Service Name IJUE_RAC (also tried IJUE.db.logitek.at) - it just does not work.

thanks for help.

Article Comments

For the Oracle Sensor you need to enter the Servicename as specified in the tnsnames.ora on the Oracle Server. Please note that SID and Servicename may be different.


Feb, 2013 - Permalink

I already found a work-around.

The problem is, that we have an Oracle Real Appication Cluster and therefore we have more than one instance for one service name.

example: on host atlograc01 runs IJUE1 on host atlograc02 runs IJUE2 the service name is IJUE.db.logitek.at

For monitoring i now user IJUE1 - but monitoring will not work, if the atlograc01 is down - database is still working - thanks to rac, but the monitoring with prtg will fail.

How does PRTG connect to the oracle database - obviously not via Oracle Net ?


Feb, 2013 - Permalink

PRTG connects to Oracle directly via TCP/IP without involving the Oracle Client. I'm not sure about that, but I think the servicename can point to various SIDs dynamically, thus selecting the active cluster automatically. I think it should work choosing "IJUE.db.logitek.at" as servicename to connect a PRTG Sensor to Oracle.


Feb, 2013 - Permalink