Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error after Oracle installation

I've just installed an Oracle 8.1.7 Database on my PC (which runs Windows NT). After the installation, I log on to the database to create several additional tablespaces, I have no problem until then. When I restarted my PC, I couldn't get access the database anymore. ORA-27101 error appears since that moment.

27101, 00000, "shared memory realm does not exist"
// *Cause: Unable to locate shared memory realm
// *Action: Verify that the realm is accessible

You probably need to set your database service to start automatically. If it is started automatically, then you probably need to reconfigure the registry entries to set your SID to start automatically (since the service does not necessarily start an instance). If memory serves, you'll want to review the registry entries at HKLMSoftwareOracleHome0 and look for registry keys that have your ORACLE_SID name in them. One of them will be a Boolean (TRUE/FALSE) setting for whether or not to start the instance.

Dig Deeper on Oracle database installation, upgrades and patches

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close