Kbase 15776: How to config SQL*NET in Oracle version 7.2 and above
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to config SQL*NET in Oracle version 7.2 and above
Oracle have introduced a new "feature" in their SQL*Net product as of
V7.2.
In the sqlnet.ora file (under %ORACLE_HOME%\network\admin on Windows),
there is parameter called names.default.domain that by default has
the value "world". This means that SQL*Net will, by default, attach a
".world" suffix to every listener name that it has to resolve.
So if you try to connect using the following string:
system/manager@listener
SQL*Net will actually try to resolve:
system/manager@listener.world
which won't work unless you have a domain named "world".
There are two workarounds for this problem:
1. Remove the value of the names.default.domain parameter in
sqlnet.ora (Not recommended, as this is the way all Oracle product
will go in the future).
2. Edit tnsnames.ora (also in %ORACLE_HOME%\network\admin) so that
the definition of your listener process looks like:
LISTENER.WORLD = (DESCRIPTION (...
instead of
LISTENER = (DESCRIPTION (...
5/20/96 ik
Progress Software Technical Support Note # 15776