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.

You need to have an accessible onames server running at caswsfot.casw.com, or get rid of the onames in the names.directory_path. It is probably timing out waiting for the onames server.

jg

--
@home.com is bogus.
http://www.lyricsandsongs.com/song/14006.html