If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

connection in sit not working

Started by jammaster, 11 Nov 2019 10:56:29 AM

Previous topic - Next topic

jammaster

Hi,

Hoping you can help with connection issues. I am Using Cognos 10.2.2 and Oracle 12.1.0 I was able to create new Data Source on Dev box successfully, but when I am trying to make connection
to SIT box, I am getting error.  I updated the tnsnames.ora on the SIT box (below is for Dev and SIT).  When creating connection on cognos, I am selecting
Type: Oracle, Use defualt gateway, unchecked "Configure JDBC connection", SQL*Net connection string: dw_sit, selected "Signons" and put userid and password and when I click on
"Test the connection" I get the attached error.  I am able to log on using Oracle SQL Developer but not when trying to connect in Cognos. This works fine in Dev box but not on SIT box.  I have
other Oracle connections that work on both Dev and SIT, but for some reason this particular connection I am having issues with.

Thanks

dw_dev =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dwdev.abc.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = abcd)
    )
  )

dw_sit =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dwsit.abc.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = abcd)
    )
  )

jammaster

found out the issue.... when researching online, said to do search for more than one tnsnames.ora   I found out SIT has 2 servers, so modified the wrong tnsnames.ora