"oracle 9i failed: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater"

Failed to test the data source in AEM and prompted with the error messages "oracle 9i failed: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater".

Cause: Oracle 9i Client software requires that the login user have the Authenticated User privilege to the Oracle Home in the client hosting machine.

Solution: You can follow the instruction below to finish the right grant:

Step 1: Login to Windows as a user with Administrator privileges.

Step 2: Launch Windows Explorer from the Start Menu and navigate to the ORACLE_HOME folder. This is typically the "Ora9i" folder under the "Oracle" folder (i.e. D:\Oracle\Ora9i).

Step 3: Right-click on the ORACLE_HOME folder and choose the "Properties" option from

the drop down list. Then the Properties window should appear.

Step 4: Click on the Security tab of the Properties window.

Step 5: Click on Authenticated Users item in the Name list.

Step 6: Uncheck the Read and Execute box in the Permissions list under the Allow column.

Step 7: Re-check the Read and Execute box under the Allow column (this is the box you just unchecked).

Step 8: Click the Advanced button and in the Permission Entries list make sure you see the Authenticated Users listed there with:

Permission = Read & Execute

Apply To = This folder, subfolders and files

Double check the Apply onto drop-down box and make sure it is set to This folder, subfolders and files.

Step 9: Click the OK button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files.

Step 10: Reboot your computer to assure that these changes have taken effect.