It's all about the answers!

Ask a question

Example of Oracle connection string for DW


Neil Williams (66167) | asked Apr 08 '13, 8:24 a.m.
JAZZ DEVELOPER
Folks,

I'm after a real example of an oracle connection string as used in RRDI, I have data warehouse database and am trying to point RRDI at the database.

I have the oracle client installed, I have an entry in the tnsnames.ora, RRDI has the 32 bit oracle driver but I just don't know what the connection string should be.

I found this example and have made some assumptions

"MYCOGNOSDATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = MYDATA.MYCOMPANY.COM)(PORT = 1521)) ) (CONNECT_DATA = (SID = GOSL) (SERVER = DEDICATED) ) )

I think the connection string for RRDI is just MYCOGNOSDATA

It then looks this up in the tnsnames.ora
"

Is this correct?

Thanks
Neil

One answer



permanent link
Francesco Chiossi (5.7k11119) | answered Apr 08 '13, 8:40 a.m.
edited Apr 08 '13, 8:41 a.m.
Hello Neil,

the connection string should be the service name.

The entry in my tnsnames.ora looks like this:
RIDW =
  (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = RIDW)
)
)
and I use RIDW as SQL*Net connect string.

Best Regards
Francesco

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.