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>
Read More:
- Failed to create Oracle Oracle home user solution appears in oracle12c installation
- Oracle12c client32 bit installation error: [ins-20802] Oracle net configuration assistant failed
- The solution of PL / SQL can’t connect to the remote server after installing Oracle locally
- Oracle database file is damaged, Error:ORA-01033 :ORACLE initialization or shutdown in progress
- Solution to “initializing the Oracle asmlib driver: [failed]”
- A series of errors encountered in connecting to the database using Oracle SQL developer
- The solution of shared memory real does not exist when Oracle login
- Solution of invalid username / password; login denied error in Oracle Database Foundation
- Ie8.0 reports Oracle error 1403 error after logging into Oracle EBS
- After Oracle 11g is installed, SQL_ Plus.exe The problem of Chinese garbled in command window
- Solution to Oracle error 17002
- Oracle complete uninstall manual
- python cx_Oracle.DatabaseError: Error while trying to retrieve text for error ORA-01804
- Solution of Oracle error 6550
- Oracle 12C installation process related errors and Solutions
- Can’t initialize OCI. Error – 1 appears in toad for Oracle
- JDBC connection to Oracle: listener used the connection with the following error: ora-12505
- Win7_ Dim-00019 appears after x64 installation of Oracle11g
- Oracle database missing init.ora Solutions