Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: please help oracle idiot.....listener?......service naming?.......eh?

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

From: Miguel Camba <M.CAMBA_at_terra.es>
Date: Sat, 26 Jan 2002 00:15:22 GMT
Message-ID: <3c51f479.1514614@news.terra.es>


Sample files in W98.

TNSNAMES.ORA RPGMAX =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))     (CONNECT_DATA = (SID = GMXE))
  )
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     (CONNECT_DATA = (SID = EXTPROC0))
  )

LISTENER.ORA LISTENER =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))   )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = EXTPROC0)
    )
    (SID_DESC =
      (SID_NAME = GMXE)
    )
  )

Start listener before testing with DOS command: LSNRCTL start

On Wed, 23 Jan 2002 16:57:23 -0000, "Alex Wellard" <alex_at_seamless-marketing.co.uk> wrote:

>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 Fri Jan 25 2002 - 18:15:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US