Oracle 9.2 Client software requires that you give the Authenticated User privilege to the Oracle Home by following these steps: 1. Log on to Windows as a user with Administrator privileges. Download Oracle Client Software Version 8.1.7 Or Greater Free - 1a8c34a149 You may get 'System.Data.OracleClient requires Oracle client. Download oracle client software version 8.1.7 or greater free.
Instant Client for Linux. Instant Client for Linux x86-64; Instant Client for Linux x86; Instant Client for Linux AMD64 (32-bit and 64-bit) Instant Client for Linux on Power Big Endian (32-bit). You can find the links below. 32 bit: bit: https://www.oracle.com/technetwork/databas.
Re: Help on System.Data.OracleClient requires Oracle client software version 8.1.7 or greater?
Apr 02, 2009 03:53 PM|greg.darling|LINK
Hi,
Didnt you say you aready had a 10g client? As this was working before you added developer 6i, moving the 10g client back to the front of your PATH system environment variable should have fixed it. To do that you could either open the Oracle Universal Installer that was probably also installed with the 10g client, click Installed Products > Environment tab , then move the 10g home to the top of the list with the arrows. You also could have just editted your PATH system environment variable manually and put the 10g bin back in the front of the other stuff.
Since System.Data.OracleClient loads oci.dll based on PATH, if your 806 home is first it would find the 806 oci.dll and as the error message says..
If you added another home, it sounds like you now have at least 3 oracle homes. The homes arent aware of each other, so all 3 need to have tnsnames.ora configured.
Alternatively, if you set a system environment variable called TNS_ADMIN and point it to a folder that contains tnsnames.ora and sqlnet.ora, all of the install clients/homes will use that single copy of tnsnames/sqlnet.
Hope it helps,
Greg
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
August 4, 2009 at 6:07 am | Posted in SSMA Oracle Errors, SSMA Oracle Knowledgebase | Leave a commentSymptom
When doing data migration you may get the following error. Following message may be displayed on the console.
Migrating data…
Analyzing metadata…
Preparing data migration package…
Starting data migration agent…
Starting data migration…
Exception during processing: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Data migration complete.
0 table(s) successfully migrated.
0 table(s) partially migrated.
1 table(s) failed to migrate.
Cause
This error may be caused due to one the following reasons:
·Oracle client provider is not installed on the sql server, you are trying to connect.
·SSMA Extension Pack is not installed on SQL Server
·Oracle Client maynot be accessible to the DataMigrator utility from Extension Pack. This utility is started with the same account used to run SQL Agent.
Resolution
SSMA Data Migrator needs Oracle client provider installed on the SQL Server machine to perform data migration. When it does not find Oracle Client provider it gives this error.
·Install the Oracle Client provider on your sql server and verify data migration.
·Cross check Extension pack is installed on your sql server machine
· Malayalam channels in usa. Oracle Client maynot be accessible to the BCPDataMigrator utility from Extension Pack. This utility is started with the same account used to run SQL Agent. Make sure this account has access to the Oracle client folder and it's contents.
More Information
Article Id: KBO2SS1001
Applies to
·SSMA 2005 for Oracle
Oracle Client Software Version 8.1 7 Or Greater Free Download
Data migration complete.
0 table(s) successfully migrated.
0 table(s) partially migrated.
1 table(s) failed to migrate.
Cause
This error may be caused due to one the following reasons:
·Oracle client provider is not installed on the sql server, you are trying to connect.
·SSMA Extension Pack is not installed on SQL Server
·Oracle Client maynot be accessible to the DataMigrator utility from Extension Pack. This utility is started with the same account used to run SQL Agent.
Resolution
SSMA Data Migrator needs Oracle client provider installed on the SQL Server machine to perform data migration. When it does not find Oracle Client provider it gives this error.
·Install the Oracle Client provider on your sql server and verify data migration.
·Cross check Extension pack is installed on your sql server machine
· Malayalam channels in usa. Oracle Client maynot be accessible to the BCPDataMigrator utility from Extension Pack. This utility is started with the same account used to run SQL Agent. Make sure this account has access to the Oracle client folder and it's contents.
More Information
Article Id: KBO2SS1001
Applies to
·SSMA 2005 for Oracle
Oracle Client Software Version 8.1 7 Or Greater Free Download
Yahoo Messenger Version 8.1
·SSMA 2008 for Oracle
