I attempt to connect oracle from Appeon gives 'attempt to load Oracle client library thre badimageformatexcption, this problem will occur when running in 64 bit mode with 32 bit oracle component installed"

I have enabled 32 bit application in IIS appeon application pool, yet the problem persist

The reason why this issue occurs is that the Oracle client doesn't match with the Appeon server you installed, which means if your Appeon server installed is 32 bit (64 bit) then you need to use 32 bit (64 bit) Oracle client accordingly. Please go to AEM > Server > Product Activation > Licensing >Product Version to check the Appeon server edition (32 bit or 64 bit) you have installed and make sure that the Oracle client edition installed matches your Appeon Sever.

If the issue still persists even though the Oracle client matches with the Appeon server, then please follow up the instructions below to grant right to the Authenticated Users on the ORACLE_HOME folder to resolve the Oracle issue.

Step 1- Login to Windows Server 2008 R2 as the 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.