Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE Variables Linux bash, please help!

Re: ORACLE Variables Linux bash, please help!

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 11 May 2006 13:42:28 +0200
Message-ID: <e3v7rr$skj$1@news5.zwoll1.ov.home.nl>


Lanying & Manfred schreef:
> Hello
>
> I've installed ORACLE 10g SUSE LINUX 9 Enterprise Edition. User is oracle,
> group oinstall, dba. Works fine. Beeing connected as user oracle, I can
> start sqlplus, em, isqlplus, exp, imp rman. All works fine. I've added a
> new user, let me say codd. I've copied the profile of oracle
> cp /home/oracle/.profile to /home/codd/.profile
> and started the .profile
> . ./.profile
> ORACLE_HOME; ORACLE_BASE, ORACLE_SID, LD_LIBRARY_PATH and PATH is set!
>
> When starting sqlplus, I get a message:
>
> bash sqlplus command not found
>
> I'm a Linux Greenhorn!
>
> I think, nobody should work with Oracle database connected as oracle user!
>
> Please help me!
>
> Lanying

On my RHES3, it's .bash_profile, not .profile. But that depends on your personal likings.

What does which sqlplus say?

And what do you mean with your last remark? Connecting to oracle is not the same as running a Linux account... I run oracle9 (or oracle10r1, oracle10r2) account, but connect as scott, or hr to oracle.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Thu May 11 2006 - 06:42:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US