Re: Net8: connect from remote client but not local client

thanks.

we had a tnsnames.ora, the file generated by the default installation script. that was the problem -- there was something corrupt in there.

i deleted that file and rewrote it with only the one entry i needed and that solved the problem.

good luck
//michael

-----Original Message-----
From: gennick_at_worldnet.att.net [mailto:gennick_at_worldnet.att.net] Sent: Tuesday, November 24, 1998 8:06 PM To: michael ryan
Subject: Re: Net8: connect from remote client but not local client

When this happens to me, it's usually because I don't have the same TNSNAMES file on the server as on the client. That's for my NT servers. However, I currently manage an HP Unix box that exhibits this behavior, and the TNSNAMES files are correct. I havn't had time to figure out that problem yet.

On Mon, 23 Nov 1998 22:33:08 -0800, michael ryan <michael.ryan_at_pahv.xerox.com> wrote:

>SITUATION
>Oracle 8 installation. can connect to the server via TCP from remote
>client (proven with NT client). however, cannot use TCP to connect to
>database from the server.
> e.g. on the server
> sqlplus tigger/bounce
> works but
> sqlplus tigger/bounce_at_pooh
> does not.
>
>ASK
>1. is this because the client is not linked with the TCP adapters?
>2. is this because of bad tnsnames.ora file?
>
>please advise
>
>thank you
>//michael
>
>
>
>
>icm3% adapters oracle
>
>Net8 Protocol Adapters linked with oracle are:
>
> BEQ Protocol Adapter
> IPC Protocol Adapter
> TCP/IP Protocol Adapter
> RAW Protocol Adapter
>
>Net8 Naming Adapters linked with oracle are:
>
> Oracle TNS Naming Adapter
> Oracle Naming Adapter
>
>
>Advanced Networking Option/Network Security products linked with oracle
>are:
>
> Oracle Security Server Authentication Adapter
>
>icm3% adapters sqlplus
>
>Net8 Protocol Adapters linked with sqlplus are:
>
>
>Net8 Naming Adapters linked with sqlplus are:
>
>
>
>Advanced Networking Option/Network Security products linked with sqlplus
>are:
>
> Oracle Security Server Authentication Adapter

--

:: michael ryan , ryan_at_parc.xerox.com
:: xerox internet channel and marketing group
:: 3400 hillview avenue , palo alto , 94304
:: 650 813 7620 , *923 7620 ; Page me 800 772 1583, 7721583_at_pagemci.com