Re: Oracle on MVS OS/390 with ESCON adapter

From: Howard Peppers <peppers_at_npwt.net>
Date: Fri, 25 May 2001 19:33:17 GMT
Message-ID: <1syP6.32308$BN6.1781838@newsread1.prod.itd.earthlink.net>

Wayne,

Thanks for your interest, I requested the mainframe MPM dataset, corresponds to listener.ora , error messages, and other info from our DBAs, but have yet to receive them. We are fairly confident in our listener parms.

Attempting to connect from the RS/6000 to the Mainframe instance:

>sqlplus scott/tiger_at_orat

SQL*Plus: Release 3.3.4.0.0 - Production on Fri May 25 14:18:16 2001

ERROR: ORA-12224: TNS:no listener

we can connect over the token ring however

>sqlplus scott/tiger_at_orat96

tnsping verifies the tnsnames:

>tnsping orat

TNS Ping Utility for IBM/AIX RISC System/6000: Version 2.3.4.0.0 - Production on

Attempting to contact
(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=192.168.

            4.2)(Port=1523))
            TNS-12541: TNS:no listener


            tnsping orat96

            TNS Ping Utility for IBM/AIX RISC System/6000: Version
2.3.4.0.0 - Production on
             25-MAY-01 14:28:13

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

            Attempting to contact
(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=10.30.20
            .96)(Port=1522))
            OK (300 msec)

As an update, we have found that although when we start our listeners we get:

Listening on
(ADDRESS=(PROTOCOL=TCP)(NAME=RS6K1700)(PORT=1523)(SSN=TNSB)) Listening on
(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.20.96)(PORT=1522)(SSN=TNSB)) RS6K1700 resolving to the ESCON adapter, Netstat on the machine shows the port 1523 bound to 10.30.20.96, the OSA token ring adapter.

Changing the NAME parameter to HOST gives us

            Listen error 12533/12560/503/00000000/00000000 on
            ADDRESS=(PROTOCOL=TCP)(HOST=192.168.4.2)(PORT=1523)(SSN=TNSB
            Listening on

(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.20.96)(PORT=1522)(SSN=TNSB)) indicating an ilegal address parameter for the ESCON, Netstat shows no binding of port 1523, as it shouldn't.

Discussions of the problem have included a gethostbyname() call by oracle during the start. We are currently running a single TCP stack and a single TNSPROC started task on the mainframe. It has been suggested we try adding a stack or another TNSPROC or both to resolve the problem. Of course we would prefer an easier way if anyone has any knowledge.

"wayne" <no_at_email.please.com> wrote in message news:9ehnc1$in5_at_dispatch.concentric.net...
> Could you please post the following:
>
> 1. The entire listener.ora file,
> 2. The exact error message you are getting (specially the error code)
> 3. The actual parameters (ip numbers, etc) of the server.
>
>
Received on Fri May 25 2001 - 14:33:17 CDT