troubleshooting Question

Error 14 initializing SQL*Plus

Avatar of chalie001
chalie001 asked on
DatabasesOracle DatabaseSQL
4 Comments1 Solution432 ViewsLast Modified:
hi am geting this error when starting my oracle database am in window 7 i did the following

C:\Users\rdp>SQLPLUS /NOLOG

SQL*Plus: Release 11.1.0.7.0 - Production on Sun Apr 16 08:29:03 2017

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

SQL> CONNECT /AS SYSDBA
ERROR:
ORA-12560: TNS:protocol adapter error


SQL> HOST
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\rdp>SET ORACLE_HOME=C:\app\oracle\product\12.1.0\dbhome_1

C:\Users\rdp>SQLPLUS /NOLOG
Error 14 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

C:\Users\rdp>cd ..

C:\Users>cd ..

C:\>set
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\rdp\AppData\Roaming
CLIENTNAME=DESMAND-PC
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=VMWIN7-PC
ComSpec=C:\Windows\system32\cmd.exe
FORMS_USERNAME_CASESENSITIVE=1
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Users\rdp
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_45
LD_LIBRARY_PATH=C:\Oracle\Middleware\FRHome\lib
LOCALAPPDATA=C:\Users\rdp\AppData\Local
LOGONSERVER=\\VMWIN7-PC
NUMBER_OF_PROCESSORS=4
ORACLE_HOME=C:\app\oracle\product\12.1.0\dbhome_1
OS=Windows_NT
Path=C:\Oracle\Middleware\FRHome\jdk\bin;C:\Oracle\Middleware\FRHome\bin;C:\app\
oracle\product\12.1.0\dbhome_2\bin;C:\app\oracle\product\12.1.0\dbhome_1\bin;C:\
Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\Windows
PowerShell\v1.0\;C:\oracle\Middleware\forms;C:\oracle\Middleware\bin;C:\Program
Files\Java\jre7\bin;C:\javajdk\jdk1.7.0_79\bin;C:\Oracle\Middleware\FRHome\opmn\
bin;C:\Oracle\Middleware\FRHome\opmn\lib;C:\Oracle\Middleware\FRHome\perl\bin;C:
\jre\bin;C:\app\oracle\jdk;
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 94 Stepping 3, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=5e03
ProgramData=C:\ProgramData
ProgramFiles=C:\Program Files
ProgramFiles(x86)=C:\Program Files (x86)
ProgramW6432=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC=C:\Users\Public
SESSIONNAME=RDP-Tcp#0
SystemDrive=C:
SystemRoot=C:\Windows
TEMP=C:\Users\rdp\AppData\Local\Temp
TMP=C:\Users\rdp\AppData\Local\Temp
USERDOMAIN=VMWin7-PC
USERNAME=rdp
USERPROFILE=C:\Users\rdp
windir=C:\Windows
windows_tracing_flags=3
windows_tracing_logfile=C:\BVTBin\Tests\installpackage\csilogfile.log

C:\>set ORACLE_HOME=C:\app\oracle\product\12.1.0\dbhome_1

C:\>SQLPLUS /NOLOG
Error 14 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros