The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > OS Specific Forums > HP-UX
Google UNIX.COM


HP-UX HP-UX (Hewlett Packard UniX) is Hewlett-Packard's proprietary implementation of the Unix operating system, based on System V.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
sqlplus call JohnZ1385 UNIX for Dummies Questions & Answers 1 06-05-2008 07:48 AM
Call sqlplus in the shell script beaniebear Shell Programming and Scripting 3 05-13-2008 06:30 AM
how to differentiate system call from library call muru UNIX for Advanced & Expert Users 2 07-19-2007 08:20 PM
Sqlplus LiquidChild Shell Programming and Scripting 9 06-01-2007 08:22 AM
Sqlplus antkiu Shell Programming and Scripting 4 09-13-2006 09:36 PM

Reply
 
LinkBack Thread Tools Display Modes
  #8 (permalink)  
Old 04-03-2008
vbe vbe is offline
Registered User
 

Join Date: Sep 2005
Location: Switzerland
Posts: 430
Lets start all again.. with vino's addition:
What do you know about unix in general? (may help us understand your pain... and answer accordingly...)

vino suggest you set some env variable:
the best for you in this case is to edit using vi your .profile
on a standard HP system you should be using ksh (or posix..)
so in your home directory do a vi of .profile:
look for this line:
# Set up the search paths:

#### and add now:
ORACLE_HOME=/usr/oracle/u01/8.1.7
#### and complete the PATH:
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME PATH

### save -> :wq
now execute . ./.profile
env
you should see the modified path and the new variable
which sqlplus should say /usr/oracle/u01/8.1.7/bin/sqlplus (If you are sure its in that directory...)
Reply With Quote
Forum Sponsor
  #9 (permalink)  
Old 04-03-2008
Registered User
 

Join Date: Jun 2006
Posts: 154
Helpful people: Please also take note of the fact that he is using bash (as can be seen from his original post), and he is being instructed to add things to korn shell config files.
Reply With Quote
  #10 (permalink)  
Old 04-03-2008
...@...
 

Join Date: Feb 2004
Location: NM
Posts: 3,502
Shawn -

In HPUX /sbin/sh usually points to ksh by default. Most bash installation are in places like /usr/local/bin. This does not mean that /sbin/sh could not point somewhere else, but you have to assume ksh or a POSIX Bourne-like shell.
Reply With Quote
  #11 (permalink)  
Old 04-03-2008
vbe vbe is offline
Registered User
 

Join Date: Sep 2005
Location: Switzerland
Posts: 430
(ant B.11.11 U 9000/800 168921511 unlimited-user license
ant:/sbin $ file sh
sh: PA-RISC1.1 shared executable
ant:/sbin $ file /usr/bin/sh
/usr/bin/sh: PA-RISC1.1 shared executable dynamically linked
ant:/sbin $ file /usr/bin/ksh
/usr/bin/ksh: PA-RISC1.1 shared executable dynamically linked
ant:/sbin $

/sbin/sh is by default only used by root and is pure bourne shell(not dynamically linked), the reason in when in maintenance level or single user you may very well have nothing more than / mounted...
this said it doesnt change anything to the syntax given...
Reply With Quote
  #12 (permalink)  
Old 04-07-2008
theodore's Avatar
Registered User
 

Join Date: Apr 2008
Posts: 5
thanks guys for your answers.

vbe as you understand i use unix only for my work and the only things i know are from college 3-4 years ago.so....please do answer me accordingly!

by default the machine points at sh but i used ksh to write what vino instructed
i will these new things and we'll see
thanks talk you soon!
Reply With Quote
  #13 (permalink)  
Old 04-25-2008
Registered User
 

Join Date: Oct 2007
Posts: 5
What does running this:

/usr/oracle/u01/8.1.7/bin/sqlplus

at the command line give you?
Reply With Quote
  #14 (permalink)  
Old 04-25-2008
Registered User
 

Join Date: Oct 2007
Posts: 5
Also, if you have significant permissions, try:

find /usr/oracle/u01/8.1.7 -name sqlplus
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes




All times are GMT -7. The time now is 08:58 PM.


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