RE: New Unix user needs to use sqlplus

add the following to the ixos user's .profile  

export ORACLE_SID=<oracle's sid>
export ORAENV_ASK=NO
. <ORACLE_HOME>/bin/oraenv  

Note: DON'T forget the leading period on the oraenv line or it will not permanently modify the users environment (aka the PATH).  

If your using C shell, add to .login  

setenv ORACLE_SID <oracle's sid>
setenv ORAENV_ASK NO
source <ORACLE_HOME/bin/coraenv  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: Monday, November 07, 2005 6:55 AM
To: HELMUT.DAIMINGER_at_wwk.de
Cc: oracle-l_at_freelists.org
Subject: Re: New Unix user needs to use sqlplus

run the oraenv script as the ixos user, make sure oraenv script is available to be run by that user. Then run sqlplus ... you may optionally need to set-up PATH environment variable.

Raj

On 11/7/05, Daiminger, Helmut <HELMUT.DAIMINGER_at_wwk.de> wrote:

        Hi!

        we are currently installing an archiving product by ixos. The Unix user ixos needs to connect to the Oracle database. What needs to be set to enable the ixos user to do so (e.g. use sqlplus). The Oracle installation is owned by ora10.

        This is 10.2 on HP-UX 11i.

	Thanks, 
	Helmut 

-- 
------------------------------
Useful Links: FAQ1, FAQ2, RTFM, STFW, ORA-600, ORA-7445


--
http://www.freelists.org/webpage/oracle-l