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 - 14:28:32 CDT
