domain name change stops client access to oracle

[alicante]

I need to change the w2k domain that my oracle 8i database is on. When i change the domain clients cannot connect to the database. I have looked in the tnsnames and pointed the host to both the name and ip address but to no avail. What am I missing?

 

[charudattas]

It is a Oracle network utility in which we specify the newly set machine details this happens because Oracle use OS protocols while interacting within client and server. Since the machine details are changed the Oracle info does not match with OS info.
This is a hint I will inform you as soon as I remember the name.

 

[DaPi]

If your internet domain name has changed as well as the MS domain name, you are now adrift in the naming conventions of Net8. (Lewis Carrol had something about: the poem, the name of the poem, what the poem was called, what the name of the poem was called etc. ALL DIFFERENT!)

sqlnet.ora can contain
NAMES.DEFAULT_DOMAIN = my.domain

initXXXX.ora can contain
db_domain = some.other.domain

Frankly I don't understand it (the Net8 doc is designed to shield the reader from the nasty details!) - but I think the above should 'fix' the names so that your TNS config is not aiming at a moving target.

 

[DaPi]

you'll need to look at listner.ora too.