Re: sqlplus wrong?

"MaoXuePeng" <mxp123q_at_126.com> wrote in message news:<9d9fec0ce775df070253aaf491609db4_at_localhost.talkaboutdatabases.com>...
> 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.

If this is a local database server you are connecting from that server to the database, if I read this correctly. I wonder why you choose to use the TCP protocol for local connections when you can easily set ORACLE_SID in your environment and use IPC connections, bypassing the listener altogether. Thus, you'd have no issues with your sqlnet.ora configuration as it would only apply to remote connections.

So, I ask you: why do you use SQLNet for local connections when it is entirely unnecessary?

David Fitzjarrell Received on Mon Oct 11 2004 - 14:54:55 CDT