please help oracle idiot.....listener?......service naming?.......eh?

From: Alex Wellard <alex_at_seamless-marketing.co.uk>
Date: Wed, 23 Jan 2002 16:57:23 -0000
Message-ID: <a2mq2d$u9g$1@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 Wed Jan 23 2002 - 10:57:23 CST