DO I HAVE LISTENER? HOW TO START LISTENER? ERRORS: ORA-12224: no listener AND, ORA 12545 NO SERVICE NAME

From: Matt nalepinski <matt.nalepinski_at_eds.com>
Date: 28 Mar 2002 14:40:49 -0800
Message-ID: <1bfdf1e9.0203281440.536d3067@posting.google.com>

I have 2 simple questions:

• Do I have a listener? (executing lsnrctl at dos prompt says it does neot exist)
• How (where) do you START THE LISTENER?

I installed Oracle 8i client (in c:\orant), then the 8i Enterprise (in c:\oradev).

Now the 1 complex question:

I am getting the NO LISTENER ERROR.
ORA-12154: TNS:could not resolve service name

I have a listener.ora in c:\orant\network\admin\

                    …but not in c:\oradev\net80\admin\

I try to start SQL*PLUS, but get the NO LISTENER ERROR, using:

USER NAME: scott
PASSWORD: tiger
HOST STRING: ORCL <--- ERROR: ORA-12154: TNS:could not resolve service name

I also try to logon using:

USER NAME: scott
PASSWORD: tiger
HOST STRING: w2tzf93101 <--- ERROR: ORA-12224: TNS:no listener

I can logon to a remote oracle database with SQL*PLUS using:

USER NAME: xxxx
PASSWORD: yyyyy
HOST STRING: qrepdev <--- CONNECTS TO A REMOTE SERVER DATABASE OK.

1. The LISTENER.ORA in c:\orant\network\admin\ contains:

# LISTENER.ORA Network Configuration File: C:\orant\network\admin\listener.ora
# Generated by Oracle configuration tools.

SAVE_CONFIG_ON_STOP_LISTENER = TRUE LISTENER1 =
  (DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = w2tzf93101)(PORT = 1521))
      )

    )
  )

USE_PLUG_AND_PLAY_LISTENER = ON LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = w2tzf93101)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = Oracle8)
      (ORACLE_HOME = c:\oradev)
      (SID_NAME = ORCL)

    )
(SID_DESC =

      (GLOBAL_DBNAME = Oracle8)
      (SID_NAME = ORCL)

    )
  )

2) The LISTENER.ORA in c:\oradev\net80\admin\ contains:

Beq-local.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = beq.world)
          (PROTOCOL = BEQ)
          (PROGRAM = oracle73)
          (ARGV0 = oracle73ORCL)
          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )
Tcp-loopback.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )
Example1.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = Production1)
          (Port = 1521)
        )

    )
(CONNECT_DATA = (SID = SID1)

    )
  )
Example2.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = spx.world)
          (PROTOCOL = SPX)
          (Service = Server_lsnr)
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )
Example3.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = nmp.world)
          (PROTOCOL = NMP)
          (Server = FinanceServer1)
          (Pipe = ORAPIPE)
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )

3) The TNSNAMES.ORA file in c:\orant\network\admin\ contains:

####################################
# TNSNAMES.ORA Configuration File:C:\orant\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2

# Date..........: Wed Mar 27 16:40:11 EST 2002

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

QREPDEV =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = trstow01.capctr.globalsd.eds.com)(PORT = 1521))

    )
(CONNECT_DATA = (SID = qrepdev))

  )

ORCL_127.0.0.1 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))     )
(CONNECT_DATA = (SID = ORCL)(SERVER = DEDICATED))
  )

4) There is no TNSNAMES.ORA file in c:\oradev\net80\admin\ Received on Thu Mar 28 2002 - 16:40:49 CST