Creating an Oracle Datasource

pwarden · 2009-11-17T08:46:36+00:00

Hi, I am new to Birt and I am trying to create my first datasource. I have done the following: Right Clicked Data Sources and selected new Checked Create from a datasource in the following list selected JDBC Data Source selected my driver class…

pwarden

Hi,

I am new to Birt and I am trying to create my first datasource.

I have done the following:

Right Clicked Data Sources and selected new
Checked Create from a datasource in the following list
selected JDBC Data Source
selected my driver class (oracle.jdbc.driver.OracleDriver)
database URL - jdbc:oracle:thin:@lnl36d-6001a-virt.csfp.co.uk:1521:DLNDRV50
Username - KPSUNIVERSAL
password - entered password

When I test the connection I get listener refused the connection with the following error

ora-12505, TNSlistener does not currently know of SID given etc....

I think the problem may occur because we have load balance on and in my TNSNAMES.ORA this would be displayed as

DLNDRV50.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lnl36d-6001a-virt.csfp.co.uk)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = lnl36d-6001b-virt.csfp.co.uk)(PORT = 1521))
(LOAD_BALANCE = on) (FAILOVER = on ))
(CONNECT_DATA = (FAILOVER_MODE = (TYPE = session) (METHOD = basic) (RETRIES = 20) (DELAY = 5) )
)

Could anyone advise what I am doing wrong please.

Thanks

Find more posts tagged with

Comments

JasonW

Have you tried this url

jdbc:oracle:thin:@DLNDRV50.WORLD

Jason

meg

I too am struggling to configure Oracle Data Source in BIRT 2.5. I have a clustered Oracle DB. I tried to use TNS name entry in JDBC URL (jdbc:oracle:thin:@<TNSNAME>) as you have suggested but it did not work. "Test Connection" seems to go in some infinite loop and never returns and not giving any error either. 
 
How will oracle driver know about TNSNAMES.ora file ? Do I need to create some environment variable to point to oracle home ? 
 
Thanks 
 
<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="56917" data-time="1258481431" data-date="17 November 2009 - 11:10 AM">
Have you tried this url 
 
 
jdbc:oracle:thin:@DLNDRV50.WORLD 
 
 
Jason </blockquote>

thuston

You will want to review your Oracle documentation for the proper URL syntax for their JDBC driver to connect to a distrubted or load balanced Oracle installation.