Here we go again: please help oracle idiot.....listener?......service naming?.......eh?

Thanks for your help, Chris.

Unfortunately, I can't change the configuration... I'm pretty much stuck with what I've got for the moment, but if I get the chance to use the "real" version, I will.

I have joined technet, and my post here is in desperation. It's not that I've just hit a problem, not bothered to try and find out anything for myself and asked a stupid question on here! I do know it looks a bit rubbish.....I'm having major problems with the software before it's even set up properly. Just imagine what it'll be like when I've started working with Oracle!

So for anyone with experience of setting up personal edition:

The one question I'd like answered (to start off with!) is should the values regarding the host name and port no. for the service name and the listener be the same?

Otherwise,

Does anyone have a failsafe way of setting up the listener / service name that I might not have tried?

cheers

al

"Chris Weiss" <chris_at_www.hpdbe.com> wrote in message news:a2mujk$pob$1_at_msunews.cl.msu.edu...
> Unless you are tied to this configuration, join Oracle Technet:
>
> technet.oracle.com
>
> Install Oracle 8i on a NT or 2000 machine and use this in place of the
> personal edition. It is not worth the bother to work with the personal
> edition. If you can, 9i is certified for XP.
>
> Oracle EE has the database assistant that will build a database for you
> mindlessly, which is perfect for proof of concept or prototyping.
>
> Good Luck!
>
> --
>
> ~~~~~~~~~~~~~~~~
> Chris Weiss
> www.hpdbe.com
> High Performance Database Engineering
> ~~~~~~~~~~~~~~~~
>
>
> "Alex Wellard" <alex_at_seamless-marketing.co.uk> wrote in message
> news:a2mq2d$u9g$1_at_newsg3.svr.pol.co.uk...
> > Hi there
> >
> > Thanks for reading this message. This may be idiotic or not....but I'll
> ask
> > all the same. (I'm pretty desperate!)
> >
> > I'm trying to set up Oracle 8i Personal Edition on my Win98 machine. I
> have
> > PWS installed to test ASP. I've gone through the installation process
and
> > created a new database etc. My problem arrives when I start configuring
> the
> > listener and service name. When I test the service name all I get is
> > "ORA-12541: TNS:no listener".....
> >
> > For the Service Naming:
> > name = same as my global database name
> > connection type = database default
> > address protocol = TCP/IP
> > host name = Computer Name (as set up in Start>Control
> > Panel>Network>Identification)
> > port no. = 1521
> >
> > For the Listener:
> > host name = same as above
> > port no. = same as above
> >
> > Is this what I'm supposed to do?...I assume that the values for host
name
> > and port no. should be identical. I've tried changing the userId etc.,
set
> > up a DSN....
> >
> > Any help, or direction to relevant material on the web would be hugely
> > appreciated....I'll just keep banging my head against the screen until
> then.
> >
> > Cheers
> >
> > Al
> >
> >
> >
>
>
Received on Thu Jan 24 2002 - 08:33:27 CST