Re: SQL Net 2 problems

Herman Scheepers wrote:

> I installed SQLNet on two arbitrary machines. The machines in question are
> both on the same IP subnet. The host can be pinged from both machines.
> Subsequent to installation, I created exactly the same SQLNet 2 alias on
> both machines using SQL Net easy configuration.
>
> When I test with SQL Plus, I get in on the one machine no problem. On the
> other I get ora 12154 - TNS could not resolve service name. This in spite
> of the fact that a tns.ora file exists, and it contains the relevant alias
> (identical configurations on both machines).

  Would you mind to post the tnsnames.ora ?

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841