Linux Oracle 环境变量配置（注意ORACLE_SID及alias部分按需修改）

Linux Oracle 环境变量配置（注意ORACLE_SID及alias部分按需修改） ~/.bash_profile

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/bin:$PATH:/usr/local/rlwrap/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/oracm/lib:$ORACLE_HOME/lib 
export LIBPATH=$LIBPATH:$ORA_CRS_HOME/lib:$ORACLE_HOME/lib 
export EDITOR=vi
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
alias sqlplus='rlwrap sqlplus'
alias lsnrctl='rlwrap lsnrctl'
alias rman='rlwrap rman'
alias rm='rm -i'
alias ss="sqlplus '/as sysdba'" 

$ORACLE_HOME/sqlplus/admin/glogin.sql

set lines 150
set pagesize 1000
set long 9999
define_editor=vi
set sqlprompt "_user'@'_connect_identifier> "