Removing world from tnsnames

Using 8i, you may come across to this

you cant connect to the database if you dont put xxx.world in you TNSnames

So


If you dont want to use the default domain name go to
sqlnet.ora file D:\Oracle\Ora81\network\ADMIN\sqlnet.ora
if oracle 8i or in oracle8 in \network\ADMIN\sqlnet.ora

remove the NAMES.DEFAULT_DOMAIN or disable it with # before the parameter.

then ||rly comeback to tnsnames.ora file edit and remove the word WORLD.

TEST.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = padmam)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)