It's all about the answers!

Ask a question

How to configure oracle service_name instead SID on installation?


Antonio Carlos Lacerda Dias (3211014) | asked 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

Comments
Donald Nong commented 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.

Be the first one to answer this question!


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.