Ask the Expert

ORA-27101 error after moving DB to new domain

I have an Oracle DB (8.1.7.0.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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: