Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus wrong?
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 BortelReceived on Tue Oct 12 2004 - 03:18:49 CDT