How to connect oracle from unix

Shell Programming and Scripting
1

Hi All,

I am trying to connect oracle from unix mechine but i am getting an error like

Ksh: sqlplus: not found

Any one please tell me how to connect oracle from unix mechine.
I would appreciate if any one send the query.

Regards,
Ravi kumar.Gongati

2

$ . oraenv
ORACLE_SID = [oracle] ? demo1
$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 24 18:03:58 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name:

hope this help :slight_smile:

3

The sqlplus executable isn't in your PATH specification. Make sure that in your environment the following variables are correctly set:

ORACLE_HOME
ORACLE_SID
PATH (must include $ORACLE_HOME/bin)

Then you can connect with sqlplus.

Sourcing the oraenv like invinzin21 said could be a starting point, but I think that oraenv doesn't set the PATH variable for you.

Otherwise, you must provide the full path to the sqlplus executable:

$ORACLE_HOME/bin/sqlplus user/pass