Make sure your PATH environment variable has an entry that points to the
Oracle bin folder that contains the tnsping and sqlplus executables.
Ie. Something like c:\orant\bin or c:\ora92\bin.

Good luck.


-----Original Message-----
From: martin
[mailto:oracledba-ezmlmshield-x61234924.[Email address protected]
Sent: Monday, July 02, 2007 11:49 PM
To: LazyDBA Discussion
Subject: FW: Re - Sqlplus / TNSPING issue


This is the other variation of the error I am getting.

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

Martin Thomas


-----Original Message-----
From: martin
[mailto:oracledba-ezmlmshield-x19203109.[Email address protected]
Sent: Monday, July 02, 2007 11:44 PM
To: LazyDBA Discussion
Subject: Re - Sqlplus / TNSPING issue

Hi Folks

I am getting an error from windows when I try to instatiate sqlplus or
tnsping from the command line


'sqlplus' is not recognized as an internal or external command, operable
program or batch file.

My windows admin guy messed around with my environmental variables
shortly before I was getting this error.

I tried to set my ORACLE_HOME and TNS_ADMIN variable to no avail.

Plz Help

Martin




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page