Hi,
When I try to connect using apps/[Email Address Removed] on Win2000 Server, Oracle 9i
Error: ORA-12154: TNS:could not resolve service name

tnsnames.ora
¬¬¬¬¬¬¬¬¬¬
APPS=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = winapps)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = demo)
)
)
sqlnet.ora
¬¬¬¬¬¬¬¬¬
NAMES.DEFAULT_DOMAIN = winapps.com


But when I changed tnsnames.ora to following, it works
APPS.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = winapps)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = demo)
)
)
Now it works.
SQL> conn apps/[Email address protected]
Connected.
Also when I comment #NAMES.DEFAULT_DOMAIN = winapps.com, it works fine.

Can any one please let me know the significance of .world, why it is used ?
How it is related to SQLNET.ora file. All the above testing I did without
login as domain user.

Thanks

Oracle LazyDBA home page