The default NLS location in 9 i was $ORACLE_HOME/common/nls/admin/data.Įnvironment variable to specify the location of SQL scripts. In a system with both Oracle9 i and 10 g, or a system under version upgrade, you should set ORA_NLS10 for Oracle 10 g and set ORA_NLS33 for 9 i. The default location is $ORACLE_HOME/nls/data.

To correct this, you must unset ORA_EDITION, then reconnect and shutdown the database, then start the database again.Įnvironment variable to specify the locations of the NLS data and the user boot file in SQL*Plus 10.2. When ORA_EDITION is set, a subsequent STARTUP command in the session results in an ORA-38802 error. If no edition is specified in either the CONNECT or SQLPLUS command option, or in ORA_EDITION, SQL*Plus connects to the default edition. If you specify the edition with the CONNECT or SQLPLUS command option, edition= value, it is used instead of ORA_EDITION.

It is also used by SQL*Plus to specify where message files are located.Įnvironment variable to specify the database edition to use. Performs the same function as TWO_TASK on UNIX.Įnvironment variable to specify globalization behavior.Įnvironment variable to specify where SQL*Plus is installed. Windows environment variable to specify a connection string. Not applicable to Windows operating systems. The environment variable may have a different name on some operating systems, such as DYLD_LIBRARY_PATH on Apple Mac OS, LIBPATH on IBM/AIX-5L, and SHLIB_PATH on HP-UX. Table 2-1 Parameters or Environment Variables influencing SQL*Plus Parameter or VariableĮnvironment variable to specify the path used to search for libraries on UNIX and Linux.

Toad sql plus