Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to configure oracle service_name instead SID on installation?

Questions
Tags
Users
Badges
Antonio Carlos Lacerda Dias
(32●1●10●14) Jul 22 '14, 12:44 p.m.
 Hi,

I'm having a problem when try connect to Oracle Database.

Our databases are using service_name instead SID and I don't know how to configure it on Build Forge during on installation.

Somebody have ideia about it?

Oracle 11g 64x
Build Forge 8.0.0.2

Thanks

0 votes

Comments
Donald Nong
Jul 23 '14, 12:03 a.m.

Your Oracle database has to have an SID and you just have to find out. If in doubt, show what the tnsnames.ora file looks like.
Also notice in the Build Forge document.

Important: During installation, tnsnames.ora is set up to use the same value for the database name and the Oracle SID. A limitation in JDBC drivers requires this constraint. If they are not the same, the Quick Report reporting feature and the services-layer APIs for Java and Perl do not work.

0 answers
4,190 views
0 votes

Be the first one to answer this question!

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 2,357

Question asked: Jul 22 '14, 12:44 p.m.

Question was seen: 4,190 times

Last updated: Jul 23 '14, 12:03 a.m.

Confirmation Cancel Confirm