Home -> Usenet -> comp.databases.oracle -> SQL*NET V2 ORA-12203 and ORA-12500 errors, or, does SQL*NET V2 really work ?

SQL*NET V2 ORA-12203 and ORA-12500 errors, or, does SQL*NET V2 really work ?

From: Mike . Grapevine <grape_at_suned1.nswses.navy.mil>
Date: 1995/10/20
Message-ID: <468v2q$r9d_at_suned1a.nswses.navy.mil> 






Hi



Well, I've had SQL*Net V2.1.3 TCP/IP for a year now, and haven't got it working yet,
so it's about time for another round with it. I can't depend on SQL*Net V1
for future database communications, as I hear support for that is being 
discontinued sometime in the next year.



Basically, I get ORA-12203 and ORA-12500 errors when I try to connect to
our Oracle 7.1.3 instance on our HP 9000 750 through SQLNET V2, SQLNET V1 works
just fine with no problems (can V1 and V2 be running on the same server ?).
I've had people from Oracle support, and other Oracle experts look at the
TNSNAMES.ORA and LISTENER.ORA files, and give them a clean bill of health.
After examining the sqlnet.log, listener.log, and listener.trc files, I see
indications of an "ns main err code: 12598", 
"TNS-12598: TNS: operation failed due to error returned by native service",
and "ns secondary err code: 12659".



Has anybody out there actually seen a successful installation of SQL*Net V2
TCP/IP on an HP 9000 750 system ? I'd love to get this working, I'll take any
suggestions for a solution. I've been trying to connect to our database server
from the server itself, and from SQL*NET V2 running on a PC with ODBC.



Here are the TNSNAMES.ORA, LISTENER.ORA, log and trace files that I accumuated 
today, all of these files are stored in the correct place from $ORACLE_HOME/network
in the admin, log, and trace directories:







STARTUP_WAIT_TIME_LISTENER = 0



CONNECT_TIMEOUT_LISTENER = 10



TRACE_LEVEL_LISTENER = ADMIN


SID_LIST_LISTENER =



    (SID_DESC =


      (SID_NAME = CRUISE1)
      (ORACLE_HOME = /apps/phoenix/ora7)
      (TNS_ADMIN = /apps/phoenix/ora7/network/admin)


    )





    
  
  •   Last entry from SQLNET.LOG **********************************
Fatal OSN connect error 12598, connecting to:
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))






  VERSION INFORMATION:


        TNS for HPUX: Version 2.1.3.0.0 - Production
        Unix Domain Socket IPC NT Protocol Adaptor for HPUX: Version 2.1.3.0.0 - Production
        Oracle Bequeath NT Protocol Adapter for HPUX: Version 2.1.3.0.0 - Production


  Time: 20-OCT-95 12:28:51


  Tracing not turned on.


  Tns error struct:


    nr err code: 0


    ns main err code: 12598


    TNS-12598: TNS: operation failed due to error returned by native service
    ns secondary err code: 12659


    nt main err code: 0


    nt secondary err code: 0


    nt OS err code: 0






    
  
  •   LISTENER.TRC **********************************





TNSLSNR for HPUX: Version 2.1.3.0.0 - Production on 20-OCT-95 12:24:51



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




    
  
  •   TRACE CONFIGURATION INFORMATION FOLLOWS ---

New trace stream is "/apps/phoenix/ora7/network/trace/listener.trc"
New trace level is 6
  
  •   TRACE CONFIGURATION INFORMATION ENDS ---


  
  •   PARAMETER SOURCE INFORMATION FOLLOWS ---

Attempted load of system pfile source /apps/phoenix/ora7/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_DESC = (SID_NAME = CRUISE1) (ORACLE_HOME = /apps/phoenix/ora7) (TNS_ADMIN = /apps/phoenix
/ora7/network/admin))


  CONNECT_TIMEOUT_LISTENER = 10



  TRACE_LEVEL_LISTENER = ADMIN



  LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = phoenix) (PORT = 1521)) (ADDRESS= (PROTOCOL = IPC)
(KEY = CRUISE1)))



--- PARAMETER SOURCE INFORMATION ENDS ---




    
  
  •   LOG CONFIGURATION INFORMATION FOLLOWS ---

Log stream will be "/apps/phoenix/ora7/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...


NT layer IPC connection has been established.
transport is open


global context check-in (to slot 0) complete
doing connect handshake...


151 bytes from transport


got NSPTCN packet


discarding connect data (117 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=phoenix)(PORT=1521)))
port resolved to 1521


looking up IP addr for host: phoenix


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=phoenix)(PORT=1521)))
(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
opening transport...


transport is open


global context check-in (to slot 2) complete
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=CRUISE1)))

KEY = CRUISE1



opening transport...


transport is open


global context check-in (to slot 3) complete
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=CRUISE1)))
begin registration process for 1


begin notification process for 1


registering for 0x1


sending NSPTAC packet


24 bytes to transport


sending 447 bytes connect data


447 bytes to NS buffer


457 bytes to transport


flushing transport


connect handshake is complete


nsctxinf[0]=0x1, [1]=0x0


NTOBROKEN not supported by transport


-<ERROR>- transport read error


-<ERROR>- nsres: id=0, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=29, nt[2]=0



-<FATAL?>- failed with error 12637




-<FATAL?>- failed with error 12637




-<FATAL?>- failed with error 12637



-<ERROR>- nsres: id=0, op=68, ns=12598, ns2=12637; nt[0]=0, nt[1]=0, nt[2]=0
0 pre-posted event(s)


waiting for transport event (1 thru 3)...
1 newly-posted event(s)


event is 0x1, on 1


1 posted event(s)


opening transport...


waiting to accept a connection.


valid node check on incoming node 137.24.55.1
Accepted Entry: 137.24.55.1


transport is open


global context check-in (to slot 4) complete
doing connect handshake...


Setting connection into non-blocking mode
Clearing non-blocking mode


146 bytes from transport


got NSPTCN packet


command = status


sending NSPTAC packet


24 bytes to transport


sending 364 bytes connect data


364 bytes to NS buffer


374 bytes to transport


flushing transport


connect handshake is complete


nsctxinf[0]=0x0, [1]=0x0


asking transport to enable NTOBROKEN


37 bytes to NS buffer


47 bytes to transport


flushing transport


no timer allocated


10 bytes to transport


closing transport


global context check-out (from slot 4) complete
0 pre-posted event(s)


waiting for transport event (1 thru 3)...





    
  
  •   Last entry in LISTENER.LOG **********************************
TNSLSNR for HPUX: Version 2.1.3.0.0 - Production on 20-OCT-95 12:24:32






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



System parameter file is /apps/phoenix/ora7/network/admin/listener.ora
Log messages written to /apps/phoenix/ora7/network/log/listener.log
Trace information written to /apps/phoenix/ora7/network/trace/listener.trc
Trace level is currently 6



Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=phoenix)(PORT=1521)))
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=CRUISE1)))

TIMESTAMP ** EVENT [** SID] ** RETURN CODE
20-OCT-95 12:24:32 ** status ** 0
20-OCT-95 12:24:37 ** stop ** 0
******************************************************************************




****************************** Results from "lsnrctl start" **********************************




LSNRCTL for HPUX: Version 2.1.3.0.0 - Production on 20-OCT-95 12:51:52



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



Starting /apps/phoenix/ora7/bin/tnslsnr: please wait...



TNSLSNR for HPUX: Version 2.1.3.0.0 - Production
System parameter file is /apps/phoenix/ora7/network/admin/listener.ora
Log messages written to /apps/phoenix/ora7/network/log/listener.log
Trace information written to /apps/phoenix/ora7/network/trace/listener.trc
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=phoenix)(PORT=1521)))
Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=CRUISE1)))



Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=phoenix)(PORT=1521))
STATUS of the LISTENER



Alias                     LISTENER
Version                   TNSLSNR for HPUX: Version 2.1.3.0.0 - Production
Start Date                20-OCT-95 12:51:58
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               admin
Security                  OFF
Listener Parameter File   /apps/phoenix/ora7/network/admin/listener.ora
Listener Log File         /apps/phoenix/ora7/network/log/listener.log
Listener Trace File       /apps/phoenix/ora7/network/trace/listener.trc
Services Summary...
  CRUISE1               has 1 service handlers


The command completed successfully







-- 
        Michael D. Grapevine 
        US DoD
        Naval Surface Warfare Center - Port Hueneme Division
        Code 4G53 
        4363 Missile Way
        Port Hueneme, CA 93043-4307
        Email 1: grape_at_suned1.nswses.navy.mil
        Email 2: MIKE_GRAPEVINE_at_4G-GATEWAY.Nswses.Navy.Mil
        Email 3: grape_at_fishnet.net
        Bus: (805) 982-7791
        FAX: (805) 652-1664

    ("Oh ya, I heard it through the ....")
    Any statements / opinions made here are mine, alone, not the Navy's.
    


Received on Fri Oct 20 1995 - 00:00:00 CET












Original text of this message