Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    6

    Unanswered: Oracle Listener not finding the Service

    Hi, I have installed the Oracle 8i server on my laptop (windows 2000). I have started the Database service and modified the tnsnames.ora and listener.ora. When I started the listener, I am getting the following message. Basically it's not able to identify the database service and says "The listener supports no services". How do I make my listener finds the service when it starts. Any help would be greatly appreciated. Please see below for more details.

    Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc
    tion
    Start Date 02-FEB-2005 15:03:11
    Uptime 0 days 0 hr. 0 min. 2 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File C:\Orant\network\admin\listener.ora
    Listener Log File C:\Orant\network\log\listener.log
    The listener supports no services
    The command completed successfully

    Here are the tnsnames and listener entries . I have both the files placed under C:\Orant\network\ADMIN.

    -------------tnsnames.ora--------------

    WFXX =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (COMMUNITY =)(PROTOCOL = TCP)(Host = 1.2.3.4)(Port = 1521))
    )
    (CONNECT_DATA =
    (SID = WFXX)

    )
    )

    -----------------Listener.ora---------------------

    LISTENER =
    (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521) )
    (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

    SID_LIST_LISTENER=
    (SID_LIST=
    (SID_DESC=
    (SID_NAME=WFXX)
    (ORACLE_HOME=C:\orant)
    )
    )

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Have you intermingled an Oracle 8.0 installation and an Oracle 8i ???
    It almost looks like you have a 8.0 install and overlaid it with an 8i

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by rameshb241
    (ADDRESS = (COMMUNITY =)(PROTOCOL = TCP)(Host = 1.2.3.4)(Port = 1521))
    Is that a valid IP address, I wonder?

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    DEPENDS on whether he has the IP configured in the HOST file pointing
    back to his local machine ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •