Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus wrong?

Re: sqlplus wrong?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 12 Oct 2004 10:18:49 +0200
Message-ID: <ckg3i9$ar9$1@news1.zwoll1.ov.home.nl>


MaoXuePeng wrote:
> Thank you, Frank van Bortel.
> Accroding you method, the SQLPLUS can connect the local oracle server as
> well as the remote oracle server.
> But I don't know why!
>
> Regards!
> MaoXuePeng.
>

You're giving SQL*Net the wrong info: your local computer belongs to the same network, according to the aliases, but further down in the configuration file (tnsnames.ora), there's real network information.
This information is quite different, but this is actually used to set up the connection. The aliases in tnsnames.ora is just the "shorthand" for us, humans.
And to make it even easier, there's no need to type touch.caswsoft.casw.com completely, when you enter a default domain of "caswsoft.casw.com". Touch will be enough, then.

-- 

Regards,
Frank van Bortel
Received on Tue Oct 12 2004 - 03:18:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US