Installing Oracle Data Access Components (ODAC)
If you wish to perform password resets for Oracle database user accounts, you need to install the Oracle Data Access Components on the Passwordstate web server, and modify the path to these components in the two Passwordstate PowerShell scripts. To do this, please follow these instructions:
- Download ODP.NET_Managed_ODAC122cR1.zip from http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
- Unzip the contents to a directory of your choice on the Passwordstate Web Server (not within the Passwordstate folder though)
- Open a command prompt as an Administrator and change to the x64 directory inside where you extracted the Oracle zip file, i.e. cd c:\oracleodp\odp.net\managed\x64
- Now type configure.bat and press the enter key. The screen will output a series of commands and then advise “The operation completed successfully.”
- If the path you’ve installed the data access components to is different to c:\oracleodp, then you will need to go to the screen Administration -> System Settings -> Password Reset Options tab, and update the path on that screen
- Now restart the Passwordstate Windows Service