Re: NT 4.0 TNS problem

From: Erik de Boer <erik_at_cairo.nl>
Date: 1997/02/08
Message-ID: <32FCE24A.5867@cairo.nl>#1/1

lally_at_mail.sep.bnl.gov wrote:
>
> I downloaded the NT Workgroup server demo from www.oracle.com and got
> the starter orcl database up and running. My problem is I can't
> TNSPING the system from any other client. I can TNSPING remote
> servers from the new NT server which indicates to me that the TNS
> is working. The server manager shows the OracleTNS service is up
> and running.
>
> Anyone know the secret of getting the listener to work for the NT 4.0
> workgroup server? The error returned by tnsping on the client is:
> TNS-12451: TNS:no listener
>
> Thanks in advance.
> Keith Lally
> lally_at_bnl.gov

Hi keith,

There could be two possible problems
a - you didn't install the listener
b - the listener is not running

If you didn't install it than it will not show in you services list (control panel). If it is there than you need to start it. Before you go on with that you need to modify the listener.ora file which is located in your ORANT\NETWORK\ADMIN directory. If it's not there than you need to create one, e.g.

################
# Filename......: listener.ora
# Node..........: local.world

# Date..........: 24-MAY-94 13:23:20

################

LISTENER =
  (ADDRESS_LIST =

         (ADDRESS= 
          (COMMUNITY= TCP.world)
          (PROTOCOL= TCP)
          (Host= hostname)
          (Port= 1521)
        )
        (ADDRESS= 
          (COMMUNITY= TCP.world)
          (PROTOCOL= TCP)
          (Host= hostname)
          (Port= 1526)
        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
    (SID_DESC =

      (SID_NAME = instance name)
      (PRESPAWN_MAX = 10)
      (POOL_SIZE = 2)
      (TIMEOUT = 100)

  )
PASSWORDS_LISTENER = (oracle)

If this file is there you just start the listener with the LSNRCTL.EXE (startit in a command shell) Received on Sat Feb 08 1997 - 00:00:00 CST