Software Deployment Question

Oracle Instant Client ODBC V12.2.0.1a.msi

11/20/2019 343 views


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


All Answers


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


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

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ