BusinessObjects Board

Cannot Create Connection to Oracle Database in CMC

dataservices information steward
#1

Hi,

I am trying to create a connection to an Oracle database in the Central Management Console for Information Steward 4.1.
I have installed the correct Oracle client on the Data Services Job Server being used by Information Steward and configured the connection to the Oracle database and tested with SQL Plus with no issues. I think the issue is populating the Database Connection Name field in the Central Management Console. What format does this need to be in? Does it need to be the same name as the data source in the tnsnames.ora file?

dsewardj (BOB member since 2012-10-22)

#2

are you able to connect from Data services to the same oracle database ?

surya.sap (BOB member since 2012-07-30)

#3

The Database Connection Name in the CMC needs to be the same as the data source name in the tnsnames.ora file.

Your tnsnames.ora file should look something like this:

SERVER_PROD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PROD)
    )
  )

So in the example above you would enter SERVER_PROD into the Database Connection Name in CMC.

dsewardj (BOB member since 2012-10-22)