I have an Oracle DB (22.214.171.124.0) on an old NT domain. The rest of the domain has been moved to Windows 2003 AD, and today I disjoined the Oracle server from the old domain and joined it to the new domain. As you might expect, when I tried to access the Oracle instance it failed to start with error "ORA-27101: shared memory realm does not exist." If I disjoin the machine from the Win2003 domain and put it back in the NT domain, Oracle comes back to life without error.
I am guessing that either there is something in the tnslistener.ora or init.ora file that points to the machine by its fdn but cannot locate the reference to correct it so I can try again. Is there an obvious process you must follow in order to get the Oracle instance to function if you move domains? In terms of Oracle experience I am a severe beginner. Thanks.
Check the init<SID>.ora file and the sqlnet.ora file for references to the old domain name. The old domain name may also be specified in the global_name of the database.
You should view the oradim.log file to see if there are any errors, as well as the Windows event viewer. One final thing to try is whether the database starts up and opens manually rather than via the service. You can set the service to only start the instance, then you can manually open the database.
This was first published in February 2006