How to Shut Down an ORA-04031 Oracle Database
If you are running an Oracle database system that produces the ORA-04031 error when trying to shut it down, you must force a shutdown with the 'shutdown immediate' parameter. ORA-04031 is produced when attempting to adjust the memory allowance to that database. There are various types of shut down commands based on what you are trying to do. The normal command will not work with error-based databases, therefore you must use a special command. These are issued from the Oracle command line.
Other People Are Reading
Instructions
-
-
1
Open the Oracle command line if it isn't already open.
-
2
Type "SHUTDOWN IMMEDIATE NAME" without quotes.
-
-
3
Replace "NAME" with the name of your database, then press "Enter" to shut it down.
-
4
Enter the "STARTUP" command to start it again.
-
1
