Re: SQLNET V2 ORA-12203 and ORA-12500 errors, or, does SQLNET V2 really work ?

From: Angelo Melendez <no email>
Date: 1995/10/24
Message-ID: <1995Oct24.004621.10580_at_nosc.mil>

In message <468v2q$r9d_at_suned1a.nswses.navy.mil>, grape_at_suned1.nswses.navy.mil (Mike . Grapevine) writes:

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

Hi Michael,

Can you telnet into the host and run SQL*Net from there? If not, are you sure SQL*Net TCP/IP is actually installed?

Do you have an exact replica of your server's tnsnames.ora on the client (orawin/network/admin) you are trying to connect from? I'm not sure what ODBC's role is in your WS attaching to the Oracle server, is it actually necessary?

Here is a smaple of my tnsnames.ora file from our HP9000 running Oracle 7.1.3: nfas.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (COMMUNITY = tcp_com.world)
          (PROTOCOL = TCP)
          (Host = nchp4601)
          (Port = 1521)
        )

    )
    (CONNECT_DATA = (SID = nfas)
    )
  )

You can try adding some of the entries omitted from yours and substituting the appropriate variables. Also, make sure that manual editing of these files has not planted any stray spaces, tabs, etc. Oh, I did not see any mention of a sqlnet.ora file, are you using one?

I have one little quirk on our net with DB links between a Sun box and our HP, other than that, we are OK with SQL*Net 2.x (so far) . . . hope any of this helps.

Angelo Melendez
melendez_at_nosc.mil
>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:
>
>
>****************************** TNSNAMES.ORA **********************************
>################
># Filename......: tnsnames.ora
>################
>TOMAHAWK = (DESCRIPTION=
> (ADDRESS=
> (PROTOCOL=TCP)
> (HOST=phoenix)
> (PORT=1521)
> )
> (CONNECT_DATA=(SID=CRUISE1)
> )
> )
>******************************************************************************
>
>
>
>
>****************************** LISTENER.ORA **********************************
>################
># Filename......: listener.ora
># Node..........: phoenix.world
># Date..........: 28-OCT-94 11:37:08
>################
>LISTENER =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = phoenix)
> (PORT = 1521)
> )
> (ADDRESS=
> (PROTOCOL = IPC)
> (KEY = CRUISE1)
> )
> )
>
>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=152
1)))
>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 Tue Oct 24 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Dipankar: "Re: DBAs : SID Change ?"
Previous message: Craig Sivils: "Re: HELP: SQL SELECT"
Maybe in reply to: Mike . Grapevine: "SQL*NET V2 ORA-12203 and ORA-12500 errors, or, does SQL*NET V2 really work ?"
In reply to Alvis D. Harding Jr.: "Newbie needs help installing 90 day Solaris x86 Oracle trial"
Next in thread: Dipankar: "Re: DBAs : SID Change ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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

Re: SQLNET V2 ORA-12203 and ORA-12500 errors, or, does SQLNET V2 really work ?