How to connect oracle from unix - Shell Programming and Scripting

ravi gongati · #1 (**permalink**) 03-24-2008

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

invinzin21 · #2 (**permalink**) 03-24-2008

$ . 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

robotronic · #3 (**permalink**) 03-24-2008

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

Code:

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:

Code:

$ORACLE_HOME/bin/sqlplus user/pass

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to connect ORACLE using PERL	Vijayakumarpc	Shell Programming and Scripting	1	02-27-2008 04:20 AM
How to connect to oracle ??	divyesh shah	Shell Programming and Scripting	2	01-04-2007 12:40 AM
HOw to connect oracle using ksh and perl script	chendra.putta	Shell Programming and Scripting	3	10-16-2006 08:30 PM
Oracle or Applmgr users can not connect	aalshafiy	HP-UX	1	04-10-2006 04:36 AM
connect to Db2 thru Unix	ranj@tcs	Shell Programming and Scripting	3	04-05-2005 06:11 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode