Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Listener won't start!!! TNS protocol adapter error

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

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

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

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

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 ---

(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:

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US