Q

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."

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.

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

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close