hello everyone,

I'm new to linux as well as oracle 10g. Yesterday I installed 10g on
my virtual machine. Everything was working fine but when I restarted
my machine, I dont know how to start the database now. Can anybody
help me in this regard? Thank you so much.

Regards
Parul

On Jan 30, 10:46 am, ms.pa...@gmail.com wrote:
> hello everyone,
>
> I'm new to linux as well as oracle 10g. Yesterday I installed 10g on
> my virtual machine. Everything was working fine but when I restarted
> my machine, I dont know how to start the database now. Can anybody
> help me in this regard? Thank you so much.
>
> Regards
> Parul

See metalink Note:222813.1 for some ideas on how to automate oracle
startup on linux. Some people don't like to automate the startup.

For simply starting up Oracle, log in as the oracle owner and type
in:

sqlplus "/ as sysdba"
startup
exit

lsnrctl startup

Poke around on oracle.com for Oracle By Example, and check
the docs for 2-Day DBA.

Also see http://www.dbaoracle.net/readme-cdos.htm

jg
--
@home.com is bogus.
http://www.dba-oracle.com/images/mot...leadership.jpg

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?

Thank you

Regards
Parul

On Jan 30, 12:17 pm, ms.pa...@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

On 30 Jan 2007 12:17:29 -0800, ms.parul@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?
>
>Thank you
>
RTFM
or at least google your (very common) error(s)
........
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
remove NSPAM to email

On 30 Jan, 20:17, ms.pa...@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?
>
> Thank you
>
> Regards
> Parul

When logged in as the Oracle software owner ("oracle" presumably),
type:

$ . oraenv

And respond to the ORACLE_SID prompt. If the SID exists in /etc/
oratab, your ORACLE_HOME and PATH environment variables will then be
set accordingly. Then, simply:

$ sqlplus / as sysdba

SQL> startup;

HTH

-g