Hello Waseem,
Take a look at a similar problem I´ve been through:
Configuring AWS with Oracle.
The problems:
1. At the configuration wizard, the ORACLE database option is disabled.
2. A System DSN was created, but the AWS cannot connect to the driver.
3. Configuration Wizard states the password is been sent null.
4. When it finally connected, it states the user does not exist.
Workaround:
Try creating a User DSN, NOT A SYSTEM DSN, for the Oracle database (named Adobe Workflow Server Database) and the AWS driver (named Adobe Workflow Server). The ORACLE database option will continue to be disabled, so check the option to not create a new DSN and select one that already exists. Select the User DSN pointing at the ORACLE database.
ATTENTION!!!!!!!
ALWAYS USE THE MICROSOFT ORACLE DRIVER ALREADY INSTALLED WITH WINDOWS!!!! IT´S A GENERIC DRIVER, VERSION INDEPENDENT.
PS - if tat does not work:
1. Stop AWS service
2. Open AWS Administrator
3. Follow the steps through Configuration Wizard. Then, AWS Administrator will be open and configured.
4. Start AWS Service.
That should do it.
Daniel Maia