Listener Problem - ORA-12224

From: <tienlee_at_mailexcite.com>
Date: Wed, 16 Dec 1998 21:56:10 GMT
Message-ID: <759a9p$770$1@nnrp1.dejanews.com>

I am running Oracle 8 on NT and trying to connect remote clients via T1 line. Clients NT server is not running on DNS and tnsname.ora is configured using IP address.

I am able to ping the IP address from remote location but got ORA-12224: No Listener error. When I tried tnsping, I got the same error (ORA-12224).

I am sure that the tnsname.ora is configured properly but have not changed the listener.ora and sqlnet.ora. Should I changed them for remote connection with same network protocol (TPC) ?

Here is the listener.ora file:

LISTENER =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = NMP)(SERVER = BBHORACLE)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = TCP)(HOST = bbhoracle)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = bbhoracle)(PORT = 1526))
(ADDRESS = (PROTOCOL = IPC)(KEY = FD01))
(ADDRESS = (PROTOCOL = IPC)(KEY = FD02))
(ADDRESS = (PROTOCOL = IPC)(KEY = SC01))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = FALC))
(ADDRESS = (PROTOCOL = IPC)(KEY = LOAD))
(ADDRESS = (PROTOCOL = IPC)(KEY = EOD))
(ADDRESS = (PROTOCOL = IPC)(KEY = TT01))
(ADDRESS = (PROTOCOL = IPC)(KEY = SS01))
(ADDRESS = (PROTOCOL = IPC)(KEY = SS02))
(ADDRESS = (PROTOCOL = IPC)(KEY = SS03))
(ADDRESS = (PROTOCOL = IPC)(KEY = SS04))
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (SID_NAME = extproc)
      (PROGRAM = extproc)

    )
(SID_DESC =

      (GLOBAL_DBNAME = SILVERMASTER)
      (SID_NAME = FD01)

Any help is truly appreciated. Thanks in advance.

Alan Lee

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 16 1998 - 15:56:10 CST