Re: sqlplus wrong?

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. Received on Mon Oct 11 2004 - 04:05:28 CDT