Oracle Version 7.3



These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.

Version

Oracle Communications ASAP - Version 7.3.0.0.0 and later Information in this document applies to any platform. Network Element is not getting connected after upgrading to ASAP 7.3.0.5. We have upgraded ASAP from 7.3.0.1 to 7.3.0.5. In the upgraded lab one of the Network element is not getting connected. 3856515 wrote: I'm trying to confirm what the latest RHEL 7 version that is supported with Oracle 12c r2. The documentation leads me to believe this is RHEL 7.3 but the documentation is also terrible and looks like it may just not have been updated.

Hdd

Oracle Version 7.3 Odbc Driver Download

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

7.3
All Forums
SQL Server 2005 Forums
SSIS and Import/Export (2005)
Oracle client and networking components

Author Topic
Pherkad
Starting Member

23 Posts

Posted - 2007-04-30 : 09:50:23
hi all.
In my SSIS project, i have to retrieve data from an oracle 10g database. On my personal laptop it works, but on our test-env i get the error below, when i try to test my connection to the oracle datasource.
Could this because i have oracle XE installed yet on my personal laptop, and it is not installed on the computer of our test environment where the SSIS runs? If that's the reason, it sounds very strange, because it would mean i have to install an oracle environment also on the computer with SSIS, just to make a connection to another oracle server..
Error:
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.
------------------------------
BUTTONS:
OK
------------------------------
Pherkad
Starting Member

23 Posts

Posted - 2007-04-30 : 10:12:52
is it maybe the oracle instant client that i need to install on the SQL Server PC ?
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-04-30 : 10:20:58
you need to install the Oracle client first. INstant client will probably work, but I have not used it with SSIS or even with DTS. make sure you also get a copy of your tnsnames.ora so you can resolve the names of your oracle instances.
-ec
Pherkad
Starting Member

23 Posts

Posted - 2007-04-30 : 10:31:40
think i have no other choice then using the instant client.
on this page the 10g standard client is only for PowerPC/Linux. Not for windows.
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
http://www.easysoft.com/support/kb/kb00612.html
or am i wrong?
eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-04-30 : 10:40:23
yeah, you are wrong
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html
-ec
Pherkad
Starting Member

23 Posts

Hp laserjet m1120 mfp driver windows server 2008 r2 standard x64 bit. Hp Laserjet M1120 Mfp Driver Windows Server 2008 R2 Download Film The Warriors Di Ganool Download How To Install Ettercap Centos Backstreet Boys All Song Zip Super Smash Bros Brawl Wad File Siemens Step 7 Crack Download Mini-kms Activator 1.3 Office 2010 Vl.exe Windows 8 Nonton Streaming Cooking Master Boy 720p. Hi, I got a LaserJet M1132 MFP printer shared over a LAN network (it is installed on windows server 2008 as title says). When I do print a document I get two different problems: - Landscape orientation pages gets printed with normal orientation. No matter the number of copys i select in the print options' window, the printer just prints one copy. Download the latest drivers, firmware, and software for your HP LaserJet M1120 Multifunction Printer.This is HP’s official website that will help automatically detect and download the correct drivers free of cost for your HP Computing and Printing products for Windows and Mac operating system.

Posted - 2007-04-30 : 10:53:20
thanks !!!!
but..
euhmmm..
400Mb for the client?
will it be such a heavy program / installation?
just for allowing my server to contact a pc where an oracle runs????
how comes it's such a huge download?
eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-04-30 : 10:55:58
quote:Originally posted by Pherkad
thanks !!!!
but..
euhmmm..
400Mb for the client?
will it be such a heavy program / installation?
just for allowing my server to contact a pc where an oracle runs????
how comes it's such a huge download?

it just is
try the instant client then.
-ec
Pherkad
Starting Member

Gundam seed remastered episode 1. 23 Posts

Posted - 2007-05-02 : 04:43:50
now i've installed the oracle XE on a pc, called EVO610.
on my pc with SSIS I installed the Oracle 10g runtime client as mentioned above.
when i now try to add a Datasource (with as provider: .Net ProvidersOracleClient Data Provider), I get the error below..
(for servername, i fill in EVO610 - thus the machinename, and as user and pwd I fill in SYS and the pwd i created.
error:
Test connection failed because of an error in initializing provider. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
what can this be?
Pherkad
Starting Member

23 Posts

Posted - 2007-05-02 : 08:19:03
damn what a mess.
now it finally works.
with the instant client alone, it doesn't work (no tnsnames.ora,.. was created).
1)i installed first the instant client, thereafter the runtime (both are in the big installation file above)
2)set system variables TNS_ADMIN and ORACLE_HOME manually (unbelievable that you have to do it manually)
%ORACLE_HOME%=C:oracleproduct10.2.0client_2
%TNS_ADMIN%=C:oracleproduct10.2.0client_2NETWORKADMIN
3)insert in the tnsnames.ora file (of the client pc):
EVO610 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.1.114)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XE)
)
)
#the service_name is what is configured under DEFAULT_SERVICE_LISTENER on the server pc, in the file C:oraclexeapporacleproduct10.2.0serverNETWORKADMINlistener.ora
(if tnsnames are well configured and able to connect to the server, you can check in advance with cmd>tnsping xxx)
4)client pc:
> odbc client administrator
> add new system dsn
> after clicking add, you will find a newly added 'instantclient' driver. there you can connect with the TNS name above.
5)now you can add a new data sourece in SSIS:
provider: native oleDB / native ole db provider for oracle
if someone has remarks or questions, don't hesitate.
it was a hell to find this all out myself, under extreme time-pressure, in a jungle of ducumentation and with few Oracle Administration knowledge.
Also thanks to eyechart for giving me the link to download the full 10g Client.. I don't understand why it's not on the main download page of 10g (the link in my post above).. I still wonder how you found that page.
Pherkad
Starting Member

23 Posts

Posted - 2007-05-02 : 08:39:24
quote:I don't understand why it's not on the main download page of 10g (the link in my post above).. I still wonder how you found that page.

OK, i found that you just pointed me to the enterprise/standard edition, which included a separate client runtime installation.. (it's very confusing that docs say: download the client, while you have to know that instead of downloading the client, you have to download the full installation.. and within the full installation, only install the runtime client (and/or instant client) component.
SRA
Starting Member

1 Post

Posted - 2010-11-23 : 14:38:46
Hi - The Instant Client allowed Windows to add a Microsoft ODBC for Oracle driver. So thanks for that info.
When I tried to create an Oracle Data Source Connection, I get an error that says:
'This Oracle DSN has been configure wiht an unsupported ODBC driver (version 2.575.1132.0 (xpsp.080413-0852)) Please update the ODBC driver to version 9.2.8.0 and above.'
The InstantClient was version 11.2.0.1.0.
Anyone know what this is all about?
Thanks

Oracle 7.3 Download

Oracle

Oracle Version 7.3.3

Version

Subscribe to SQLTeam.com

Oracle Version 7.3 Or Greater

Resources