oracle_question

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