computer suddenly power off and restart, then log in Oracle again suddenly reported an error
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
has been good until now, suspect that it is caused by installing two versions (I installed versions 12 and 11)?
I simply changed the configuration of all Oracle environment variables to 11 (although both were configured before).
after the change can be seen in CMD:
remember to restart the computer for the configuration to take effect ~!
C:\Users\Administrator>set
CLASSPATH=.;C:\Program Files\Java\jdk1.8.0_181\lib\dt.jar;C:\Program Files\Java\jdk1.8.0_181\lib\tools.jar;C:\Program Files\Java\jedis-2.9.0.jar;
JAVA_HOME=C:\Program Files\Java\jdk1.8.0_181
ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1
Path=C:\Program Files (x86)\Common Files\Oracle\Java\javapath;D:\app\Administrator\product\11.2.0\dbhome_1\BIN;Files\Java\jdk1.8.0_181\lib;D:\MongoDB\Server\4.0\bin;
TNS_ADMIN=F:\app\Administrator\virtual\product\12.2.0\dbhome_1\network\admin
#这里的12版本的没有改过来,但是不知道为啥还是可以运行的
div>