The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here.

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

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-24-2008
Registered User
 

Join Date: Mar 2008
Posts: 15
Question How to connect oracle from unix

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
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 03-24-2008
Registered User
 

Join Date: Dec 2007
Location: Philippines, Cebu City
Posts: 67
$ . 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
Reply With Quote
  #3 (permalink)  
Old 03-24-2008
robotronic's Avatar
Can I play with madness?
 

Join Date: Apr 2002
Location: Italy
Posts: 370
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
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes




All times are GMT -7. The time now is 02:20 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0