Well CDWP02 worked before with the same type of settings here is what the tnsnames.ora file has for this database:

CDWP02.HQ.TARGET.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cdwdb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = CDWP02)
    )
  )
[download]

This is what the other software are using to connect to oracle and they seem to be working fine. Thanks again...