Re: Problem after reboot of th machine

From: <fitzjarrell_at_cox.net>
Date: Mon, 16 Jul 2007 09:41:11 -0700
Message-ID: <1184604071.769222.91390@w3g2000hsg.googlegroups.com>

On Jul 16, 9:41 am, david <david.se..._at_gmail.com> wrote:
> Hello, i'm novice on Oracle. I have installed oracle 10 g server on my
> XP machine. After the installation i can connect to it, using any
> password (sys, sysman, system), it runs. But when i restart my PC, i
> can't connect to it anymore. I need to start an oracle service or do
> something else ?
> Thank you for your help
>
> David

The service is already started; you simply don't have that service configured to start your instance. Either user oradim to correct that:

oradim -startup -sid <your sid here> -starttype srvc,inst -spfile <spfile name and location here>

Or decide to manually start your database after a reboot by:

sqlplus /nolog
...
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
...

David Fitzjarrell Received on Mon Jul 16 2007 - 11:41:11 CDT