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 -> TNS Listener won't start

TNS Listener won't start

From: Apache <any_at_any.com>
Date: 3 Mar 1999 06:43:34 GMT
Message-ID: <36ddd96f.1689950@netnews.worldnet.att.net>


Hello,

        I have Oracle8 Ent Ed running on NT4.0 Server Version SP 4. I then installed Dev2000. After I installed Designer 2000, I had used SQL Net Easy Config to create a database alias to connect to the database. I used my TCP/IP address on my companys network to connect just fine. Now that I no longer use my laptop on the network anymore, I have trouble connecting to the database when logging into Designer 2000. The TNS Listerner will not even start. Does anyone know what changes need to be made to the listener.ora or otherwise so that I can connect? My computer name is "djones" . Your help is appreciated. This what the Listener.ora looks like:

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=

(PROTOCOL= IPC)
(KEY= oracle.world)
) (ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
) (ADDRESS=
(PROTOCOL= IPC)
(KEY= EXTPROC0)
) (ADDRESS=
(COMMUNITY= NMP.world)
(PROTOCOL= NMP)
(SERVER= DJONES)
(PIPE= ORAPIPE)
) (ADDRESS=
(PROTOCOL= TCP)
(Host= djones)
(Port= 1521)
) (ADDRESS=
(PROTOCOL= TCP)
(Host= djones)
(Port= 1526)
) (ADDRESS=
(PROTOCOL= TCP)
(Host= 127.0.0.1)
(Port= 1521)
)

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = djones)
      (SID_NAME = d703)

    )
    (SID_DESC =
      (SID_NAME = extproc)
      (PROGRAM=extproc)

    )
  )
PASSWORDS_LISTENER = (oracle) Received on Wed Mar 03 1999 - 00:43:34 CST

Original text of this message

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