My Discussion wrote:
> Hello,
> I am getting an error ORA-01034:Oracle not available in 10g,
>
>
> Please help me.
> I am new to oracle 10g.
> Also how to start new services.
> I cannot even connect to oracle sql* plus.
> The platform is windows and os is xp
>
> Thanx in advance
>

Is the Oracle instance running on the same machine as sqlplus? Did this
ever work? Did anything change since it last worked? If sqlplus and the
instance are on different machines, is the networking configuration set
up correctly? Is the listener.ora file on the remote machine referencing
the correct instance? There are lots of unanswered questions and unknown
variables. Without knowing them it would be impossible to tell you what
to do.

I am *guessing* that the Oracle instance and sqlplus are both on the
same machine. If so then the first thing to check is that the instance
is actually running. Check the service list and see if the Oracle
services are running. If not, start them and try again. You don't really
need the listener service up unless you have users trying to connect
over a network.
--
To reply by email remove "_nospam"