Re: Oracle10g on LinuxxFedora 2) - SQLPLUS Problem

I has asked a co-worked who runs all of out Linux/Unix systems, has an Oracle OCP, and recently got a development job with Google - he is just as puzzled as us.

[oracle_at_localhost oracle]$ which sqlplus # yields: ~/product/10.1.0.3/bin/sqlplus
[oracle_at_localhost oracle]$

Thanks for your help with this!

Jim Smith wrote:
> In message <1160867061.763588.152020_at_m7g2000cwm.googlegroups.com>,
> PowerLifter1450_at_gmail.com writes
> >Thanks for the reply Jim. I wasn't actually typing the $ before
> >sqlplus. If I do
> >
> >[oracle_at_localhost oracle]$ sqlplus
> >or
> >[oracle_at_localhost oracle]$ cd $ORACLE_HOME
> >[oracle_at_localhost 10.1.0.3]$ cd bin
> >[oracle_at_localhost bin]$ sqlplus
> >
> >I just get another $ prompt either way.
> >
> >When I do
> >[oracle_at_localhost oracle]$. oraenv I get:
> >
> >ORACLE_SID = [orcl] ?
> >ORACLE_HOME = [opt/oracle] ?
> >
> >In my bash profile /opt/oracle is set as the ORACLE_BASE and
> >ORACLE_HOME = $ORACLE_BASE/product/10.1.0.3
> >
> >I assume the orenv needs to be changed? How would I go about doing
> >that? Thanks,
> >
> I'm still puzzled as to why you are not getting any feedback from
> sqlplus. what happens if you type "which sqlplus"
>
> oraenv is fine. It is used to set up the environment to use a particular
> database but until you have a database it can't look up the appropriate
> settings (ORACLE_HOME) so it prompts you for them.
>
> --
> Jim Smith
> I'm afraid you've mistaken me for someone who gives a damn.
Received on Sun Oct 15 2006 - 21:37:31 CDT