Re: sqlplus wrong?

MaoXuePeng wrote:

> Hi, I think I have found the problem. I want to connect to local oracle
> server and remote oracle server as well.
> The problem is in the SQLNET.ORA. The detail of SQLNET.ORA is :
> # SQLNET.ORA Network Configuration File:
> E:\oracle\ora90\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> NAMES.DEFAULT_DOMAIN = caswsoft.casw.com
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
> The key is that code:
> "NAMES.DEFAULT_DOMAIN = caswsoft.casw.com"
> If I connect to the remote oracle server with SQLPLUS, I must delete
> "NAMES.DEFAULT_DOMAIN = caswsoft.casw.com" from SQLNET.ORA, if I connect
> to the local oracle server, I must keep "NAMES.DEFAULT_DOMAIN =
> caswsoft.casw.com" in the SQLNET.ORA. Else the SQLPLUS can not connect to
> the certain oracle server.
>
> The connection command of SQLPLUS to local oracle server is :sqlplus
> maoxp/*****@touch; to remote oracel server is :sqlplus navi/*****@lbs2.
>
> However, that statement :
> "NAMES.DEFAULT_DOMAIN = caswsoft.casw.com" has no effect to TNSPING
> command.
>
> How can I resolve it?
>
> Thanks!
> MaoXuePeng.
>

lbs2.caswsoft.casw.com = (description ....

and:

touch.caswsoft.casw.com = (descrip....

In other words: fake the local alias to be in the domain... there are other solutions, I'm sure.

-- 

Regards,
Frank van Bortel