Sign (?) represents the ORACLE_HOME environment variable
eg
sql> ALTER tablespace TEMP ADD datafile '?/dbs/temp02.dbf ' SIZE 200M;
Sign (@) represents the ORACLE_SID environment variable
eg
sql> ALTER tablespace tablespace_name ADD datafile [email protected]
------Oracle Software Runtime Environment variables
--oracle_trace trace shell script execution during installation, the underlying principle is: implicit settings set-x
Oracle_trace=t Enable shell tracing
Oracle_trace= is set to NULL, it does not track
--tns_admin Oracle Net service profile, it seems that many people do not know this variable, sometimes monitoring management exception, that is, there is no reasonable setting this variable,
eg
tns_admin= $ORACLE _home/network/admin
--TWO_TASK Specifies the default connection label (which needs to be configured in Tnsnames.ora), and if this variable is set, it can be quickly connected to the database:
Two_task=lixora
Sql> CONNECT Lixora
Enter Password:lixora
----------UNIX Environment variables
--classpath used with Java applications
Classpath= $ORACLE _home/jre/lib: $ORACLE _home/jlib/* There is no default setting and must contain the following settings */
--path used by the shell to locate executable programs; Shel through this variable to determine the executable program
eg
PATH=/BIN:/USR/BIN:/USR/LOCAL/BIN:/USR/BIN/X11: $ORACLE _home/bin: $HOME/bin:
The Oracle environment variables and identities that you are not too aware of
