Re: how to restart oracle 10g on linux

On Jan 30, 12:17 pm, ms.pa..._at_gmail.com wrote:
> hi thank you so much for your response but unfortunately it says
> "bash : sqlplus : Command not found"
>
> In windows, we used to do it using services/Administrative tools . So
> in linux do we have such kind of utility?
>

Maybe, but for the most part I only know command lines.

In bash, the shell searches your path for what you tell it to execute. If the command is not found, that means something is missing from your path.

Look for a file called oraenv and execute it (might be in /usr/local/ bin,
I don't have a linux around to check). Basically, what you need to do is set the environment variables ORACLE_SID and ORACLE_HOME, and add the place that has the executables to your path, probably $ORACLE_HOME/bin.

You may want to add the setups for these in your .profile or /etc/profile or whatever your particular shell uses. If you don't remember what they are, search for the exact file name oracle (that's the executable, not a directory: find / -name "oracle" -type f),
and that will be in $ORACLE_HOME/bin. You may see things like spfileORCL.ora in the $ORACLE_HOME/dbs directory, which would clue you in that ORCL is your ORACLE_SID.

Be sure and always post your exact version of Oracle and your operating system/platform (and other relevant things like the version of which virtual machine).

You might also find http://www.dizwell.com/prod/node/3 helpful.

jg

--
@home.com is bogus.
select fz_reference from albums
intersect
select fz_reference from mst3k
http://home.epix.net/~eichler/mst3k/fzmst3k.htm