Oracle Client Installation

install oracle client from the following path.

\\fs1\Shared\IT\Oracle\Oracle client\win32_11gR2_client\client

>Click on "Set Up" file [Will open up a Terminal, please wait for it to finish until you get a pop up]

> Click Custom

> Click Next, Next, Next

> Check boxes for

Oracle Net, Oracle Connection Manager, Oracle Listener, Oracle ODBC Driver, and

Oracle SQL Developer

> Click Next, Finish

> Check "Perform Typical Configuration" for net listener.

> Drag the TNSnames.ora file onto the desktop

Copy TNSnames.ora file to c:\app\Munckinadmin\product\11.2.0\client_1\NETWORK\ADMIN

Goto c:\windows\syswow64

>Run odbcad32 as admin

> On System DNS add oracle oraclient11g_home11 driver

Configure Driver

> Data Source Name: PMUNCI

> Description: PMUNCI

> Tns Service Name: PMUNCI

> User ID: bolinf

> Uncheck - Enable Query Timeout

> Click OK

Edit System Regestry as admin

> Go to Windows Search and type "Registry Editor" to open up the app

> Goto HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI\PMUNCI ---> [You can also copy and paste this path]

> Under Password add SSqiZK8S

Testing

> Test connection by running tnsping pmunci on command prompt

> Make sure that you get an "OK" as that ensures the connection is successful. Failure to see the "OK" means that something is wrong. Repeat the process.