Articles

Install first Oracle Instant client Basic 

Install ODBC

Install Tools package.

Source:https://docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm#CIHCJBFE

5.3 Manually Removing the Remaining Oracle Database Client Components

Oracle Universal Installer does not remove all Oracle components. After using Oracle Universal Installer to remove Oracle components, you need to manually remove remaining registry keys, environment variables, Start menu options, and directories.

This section contains these topics:

Note:

In rare situations, you might want to correct serious system problems by completely removing Oracle components manually from the computer without first deinstalling with Oracle Universal Installer. Do this only as a last resort, and only if you want to remove all Oracle components from your system.

5.3.1 Updating the PATH Environment Variable Path

Check the PATH environment variable and remove any Oracle entries.

  1. Display System in the Control Panel.

  2. Select the Advanced tab and then click Environment Variables.

  3. Select the system variable PATH and edit it to remove any Oracle entries.

    For example, remove Oracle entries that contain ORACLE_BASE\ORACLE_HOME in the PATH variable. You may see a PATH variable that contains entries similar to the following:

    ORACLE_BASE\ORACLE_HOME\bin;ORACLE_BASE\ORACLE_HOME\jre\1.4.2\bin\client;
    ORACLE_BASE\ORACLE_HOME\jre\1.4.2\bin
    
  4. Save any changes and exit System.

5.3.2 Removing Oracle Database Client from the Start Menu

Check the Start menu for any Oracle Database Client entries and remove them.

Follow these steps:

  1. Select Start, then Programs, then Oracle - HOME_NAME.

  2. Right-click Oracle - HOME_NAME, and from the menu, select Delete.

You can also remove Oracle Database Client menu entries by using the following method:

  1. Right click the Start button to display the pop-up menu.

  2. Select the Explore All Users option.

  3. Under Documents and Settings, expand the \Start Menu\Programs folder.

  4. Right-click and delete the Oracle - HOME_NAME folder.

5.3.3 Removing Oracle Database Client Directories

After removing all Oracle Database Client registry keys and restarting the computer, delete any existing Oracle Database Client directories and files.

  1. Using My Computer or Windows Explorer, delete the SYSTEM_DRIVE:\program files\oracle directory.

  2. Using My Computer or Windows Explorer, delete all ORACLE_BASE directories on your hard drive.

I had an old MS Access application (Office 2003) which I upgraded to Access 2013 and needed to configure Oracle instant client to connect to an Oracle 12 db.

The client used IFILE but since the number of users was very small we didn't want to hassle around with the Oracle team which was loaded in work at the time. So I configured the Oracle ODBC connection like this:

Problem: You have a new account in a domain and cannot change the login at first login as the RDP connection promts for username/password before you login. Since it is a catch 22 position you cannot set the password as this demands login to full desktop. 

I came over this great checklist from Stackoverflow on how to configure windows to run old asp applications.

Source:  http://stackoverflow.com/questions/27615726/classic-asp-error-800a01ad-activex-component-cant-create-object 

As I am dumping into alot of differnt types of issues at work I found this a particular good way of installing both the x64 and x86 version of Oracle client. In this case I was setting up a webserver with different legacy intranet sites for a customer. Some elements uses the x64 oracle client and some uses the x86 client. Previously I have used the guides below which has worked fine on Windows 2008.