Oracle 10g error: shared memory realm does not exist

Oracle 10gError: shared memory realm does not exist analysis and solution is the content we will introduce in this article, the situation is as follows: an error occurs when connecting to Oracle 10 GB: "shared memory realm does not exist", as shown in:

This error occurs when Sqlplus is connected. After analysis, the solution is found.

Solution:

At the beginning of this article, I raised the question. Here I will solve the problem. Why is that the Oracle database is not started? The solution is to open the database as shown in the above 3;

One of the most direct manifestations of the above problems: view the Task ManagerOracle.exeOccupiedMemoryWhen oracle.exeoccupies dozens of megabytes of memory, the normal oracle.exe occupies the following memory:

Current restoration error: the data warehouse is connected after the data warehouse is closed, and memory occupied by oracle.exe

View memory:

Compared with normal startup, it is relatively different. Therefore, the solution to "shared memory realm does not exist" is as follows:

(1) memory occupied by oracle.exein the task manager. When oracle.exe occupies only dozens of megabytes of memory, the problem is that the database is not started.

(2) Start the Oracle database, log on as an administrator, and start the database.

Java code:

 
 

  
  
sqlplus /nolog     
  
  
conn USER/PASSWORD as sysdba     
  
  
startup 
 
 

The above is the Oracle 10g error: shared memory realm does not exist solution. We will introduce it here. I hope this introduction will be helpful to you!