Re: Help, Newie!

Make sure your listener is running..you can do this by going to the command line and typing:

C:> lsnrctl

This starts the listener control utility...when your prompt changes to

lsnrctl>

type

start

You can also type the word 'status' to see if it's running but typing start will either start it or tell you it's already started..if on NT, you can also check your services to make sure the Oracle services are all set to automatically start..there'll be at least two, likely more with the word 'Oracle' in them...

Steve

In article <bbd94t8l810012gs52v6fffuqj4ojvob1e_at_4ax.com>,   Serial # 19781010 <limkb1_at_mbox3.singnet.com.sg> wrote:
> Steve,
>
> Thanks very much for your help. But when leave the host
>
> empty. I encounter this error : - ORA 12560: TNS:protocol adapter
>
> error. What must I do next??
>
> Thanks again for your patience and advice.
>
> Merry Christmas and A Happy New Year.
>
> regards,
> KB Lim
>
> On Sat, 23 Dec 2000 12:04:04 GMT, steveee_ca_at_my-deja.com wrote:
>
> >Hi,
> >
> >Oracle provides a few standard users ...
> >
> >Username: SYSTEM
> >Password: MANAGER
> >
> >Username: SCOTT
> >Password: TIGER
> >
> >Username: SYS
> >Password: CHANGE_ON_INSTALL
> >
> >As for the host entry, that's usually set up as a word that people
 will
> >remember that acts as an alias for a numeric connect descriptor. That
> >way, people don't have to remember a abstract set of numbers to
 connect
> >to a database..it would normally be specific to an environment you're
> >in.
> >
> >However, if you're using Personal Oracle you can probably just leave
 it
> >empty. Try connecting as SYSTEM or as SCOTT to get you going.
> >
> >Regards,
> >
> >Steve
> >
> >
> >
> >
> >In article <ap294t0rk872nv5b0lgkuiv4nqcipbj68t_at_4ax.com>,
> > Serial # 19781010 <limkb1_at_mbox3.singnet.com.sg> wrote:
> >> Hi all,
> >>
> >> I am new to oracle. Everytime I exe SQl Plus, I am prompt
> >>
> >> for a username, password and host. What user, password and host to
 use
> >>
> >> on a PC/Or where can I find it(manual/Reg Key)??
> >>
> >> Thanks.
> >>
> >> regards,
> >> KB Lim
> >>
> >
> >
> >Sent via Deja.com
> >http://www.deja.com/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Sat Dec 23 2000 - 09:50:49 CST