Oracle Instant Client ODBC V12.2.0.1a.msi
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?
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.
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.
