Re: OS/2 Warp, SQL*Net, TCP/IP problems

In <4aggsd$p9q_at_news-s01.ny.us.ibm.net>, scthomp_at_ibm.net (Simon Thompson) writes:
>I, in conjunction with Oracle Support, am trying to get an OS/2 Warp Connect
>client talk to an Oracle 7.1 database via TCP/IP.
>
>Sql*Net is v2.1. I can ping the server. I have Windows clients talking okay.
>I have copied the TNSNAMES file they use.
>
>All I get is TNS12154. I have traceing turned on - which is telling us
>little. We have tried everything suggested in the Oracle bulletins, and then
>some. Still it won't go.

What I'd really like to do is fly down there for Christmas and help you, but since I'm going elsewhere next week I'll just have to send you a TNSNAMES file.

I hope that support told you that 12154 errors are almost always the result of a syntax error in the TNSNAMES ORA file, or a completely missing entry. Although you might expect that whitespace doesn't matter in that file, at least on OS/2 it does. Even a carraige return can mess it up. Short of committing mayhem in the Network Products Division office (which I have often considered) the best you can do is to be very careful around that file.

The following entries were copied from my own TNSNAMES file, in which I have dozens of working entries. I copied just a few. Thie first connected to a unix system on a Pyramid, the second to an IBM VM system, the third to an AS/400.

mail = (DESCRIPTION=

                 (ADDRESS=
                  (PROTOCOL=tcp)(PORT=1599)(HOST=prodpyr2))
                  (CONNECT_DATA=(SID=mail)
                 ))

alpha6  =   (DESCRIPTION=
                 (ADDRESS=
                  (PROTOCOL=tcp)(PORT=6999)(HOST=hqcms))
                  (CONNECT_DATA=(SID=ALPHNMST)
                 ))

f20tcpdem  =   (DESCRIPTION=
                 (ADDRESS=
                  (PROTOCOL=tcp)(PORT=1599)(HOST=devas400))
                  (CONNECT_DATA=(SID=ORAGATE)
                 ))