Re: Oracle10g on LinuxxFedora 2) - SQLPLUS Problem

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.