• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Oracle Database Environment Variables and Their Functions

By admin

Oracle Database Environment Variables

Below are some of the most common environment variables used with Oracle Database and their descriptions:

  • NLS_LANG: Specifies the language, territory, and character set of the client environment. The client character set specified by NLS_LANG must match the character set of the terminal or terminal emulator.
  • ORA_NLS10: Specifies the directory where the language, territory, character set, and linguistic definition files are stored.
  • ORA_TZFILE: Specifies the full path and file name of the time zone file. The Oracle Database Server always uses the large time zone file ($ORACLE_HOME/oracore/zoneinfo/timezlrg_number.dat).
  • ORACLE_BASE: Specifies the base of the Oracle directory structure for Optimal Flexible Architecture compliant installations.
  • ORACLE_HOME: Specifies the directory containing the Oracle software.
  • ORACLE_PATH: Specifies the search path for files used by Oracle applications such as SQL*Plus. If the full path to the file is not specified, or if the file is not in the current directory, then the Oracle application uses ORACLE_PATH to locate the file.
  • ORACLE_SID: Specifies the Oracle system identifier.
  • ORACLE_TRACE: Enables the tracing of shell scripts during an installation.
  • ORAENV_ASK: Controls whether the oraenv or coraenv script prompts or does not prompt for the value of the ORACLE_SID environment variable.
  • SQLPATH: Specifies the directory or list of directories that SQL*Plus searches for a login.sql file.
  • TNS_ADMIN: Specifies the directory containing the Oracle Net Services configuration files.
  • TWO_TASK: Specifies the default connect identifier to use in the connect string. If this environment variable is set, then do not specify the connect identifier in the connect string.
  • NLS_OS_CHARSET: Specifies the Oracle character set name corresponding to the UNIX locale character set in which the file names and user names are encoded by the operating system.

UNIX Environment Variables

Below are some of the UNIX environment variables used with Oracle Database:

  • HOME: The home directory of the user.
  • LD_LIBRARY_PATH: Environment variable to specify the path used to search for libraries on UNIX and Linux. The environment variable may have a different name on some operating systems, such as LIBPATH on AIX, and SHLIB_PATH on HP-UX.
  • PATH: Used by the shell to locate executable programs; must include the $ORACLE_HOME/bin directory.
  • TEMP, TMP, and TMPDIR: Specifies the default directories for temporary files; if set, tools that create temporary files create them in one of these directories.

Filed Under: Linux, oracle

Some more articles you might also be interested in …

  1. CentOS / RHEL : How to block incoming and outgoing ports using iptables
  2. Understanding /etc/xinetd.conf file in Linux
  3. How to configure multicast on an IP address (interface)
  4. CentOS / RHEL 6,7 : Why the files in /tmp directory gets deleted periodically
  5. Oracle 12c New Feature – Multi-Threaded architecture of processes
  6. How to Execute Scripts/Commands using /etc/rc.d/rc.local in CentOS/RHEL 7
  7. How to Enable Verbose Logging for VSFTPD
  8. How to move ASM spfile to a different disk group
  9. CentOS / RHEL 7 : Enable NTP to start at boot after fresh install (disable chrony)
  10. How to mount an iso file in Linux

You May Also Like

Primary Sidebar

Recent Posts

  • Basics of client connectivity in Oracle Data Guard configuration
  • ORA-354 ORA-353 and ORA-312: Possible corruption in Online Redo Log File Members in a Redo Log Group
  • How to relocate the redo log files to a different location on disk
  • Oracle Database: Redo log operations (Add/Drop/Change Location)
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary