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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of rjamya Sent: Monday, November 07, 2005 6:55 AM To: HELMUT.DAIMINGER@xxxxxx Cc: oracle-l@xxxxxxxxxxxxx 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@xxxxxx> 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