![]() Create and test sqlplus shortcuts for both.Ħ4: C:\app\client\ oracle\product\19.0.0\client_1\bin\sqlplus.exe 32: C:\app\client\ oracle32\product\19.0.0\ client_32\bin\sqlplus.exe Create and test ODBC connections for both.Ħ4 ODBC Mgr: C:\Windows\System32\odbcad32.exe 32 ODBC Mgr: C:\Windows\SysWOW64\odbcad32.exe Create a TNS_ADMIN\tnsnames.ora entry(s) as needed.ĥ. Set it to the 64-bit home network path:Ĥ. Create a TNS_ADMIN System environment var. ![]() Software location: C:\app\client\ oracle32\product\19.0.0\ client_32ģ. Run setup.exe passing: ORACLE_HOME_NAME= client_32 C:\sw\NT_193000_client\client32\setup.exe ORACLE_HOME_NAME= client_32 Takes a few minutes to load. If set, unset all Oracle environment vars: ORACLE_BASE, ORACLE_HOME.ī. These steps have been derived from Doc ID 124353.1. Go to the drive where the Oracle software is installed on your machineĪnd delete all ORACLE_BASE directories on your hard drive. %SystemDrive%\Documents and Settings\\Local Settings\Temp Though some might be hidden, in placing the path in File Explorer they should open.Ĭ:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle - OraClient19Home1Ĭ:\Users\\AppData\Roaming\Microsoft\Windows\Start MenuĬ:\Users\\AppData\Roaming\Microsoft\Windows\Start Menu\Programs.Remove ORACLE_SID, ORACLE_BASE, ORACLE_HOME and TNS_ADMIN. PATH = Remove any path to Oracle client.ī. Oracle., ORADC., ORAMMC., OraOLE., OraPerf. Remove all keys that begin with Ora or ORCL HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\.\Uninstall Remove all keys under here that begin with ORACLE. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\.\Application Remove all keys under here that begin with ORACLE or ORAWEB. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services Delete the home (ex: KEY_OraClient19Home1).Įxpand all subkeys and remove all keys related with the "Oracle ODBC Driver". Make sure you have complete backups of your system before you make any changes.%ORACLE_HOME%\BIN\sqlplus.exe %ORACLE_HOME%\BIN\sqlplus.exe Ensure you are logged in as a user with Administrator privileges. Press Windows-Key then type env for option to edit environment vars.Įnsure you can do the following to your Oracle database server. TNS_ADMIN: C:\app\client\oracle\product\19.0.0\client_1\network\admin ORACLE_HOME: C:\app\client\oracle\product\19.0.0\client_1 Make sure your Windows system does not name the file Create appropriate entry in the tnsnames.ora file if not already done.ģ. If your system has multiple Oracle clients on it - try using theĬ:\app\oracle\client\product\19.0.0\client_1\network\adminĢ. The installer adds this entry to the PATH environment var:.Software location: C:\app\client\ oracle\product\19.0.0\client_1ĥ. Oracle Home User Selection: (x) Use Windows Built-in Account Run C:\sw\WINDOWS.X64_193000_client\client\setup.exe As Administrator.ģ. Windows-Key ? File Explorer ? View ? File name extensions Set windows system to show file extensions:
0 Comments
Leave a Reply. |