/build/static/layout/Breadcrumb_cap_w.png

Software Deployment Question


Oracle Instant Client ODBC V12.2.0.1a.msi

11/20/2019 162 views

Hello,

i want to make a silent installation from Oracle Instant Client, because i want to add a first data source with Name "Test1" an an TNS Servive name "XYZZ" and second data source with Name "Test2" an an TNS Servive name "ABCDEEE"

Is this possible in slient installation with parameter? 


Thank you very much?

0 Comments   [ + ] Show comments

Comments


All Answers

2

It's been a while since I've made a package for Oracle but if they still use the TNSNAMES.ORA config file, you'll have to first run the MSI silently, then have the install point to the ORA file with the data sources setup in it.

One trick we used to do is have the ORA file posted on a server share and instead of distributing the file to all the PC's whenever the DBA's would update it, the DBA's would update the single file and it would instantly be available by their users.

Answered 11/20/2019 by: vjaneczko
9th Degree Black Belt

2

It is foolish in the extreme to have local TNSNAMES.ORA on every machine, for precisely the reason outlined above. 

Just find the registry entry that points to the location of the file - I can't recall it off the top of my head - and add that to your transform. You *are* using a transform, right?

Having said that, the OP is asking about data sources: TNSNAMES.ORA deals with host names, not data sources.

The simplest route is to add a system/machine-based (rather than a user-based) data source, export the resulting registry branch as a .REG then import that into your transform (or manually add the registry data to it if you're feeling particularly masochistic). For 32-bit data sources, it'll be in HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI somewhere. 64-bit will be in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI.

Answered 11/21/2019 by: VBScab
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share