ORA-27101: Shared Memory realm does not exist
The machine is a common HP household machine, and the driver is not very good for XP, but no error is reported in the Device Manager. Used for testing the upgrading of the unit server. Install the Win2000 SP4 + oracle817 patch.
Machine name server2, Global Database Name server2, SID = orcl. The machine memory is 512 MB. As required, the redo log size is set to 4096 and the character set is modified to us7ascii. Other default values for Oracle installation.
No error is reported in log when exporting data from the server.
Create a tablespace and make appropriate adjustments based on the tablespace on the original server. Created successfully.
When DMP is imported, some errors are reported, but the last row prompts successful import. Upon inquiry, the brothers thought that the error was irrelevant.
Client running, can be connected, can also run
Program.
However, after the instance is restarted, it cannot be connected. Use System/manager to access sqlplus,
Prompt ORA-01034: Oracle not available
ORA-27101:
Shared Memory RealmDoes not exist
Changing the sqlnet. ora authentication method to none is useless.
Solution:
1. Run cmd to enter the command line.
2. sqlplus/nolog3, Conn/As sysdba
4. startup
