sqlplus doesnt work on my client workstation 1

[evergreean]

I have a Windows NT Client workstation that I am trying to connect to Oracle 9i on a server.

I installed OracleInstantClient on the workstation but can not get sqlplus to work:


I put the OracleInstantClient and sqlplus in a folder I called: C:\Oracle
and setting my paths such as:
SET PATH=C:\Oracle\OracleInstantClient;%PATH%
SET LD_LIBRARY_PATH=C:\Oracle\OracleInstantClient
SET SQLPATH=C:\Oracle\OracleInstantClient
SET TNS_ADMIN=C:\Oracle\OracleInstantClient
SET ORACLE_SID=mydb

Now when I try the sqlplus comand in my DOS window in the C:\ root directory or even in the C:\Oracle directory it says its not a recognized command:

C:\>sqlplus jones/jones@mydb
'sqlplus' is not recognized as an internal or external command, operable program or batch file.

Please advise.

 

[KenCunningham]

sqlplus resides in the bin directory under your ORACLE_HOME, which doesn't appear to be set above. Set your ORACLE_HOME and include ORACLE_HOME\bin in your path and you should be good to go. If not, post back.

 

[evergreean]

I added as follows:
set ORACLE_HOME=C:\Oracle\ORACLE_HOME\bin

I then tried sqlplus and it gave me the same message saying it is not recognized.

Please advise.

 

[evergreean]

Now it works after I added bin to the Path.

I can now get the SQL*Plus login screen.
Here is the info I have about the database I am connecting to:
ORACLE_HOME /oracle/app/2314
ORACLE_SID kcl
Host id abcd123e

My attempt using the command line:
sqlplus jones/mypassword@//abcd123e/kcl

gives me the message:

ERROR:
ORA-12154: TNS could not resolve connect identifier specified


Please advise.

 

[KenCunningham]

As long as kcl is in the tnsnames.ora file and correctly set up, you should be able to connect using sqlplus username/password, ie without any of the additional notation.

 

[evergreean]

thanks it now works.