Last post Oct 19, 2011 04:34 PM by petterb
Oct 12, 2011 12:14 PM|bobj181|LINK
I am very new to Oracle, and I need to accomplish the following:
Pull data from Oracle Database and upload it to an SQL Server.
Now ideally, I would like to use SSIS to pull the data as this is exactly what SSIS is designed to do. When I try to use the default Oracle and the Oracle preferred data connection namespaces, I get an error stating that there are no listeners.
I then try to utilize the OLE DB Connections in C#, which, with no surprise, provides me with the same error. I am currently using an ODBC to connect, but would like to utilize the SSIS package so I don't have so many pieces.
Where are the listners supposed to be located, are they supposed to be located on server where the DB is or on the local machine/server?
Oct 12, 2011 02:47 PM|ddelella|LINK
I would always download and install the Oracle Client Drivers for your version of Oracle. This will provide OLE DB and .NET drivers to make the proper connections. Be sure to also have the proper LDAP or TNS files configured for your connection. If this
does not mean anything to you need to speak to the DBA of the Oracle database to get these files.
Oct 16, 2011 05:01 PM|ruipedromachado|LINK
since oracle configuration is not known , you should make sure you can tnsping the alias from where you are located.
if you cant then you have a oracle configuration problem.
even if you are on the server you should be able to tnsping your alias.
the listener is always configured on the db server. (probably it might be able to install in remote machines , but never seen it , and not sure what were the advantages of it)
if its a microsoft windows machine you shoud check your windows services....one of them is the tnslistener service and it should be running.
i would recomend olso to use system.data.oracleclient name space from microsoft. just make sure if you are not on the server to install at least the oracle 10g client of higher.
with all this check it should be very easy from .net , just :
OracleConnection MyOracleConnection = new OracleConnection("""connection string""");
Oct 19, 2011 04:34 PM|petterb|LINK
there are no listeners - means you cannot access oracle server by some reason: server is down, listener is not running, the server is protected by firewall, etc. just contact to your oracle DBA