Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Vinesh.

Asked: October 13, 2020 - 6:33 am UTC

Answered by: Connor McDonald - Last updated: October 14, 2020 - 4:15 am UTC

Category: PL/SQL - Version: 19c

Viewed 100+ times

You Asked

OS: Windows
Installation: Silent Installer(Using a response file)

Oracle 19c SE2 Installation creates three files(TNSnames.ora, listener.ora and SQLNet.ora) in its default location (Unzip Location\network\admin).
If Unzip Location is C:\dbhome then these files location would be C:\dbhome\network\admin.

But if an environment variable(TNS_ADMIN) is set then it creates these three files over there. Is there a way, it should always create in its default location rather TNS_ADMIN one.

and we said...

You can specify *some* variables on the command line, eg

./runInstaller -ignoreSysPrereqs -ignorePrereq -waitforcompletion -showProgress -silent ORACLE_HOME=%ORACLE_HOME% etc


but I'm not sure if TNS_ADMIN is one of them. If not, I think the only way to achieve this would be to unset TNS_ADMIN before running the silent install. So if you were doing this in a batch file you could do something like

set PREV_TNS=%TNS_ADMIN%
set TNS_ADMIN=
[run silent install]
set TNS_ADMIN=%PREV_TNS%


or similar

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database