ORA-01034 error solution
- One of the common mistakes in Oracle
In advance, Oracle masters do not need to be seen.
This is a common error in the Oracle database server. Experienced users can solve this mistake almost immediately, and they can also go to Metalink (http://metalink.oracle.com) to search.
Unfortunately, most of them are the problems encountered by the primary users (what effects do not have to mention Metalink - generally do not have the top account :)). Therefore, this small post may have a certain role.
Problem Description =======
When trying to start the database, Oracle reports the following errors: error: ORA-27101 Shared Memory Realm Does Not Exist ORA-01034 Oracle Not Available
Basic explanation ======= error: ORA-27101 TEXT: Shared Memory Realm Does Not Exist ---------------------------------------------------------------------------------------------------------------- ---------------- Cause: Unable to locate shared memory realm action: verify That The Realm is accessible
How to solve =======
This problem can be clearly understood by this question:
Oracle_Home or Oracle_sid setting is incorrect.
In the previous version, if Oracle_sid is incorrect, only ORA-01034 is generally prompted. Oracle 8.1.7 gives an additional information: ORA-27101.
-> If you are UNIX, set the Oracle_SID to set the Oracle_SID in the shell (pay attention to sensitive problems). In addition, check the oracle_home environment variable. How to check the following command:
% Echo $ Oracle_sid% PS - EF | GREP SMON
-> If it is Windows, it is generally caused by multiple instances in the system.
Can be c: /> set oracle_sid = demo in the command line
Change the Demo here to your corresponding instance name.
If you still don't work, check the Oracle_home in the registry.
In addition, there is a remote database when there is a remote database when there is a Windows environment, and this error will be reported.
The solution is to change SQLNET.AUTHENTICATION_SERVICES = (NTS) NTS in the SQLNET.ORA file to NONE.
