Listener won't start!!! TNS protocol adapter error

From: <jessicalevour_at_my-dejanews.com>
Date: Fri, 23 Oct 1998 08:04:31 GMT
Message-ID: <70pdae$r90$1@nnrp1.dejanews.com>

Hi!

I have re-installed Personal Oracle 7.2.2.3.1 on Win98 but I receive the following error when attempting to start the listener:

TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

Before, the listener auto-started without errors on database startup. I have been trying to get this to work for quite a while without any success. Please help me..!!

I have the following configurations (generated by "SQL*Net Easy Configuration"):

D:\ORAWIN95\NETWORK\ADMIN\tnsnames.ora --> ORAWIN95 is installed on my drive D

JaeOracle.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = JAECLIENT) ---> "PING jaeclient" works OK!! (my local


computer name)


          (Port = 1521)


        )
        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = JAECLIENT)


          (Port = 1526)


        )

    )
    (CONNECT_DATA = (SID = ORCL) -----> SID name IS correct!!     )
  )

D:\ORAWIN95\NETWORK\ADMIN\sqlnet.ora

TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 2147483647
names.default_domain = world
name.default_zone = world

D:\ORAWIN95\NETWORK\ADMIN\listener.ora

LISTENER =
(ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = jaeclient)


          (Port = 1521)


        )
        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = 127.0.0.1)  -------> "PING 127.0.0.1" works OK!!


          (Port = 1521)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )

D:\ORAWIN95\NETWORK\LOG\listener.log

TNSLSNR for WINDOWS 32: Version 2.2.2.0.0 - Production on 23-OCT-98 05:10:17

System parameter file is D:\ORAWIN95\NETWORK\admin\listener.ora Log messages written to D:\ORAWIN95\NETWORK\log\listener.log Trace information written to D:\ORAWIN95\NETWORK\trace\listener.trc Trace level is currently 6

Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP) (Host=jaeclient)(Port=1521)))
Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1)) TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

D:\ORAWIN95\NETWORK\TRACE\listener.trc

TNSLSNR for WINDOWS 32: Version 2.2.2.0.0 - Production on 23-OCT-98 05:10:17

TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is "D:\ORAWIN95\NETWORK\trace\listener.trc" New trace level is 6
TRACE CONFIGURATION INFORMATION ENDS ---
PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source D:\ORAWIN95\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 = jaeclient) (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:\ORAWIN95\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 ORANTPFFFCBBE3.FFFCB637 Successfully established pipe 28 to parent. NT layer IPC connection has been established. transport is open
global context check-in (to slot 0) complete doing connect handshake...
128 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=(PROTOCOL=TCP)(Host=jaeclient) (Port=1521)))
port resolved to 1521
looking up IP addr for host: jaeclient
opening transport...
No PROTOCOL.ORA file is found
Validnode Table IN use; err 0x0
transport is open
global context check-in (to slot 1) complete Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP) (Host=jaeclient)(Port=1521)))
(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1)) opening transport...

-<ERROR>- error: handle=-1, op=3, nt[0]=530, nt[1]=0
-<ERROR>- error: handle=-1, op=3, nt[0]=530, nt[1]=0
-<ERROR>- nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=0, nt[2]=0
-<ERROR>- unable to open transport
-<ERROR>- Reporting the following error stack:

TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

sending NSPTRF packet
12 bytes to transport
sending 497 bytes connect data
497 bytes to NS buffer
no timer allocated
507 bytes to transport
closing transport
global context check-out (from slot 0) complete no timer allocated
closing transport
global context check-out (from slot 1) complete Deallocating cxd 0x6e38f8.

.... Sorry for the long listing. ;) ....

Before I reinstalled PO7 and Win98, everything used to work perfectly and I have no idea what I'm doing wrong this time. I would greatly appreciate your help.

Please note the following:

Connecting with HOST NAME of "2:" works fine with SQL*Plus (so I guess the problem isn't in the database itself...?)
I am not connected to a LAN (but I have a net card installed with TCP/IP binding).
I have installed using the "Complete Installation" option (including SQL*NET TCP/IP stuff)

Thanks!!!

Jessica

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Oct 23 1998 - 03:04:31 CDT