Re: Oracle10g on LinuxxFedora 2) - SQLPLUS Problem

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,

--Eric

Jim Smith wrote:
> In message <1160794999.826231.14730_at_m73g2000cwd.googlegroups.com>,
> PowerLifter1450_at_gmail.com writes
> >I seemed to have installed Oracle 10g R! on Linux Fedor Core 2
> >successfully. However, whn I siwtch directories to $cd ORACLE_HOME/bin
> >and type $sqlplus I just get another $prompt, no SQL> promt (and no
> >error message). A starter database was not installed, if that maters.
> >Any clues about why this is happening would be much appreicated. Thanks!
> >
> IF you are literally typing $sqlplus, then you are trying to run a
> command whose name is contained in the environment variable "sqlplus".
> Since sqlplus is unassigned, you are effectively just hitting return at
> the prompt.
>
>
> [jim_at_thoth bin]$ $sqlplus
> [jim_at_thoth bin]$
>
> If you type sqlplus, you should get
>
> [jim_at_thoth bin]$ sqlplus
> -bash: sqlplus: command not found
>
> because the current directory isn't on the path.
>
> If you type ./sqlplus you should get
>
> [jim_at_thoth bin]$ ./sqlplus
> Error 6 initializing SQL*Plus
> Message file sp1<lang>.msb not found
> SP2-0750: You may need to set ORACLE_HOME to your Oracle software
> directory
>
> What you should do is
>
> [jim_at_thoth jim]$ . oraenv
> ORACLE_SID = [jim] ?
> ORACLE_HOME = [/jbs/opt/oracle] ? /jbs/opt/oracle/product/10.2.0/db_1
> [jim_at_thoth jim]$ sqlplus
>
> SQL*Plus: Release 10.2.0.2.0 - Production on Sat Oct 14 09:07:54 2006
>
> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>
> Enter user-name:
>
> You won't be able to do anything without a database.
> Use dbca to create a database before you go any further.
>
> --
> Jim Smith
> I'm afraid you've mistaken me for someone who gives a damn.
Received on Sat Oct 14 2006 - 18:04:22 CDT