Unable to connect to sqlplus from unix

UNIX for Advanced & Expert Users
1

Hi,

I have been trying to connect to sqlplus the same way I used to do in my earlier company but I get these error messages , please suggest way out -

user name - xyzuser
schema name - xyzschema

[ceadmin@FNPRODCE1:/home/ceadmin]$ sqlplus xyzuser@xyzschema
ksh: sqlplus:  not found.
[ceadmin@FNPRODCE1:/home/ceadmin]$ sqlplus -s xyzuser@xyzschema
ksh: sqlplus:  not found.
[ceadmin@FNPRODCE1:/home/ceadmin]$ man sqlplus
Manual entry for sqlplus not found or not installed.
[ceadmin@FNPRODCE1:/home/ceadmin]$ /sqlplus -s xyzuser@xyzschema<
ksh: /bin/sqlplus:  not found.
[ceadmin@FNPRODCE1:/home/ceadmin]$ /usr/local/bin/sqlplus
ksh: /usr/local/bin/sqlplus:  not found.
2

Where is sqlplus located on the machine (mostly $ORACLE_HOME/bin )? Is that location a part of PATH value?

3

It seems you have not set the Oracle environment yet.

Try:

$ ORAENV_ASK=no
$ . oraenv xyzschema

oraenv is located in the Oracle 'home' bin directory (i.e. /oracle/product/11.2/bin)

4

For older versions of oracle you have to have:

ORACLE_HOME variable defined
$ORACLE_HOME/bin in your PATH variable
ORACLE_SID [optional] defined as your oracle instance name.

# ORACLE_SID is required to use sqlplus this way:
sqlplus username/passwd
#otherwise
sqlplus username/passwd@instance_name
5

If all else fails, try a blunt search to find out where the program resides and by implication whether the Server Administrator has allowed you to see the program. The redirect of the error channel to /dev/null is because you are not the "root" user and will be refused access to numerous directories.

Please post the result of:

find // -type f -name sqlplus -exec ls -ald {} \; 2>/dev/null

If there is more than one version of Oracle on the computer, you may get more than one hit.

6

Another way to find out the the Oracle-home(s) on your box is to look into the file /etc/oratab . The free Oracle-Express databases doesn't ship with oraenv (that should also find in /usr/local/bin) but have the script $ORACLE_HOME/bin/oracle_env.sh to set up your environment.
Its structure is

$ORACLE_SID:$ORACLE_HOME:$START_ORACLE_AUTOMATICALLY