RE: New Unix user needs to use sqlplus
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <rjamya@xxxxxxxxx>, <HELMUT.DAIMINGER@xxxxxx>
- Date: Mon, 7 Nov 2005 07:06:32 -0500
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
Other related posts:
