Home » SQL & PL/SQL » Client Tools » Error 6 initializing SQL*Plus (oracle instant client 12102 win10)
Error 6 initializing SQL*Plus [message #656775] Tue, 18 October 2016 10:45 Go to next message
quirks
Messages: 60
Registered: October 2014
Member
Hello,

My sysadmin guided me through the installation process of the oracle instant client for 12c. Which was basicaly copying a folder to C:\Program Files\oraclnt12102 and setting up the environment varables:
ORACLE_HOME
TNS_ADMIN
NLS_LANG
and updating PATH.

When I start sqlplus in the ORACLE_HOME folder everything works fine.
C:\>%ORACLE_HOME%\sqlplus

But if I call it from a different folder (C:\>sqlplus), I get the message:
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

What am I doing wrong (besides using Win10 ^^)
Re: Error 6 initializing SQL*Plus [message #656777 is a reply to message #656775] Tue, 18 October 2016 11:13 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
ORACLE_HOME is not correct

open up Command Window & issue command below

SET

COPY the results then PASTE all back here.
Re: Error 6 initializing SQL*Plus [message #656779 is a reply to message #656775] Tue, 18 October 2016 11:47 Go to previous message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
When I start sqlplus in the ORACLE_HOME folder everything works fine.
C:\>%ORACLE_HOME%\sqlplus
As there is no sqlplus executable in %ORACLE_HOME% directory (it is in %ORACLE_HOME%\bin), I think you have something not standard.

Quote:
Which was basicaly copying a folder to C:\Program Files\oraclnt12102 and setting up the environment varables:
No this is not just that, some keys are created in the registry and other stuff in %SystemDrive%\Program Files.

It should be better you download the Instant client from Oracle site (http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html) and do the correct install.

Previous Topic: Set path in variable
Next Topic: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to
Goto Forum:
  


Current Time: Wed Dec 13 11:46:46 CST 2017

Total time taken to generate the page: 0.32130 seconds