Oracle SQLPLUS
 

hi.. i'm happing a difficult. i learn oracle .. as usual. i use oracle
in windows platform.. but i my love is on linux..
so i try to install
it on my box. i'm using oshirix squeeze (debian). i also record how i
manage to install oracle inside my box

here the link: http://www.masokis.com/blog/linux-diy-database-oracle-10-xe-oshirix-squeeze

i
can access in webpanel.. it work fine. i also install sqldeveloper..
and the connection between this tool work fine.

now.. i want to use sql*plus. but when typing it into terminal... it
could not be found .

look at my output:
root@OshirixNET:/home/masokis#
sqlplus
bash: sqlplus: command not
found

i try to seach in apt, but it's found the different one..
root@OshirixNET:/home/masokis#
apt-cache search sqlplus
sqlline -
JDBC command-line utility for issuing SQL

i take look into
$path..
it seem it not be setup yet:
masokis@OshirixNET:~$ echo
$PATH
/home/masokis/.dist/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/sbin:/usr/local/bin:/usr/games:.


then i setup the path..using this command;
masokis@OshirixNET:~$
nano /etc/profile

to PATH="/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/sbin:/usr/local/bin:/usr/games:/usr/lib/oracle/xe/app/oracle/product/10.2.0"

save! but when i echo the path again.. the
/usr/lib/oracle/xe/app/oracle/product/10.2.0 are not been show...
as like this:

masokis@OshirixNET:~$ echo $PATH
/home/masokis/.dist/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/sbin:/usr/local/bin:/usr/games:


hermm.. i dont know what wrong.. maybe because the path (because in
windows, i need to set the path) or the installation that not come with
sqlplus....
hoping someb0dy could help me here.... thanks for read
& i very appriciate if somebody give a hand.
--
>> HTTP://WWW.MASOKIS.COM <<

Oracle SQLPLUS
 

MASOKIS:
>
> hi.. i'm happing a difficult. i learn oracle .. as usual. i use oracle in
> windows platform.. but i my love is on linux..

:)

> then i setup the path..using this command;
> masokis@OshirixNET:~$ nano /etc/profile
>
> to
> PATH="/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/sbin:/usr/local/bin:/usr/games:/usr/lib/oracle/xe/app/oracle/product/10.2.0"
> save! but when i echo the path again.. the
> /usr/lib/oracle/xe/app/oracle/product/10.2.0 are not been show... as like
> this:
>
> masokis@OshirixNET:~$ echo $PATH
> /home/masokis/.dist/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/sbin:/usr/local/bin:/usr/games:

Did you log in again after editing /etc/profile or anything to that
effect? Editing a file will not magically alter your current
environment. Sourcing the file is the quickest way to adapt your current
shell:

. /etc/profile

J.
--
If I could travel in time I would show my minidisc to the Romans and
become Caesar until the batteries ran out.
[Agree] [Disagree]
<http://www.slowlydownward.com/NODATA/data_enter2.html>

Oracle SQLPLUS
 

oh.. it was a missing part. now i already try it. the path now echo as inside the file.

masokis@OshirixNET:~$ . /etc/profile
masokis@OshirixNET:~$ echo $PATH
/home/masokis/.dist/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/sbin:/usr/local/bin:/usr/games:/usr/lib/oracle/xe/app/oracle/product/10.2.0:.


but i still cannot running sqlplus in terminal.. wondering.. where the sqlplus ?

masokis@OshirixNET:~$ sqlplus
bash: sqlplus: command not found

On Sat, Sep 25, 2010 at 1:39 AM, Jochen Schulz <ml@well-adjusted.de> wrote:

MASOKIS:

>

> hi.. i'm happing a difficult. i learn oracle .. as usual. i use oracle in

> windows platform.. but i my love is on linux..



:)



> then i setup the path..using this command;

> masokis@OshirixNET:~$ nano /etc/profile

>

> to

> PATH="/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/sbin:/usr/local/bin:/usr/games:/usr/lib/oracle/xe/app/oracle/product/10.2.0"

> save! but when i echo the path again.. the

> /usr/lib/oracle/xe/app/oracle/product/10.2.0 are not been show... as like

> this:

>

> masokis@OshirixNET:~$ echo $PATH

> /home/masokis/.dist/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/sbin:/usr/local/bin:/usr/games:



Did you log in again after editing /etc/profile or anything to that

effect? Editing a file will not magically alter your current

environment. Sourcing the file is the quickest way to adapt your current

shell:



. /etc/profile



J.

--

If I could travel in time I would show my minidisc to the Romans and

become Caesar until the batteries ran out.

[Agree] * [Disagree]

* * * * * * * * <http://www.slowlydownward.com/NODATA/data_enter2.html>


-----BEGIN PGP SIGNATURE-----

Version: GnuPG v1.4.10 (GNU/Linux)



iEYEARECAAYFAkyc4k4ACgkQ+AfZydWK2zm1zQCgsZehBAvELF vNvxNO/t5aHX2L

5j8AnjBNKsZO0FCVV5XSdyDJvdtdh4ua

=LRZU

-----END PGP SIGNATURE-----




--
>> HTTP://WWW.MASOKIS.COM <<

Oracle SQLPLUS
 

MASOKIS:
>
> oh.. it was a missing part. now i already try it. the path now echo as
> inside the file.
>
> masokis@OshirixNET:~$ . /etc/profile
> masokis@OshirixNET:~$ echo $PATH
> /home/masokis/.dist/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/sbin:/usr/local/bin:/usr/games:/usr/lib/oracle/xe/app/oracle/product/10.2.0:.
>
> but i still cannot running sqlplus in terminal.. wondering.. where the
> sqlplus ?

Run the following and change your PATH again:

find /usr/lib/oracle/ -name sqlplus

J.
--
My medicine shelf is my altar.
[Agree] [Disagree]
<http://www.slowlydownward.com/NODATA/data_enter2.html>