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.
