Oracle 32 bit Client and ODAC is required to run Oracle Password Changing.
Note: Secret Server the web application runs in 32 bit mode even on a 64 bit Windows Server (this is because ASP.NET defaults to 32 bit version even on 64 bit OS). Secret Server Agent will run as 32 bit or 64 bit depending on the machine OS that is installed on. Oracle Password Changing through Agent will only work on a 32 bit OS.
1. Install 32-bit Oracle Database Client (10.2.0.3.0) for Microsoft Windows Vista and Windows Server 2008.
a. Open this page in a web browser: http://www.oracle.com/technetwork/database/10203vista-087538.html
b. Select “Oracle Database 10g Client Release 2 (10.2.0.3)” (10203_vista_w2k8_x86_production_client.zip, second item from the end of the list) and download to local computer.
c. Extract zip file and run Setup.exe
d. On the “Select Installation Type” screen, select “Runtime” from the installation options.
e. Accept defaults and press Next, until you finally can press “Install”. (You may get an error on the “Product-Specific Prerequisite Checks”, with text like “Checking operating system requirements ... Expected result: One of 5.0,5.1,5.2,6.0 Actual Result: 6.1”. This means that you have a version of Windows that is newer than the version the Oracle software was checking for. For example Windows Server 2008 R2 reports a version of 6.1. This warning can be "cleared" by checking the status checkbox as User Verified and continuing the installation.)
2. Download ODAC and unzip its contents by running the executable.
a. Open this page in a web browser: http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html
b. Select “Oracle 10g ODAC” (ODAC1020221.exe, second item from the end of the list). Note: do not save this into any directory created from the first download and unzipping above.
c. Execute the file. This will create 2 new directories. One of these, “Stage,” will be used below.
3. Use the Oracle 10.2.0.3 installer to install Oracle Data Access Components (10.2.0.2.21). Do not use ODAC's installer. The ODAC product should be installed in the default directory that it offers.
a. To install ODAC 10.2.0.2.21 using the Oracle 10.2.0.3 installer, go to Start>All Programs>Oracle – OraClient 10g_home1>Oracle Installation Products>Universal Installer (or execute setup.exe use_prereq_checker=false from a command prompt from within the following directory <oracle installation directory>\oui\bin.)
b. On the “Specify Source Location” screen select the “products.xml” in the Stage folder that was extracted above.
c. On “Select a Product to Install” select the first item “Oracle Data Access Components 10.2.0.2.21.
d. On “Specify Home Details” the default of “Home1” should be used.
e. Press Next until you come to Install and press Install.
f. Give full rights access to the account running the Secret Server application pool on the Home folder.
g. As of 7.8.000000, Copy the C:\<Oracle Home>\ODP.NET\bin\2.x\Oracle.DataAccess.dll file to the bin folder of your Secret Server web application folder. ie: c:\Inetpub\wwwroot\SecretServer\bin
-NOTE: If you are installing the oracle client on a Secret Server Agent server, the Oracle.DataAccess.dll will need to be copied to the install directory of the Secret Server Agent.
h. Restart the server.
4. Using command prompt
a. Use the utility TNSPING to test out connectivity to the Oracle instance. Enter “tnsping 192.168.99.197:1521” and press enter. (Substitute the ip address and port for your instance as necessary).
b. Use TNSPING to verify data source string. Enter “tnsping (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.99.197)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xe)))” and press enter. (Substitute ip address, port, and database (service name) as necessary).
c. Use SQLPlus for final checkout. Go to Start>All Programs>Oracle – OraClien 10g_home1>Application Development>SQL Plus. Enter user name, password and the host string (the data source string tested immediately above.). Press OK. Enter “select sysdate from dual;”, if today’s date is returned then checkout is complete.
f. Give full rights access to the account running the Secret Server application pool on the Home folder.
Article ID: 125, Created On: 10/26/2010, Modified: 10/28/2011