Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: Listener Loaded Failed in Personal Oracle7

    Listener.trc:


    TNSLSNR for 32-bit Windows: Version 2.3.2.1.0 - Production on 27-AUG-02 15:00:22

    Copyright , 1996(c) Oracle Corporation 1994. All rights reserved.


    --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
    New trace stream is "D:\PORAWIN\network\trace\listener.trc"
    New trace level is 6
    --- TRACE CONFIGURATION INFORMATION ENDS ---

    --- PARAMETER SOURCE INFORMATION FOLLOWS ---
    Attempted load of system pfile source D:\PORAWIN\network\admin\listener.ora
    Parameter source loaded successfully

    Attempted load of command line source
    Parameter source was not loaded

    -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
    Successful parameter table load
    -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
    STARTUP_WAIT_TIME_LISTENER = 0
    SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ORCL)))
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = ADMIN
    LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = cp) (Port = 1521)) (ADDRESS = (PROTOCOL = TCP) (Host = 127.0.0.1) (Port = 1521)))
    --- PARAMETER SOURCE INFORMATION ENDS ---

    --- LOG CONFIGURATION INFORMATION FOLLOWS ---
    Log stream will be "D:\PORAWIN\network\log\listener.log"
    Log stream validation requested
    Log stream is valid
    --- LOG CONFIGURATION INFORMATION ENDS ---

    (ADDRESS=(PROTOCOL=beq))
    No process parameters set
    inheriting the connection...
    opening transport...
    Attempting to open pipe ORANTPFFEF14B7.1
    Event is DONE1
    Successfully established pipe 52 to parent.
    NT layer IPC connection has been established.
    transport is open
    Reading parameter "sqlnet.authentication_required" from parameter file
    Parameter not found
    Using default value "FALSE"
    Counting # of items in "sqlnet.authentication_services" parameter
    Parameter not found
    Found 0 items
    Using default value "all available adapters"
    Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameter file
    Parameter not found
    Using default value "ACCEPTED"
    Counting # of items in "SQLNET.ENCRYPTION_TYPES_SERVER" parameter
    Parameter not found
    Using default value "all available algorithms"
    Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" from parameter file
    Parameter not found
    Using default value "ACCEPTED"
    Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER" parameter
    Parameter not found
    Using default value "all available algorithms"
    global context check-in (to slot 0) complete
    doing connect handshake...
    144 bytes from transport
    got NSPTCN packet
    discarding connect data (94 bytes)
    connection inherited
    connected
    Resolved "CONNECT_TIMEOUT_LISTENER" to: 10
    Resolved "STARTUP_WAIT_TIME_LISTENER" to: 0
    (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCO L=TCP)(Host=cp)(Port=1521)))
    port resolved to 1521
    looking up IP addr for host: cp

    -<FATAL?>- *** hostname lookup failure! ***

    -<ERROR>- nsres: id=0, op=78, ns=12545, ns2=12560; nt[0]=515, nt[1]=1001, nt[2]=0
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Jun 2001
    Location
    The Netherlands
    Posts
    38
    Looks like it cannot resolve the hostname (cp). Try the following command from a command prompt:

    ping cp

    This should show the ip-address and some timing information. If not try adding the hostname to the hosts file (c:\windows\system32\drivers\etc on NT4).

Posting Permissions

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