Manage TNS_ADMIN in env.ora

<<Back to DB Administration Main Page

Managing TNS_ADMIN  Variable in env.ora

Starting from 12cR2 you can manage TNS_ADMIN variable in $ORACLE_HOME/env.ora file 
ls -lrt $ORACLE_HOME |grep env.ora
-rw-r--r--  1 oracle dba   852 Aug 18  2015 env.ora

By default, the $ORACLE_HOME/env.ora is empty. If you leave this file untouched and nothing else is set, the default $ORACLE_HOME/network/admin location is read.


$cat env.ora
# Copyright (c) 2015, Oracle and/or its affiliates. All rights reserved.
#
# NAME
#   env.ora
#
# FUNCTION
#   Oracle ENVironment variables persistency file template
#
# NOTES
#   This is a generic file for defining environment variables.
#   It facilitates the requirement to maintain persistency of environment
#   variables across multiple instances in lieu of setting the variables in
#   the environment.
#
#   Note that setting a variable in the environment takes precedence over its
#   definition in this file.
#
# SYNTAX
#   <ENVIRONMENT VARIABLE>=<VALUE>
#
# PROPOSED RESTRICTION
#   For 12.2, the only valid variable is TNS_ADMIN.
#
# SAMPLE
#   TNS_ADMIN=/gridhome/network/admin
#
#   Possible values: Any valid directory path in which network configuration
#                    files are stored
#   Default: $ORACLE_HOME/network/admin
#