oracle_question
来源:互联网 发布:nginx errorlog 编辑:程序博客网 时间:2024/04/30 18:20
ERROR:ORA-01034 ORACLE notavailable
SOLUTIONS: 1、lsnrctlstart
2、sqlplus /nolog
3、conn / as sysdba;
4、startup
ERROR:中文乱码
SOLUTION:
Vim /etc/profile
插入一下内容:
exportORACLE_HOME=/usr/lib/oracle/11.2/client64
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:/usr/local/lib
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
exportNLS_LANG=AMERICAN_AMERICA.UTF8
注销
ERROR:lsnrctl start 报错:
message 1070 not found; No message file forproduct=network, facility=TNSTNS-12545: Message 12545 not found; No messagefile for product=network, facility=TNS
TNS-12560: Message 12560 not found; No messagefile for product=network, facility=TNS
TNS-00515: Message 515 not found; No message file for product=network,facility=TNS
Linux Error: 2: No such file or directory
SOLUTION:source /home/oracle/.bash_profile
ERROR: ORA-01031: insufficient privileges