Re: Problem when using SQLPlus in Oracle 9i

alexsm_at_eudoramail.com (Alex) wrote in message news:<29ff93bc.0307231254.79624abe_at_posting.google.com>...
> I tried that and I am still getting the following error when I try to
> login to SQL PLUS:
>
> Error:
> ORA-12560: TNS: Protocol Adaptor Error
>
> Any idea?
>
> Sincerely,
> Alex
>
>
> "Nicolas Payre" <nicpayre[junk]_at_sympatico.ca> wrote in message news:<O9zSa.449$1I5.55399_at_news20.bellglobal.com>...
> > Sound like the Instance your trying to connect isn't started...
> > Check for Services into the "Computer management consol" if you can see it.
> > Otherwise you can startt it manually with the following command
> >
> > z:\your_oracle_home\ORACLE.EXE <global database name>
> >
> >
> >
> > "Alex" <alexsm_at_eudoramail.com> wrote in message
> > news:29ff93bc.0307200745.3c9f3274_at_posting.google.com...
> > > Hi Everybody,
> > >
> > > I am new to Oracle.
> > > I just installed the Oracle9i (personal edition) on my Window XP
> > > system. I am trying to simply run some basic SQL commands using
> > > SQLPlus. After entering userid (system) password(manager) and Host
> > > String (my global database name), I am getting the following error and
> > > it does not logme in:
> > > can not run the service.
> > >
> > > Would you please help me? Is default user name and password are
> > > correct?
> > >
> > > Sincerely,
> > > AlexSM

A 12560 error would indicate that Oranet (sqlnet, net8) either is not installed or not configured correctly. First if you have not already done so re-boot the machine. Then if the problem still exists open the Oracle Net Configuration Assistent and look at the settings. The ID used to install Oracle on your PC should have almost full administration privileges.

HTH -- Mark D Powell -- Received on Thu Jul 24 2003 - 23:34:31 CEST