Installing a centralized Oracle Client and sharing across network

Install Oracle Client on a Network shared drive

Configure tnsnames.ora and sqlnet .ora files

 

Install Oracle client on a PC running NT

  1. For setting up Oracle Client, double click WinNT.bat located at the Shared drive directory

2. Open Start Menu > Settings > Control Panel > System > Environment

[Ex: ; N:\WINAPPS\ORANT\BIN ]

 

Install Oracle Client on PC running windows 95/98

  1. Double Click Win98.bat located in the Network shared drive directory

2. Add Oracle client "bin" directory path to the PATH variable in Autoexec.bat file

[Ex: PATH C:\wondows;N:\winapps\orant\bin ]
  1. Reboot the PC to have the new path take effect.

 ------------------------------------------------------------------------------------

 Note: The scripts are my personal use. You can modify according to your env and use it.