Shell Programming and Scripting

Good..

we are not sure which one is the DB we are looking for

so u can manually try any of the following.

Code:

 
/dba58/d001/app/oracle/product/817/bin/sqlplus

or

Code:

 
/dba58/d001/app/oracle/product/816/bin/sqlplus

you can try the below script where it will connect to an oracle database and execute the query
sqlplus username/password@DB <<EOF
@/dir/home/sqlfilename.sql;
exit;
EOF

I know the database instance which I am trying to connect to.
Is there a way available which I can use to exactly findout the location of sqlplus which i shld use to connect

$ /dba58/d037/staging/sqlplus
/dba58/d037/staging/sqlplus: cannot execute
$ /dba58/d034/app/oracle/product/920/bin/sqlplus
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

Usualy oracle_home/bin but in ur case it does not exist.

As of my knowledge u can't find based on instance name which "sqlplus" to use.

try manually all sqlplus exe's which are under bin directory.

You should really ask the database administrator.

Otherwise you can try to guess it in the following way:

You found:this is an indication that three Oracle clients (and perhaps servers) are installed:
You should use a client with a version greater or equal to the version of the server instance you are going to connect. Even better: match the client version to the server version.
As a start, try to connect with sqlplus 9.20 then learn the server version (you should see a greeting banner).

What do you need:
export ORACLE_HOME=/dba58/d034/app/oracle/product/920
export PATH=PATH:$ORACLE_HOME/bin

Check if the file $ORACLE_HOME/network/admin/tnsnames.ora exists.

Then:
sqlplus user/password@dbname