当前位置: 首页 > Linux

LinuxOracle环境变量配置(注意ORACLE_SID和alias根据需要修改)

时间:2023-04-07 00:49:57 Linux

LinuxOracle环境变量配置(注意ORACLE_SID和alias根据需要修改)~/.bash_profileexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/产品/12.1.0/dbhome_1exportORACLE_SID=PRODexportPATH=$ORACLE_HOME/bin:$PATH:/usr/local/rlwrap/binexportTNS_ADMIN=$ORACLE_HOME/network/adminexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/oracm/lib:$ORACLE_HOME/lib导出LIBPATH=$LIBPATH:$ORA_CRS_HOME/lib:$ORACLE_HOME/lib导出EDITOR=viexportORACLE_TERM=xtermexportNLS_LANG=AMERICAN_AMERICA.AL32UTF8exportNLS_DATE_FORMYAT='Y-MM-DDHH24:MI:SS'aliassqlplus='rlwrapsqlplus'aliaslsnrctl='rlwraplsnrctl'aliasrman='rlwraprman'aliasrm='rm-i'aliasss="sqlplus'/assysdba'"$ORACLE_HOME/sqlplus/admin/glogin.sqlsetlines150setpagesize1000setlong9999define_editor=visetsqlprompt"_user'@'_connect_identifier>"