ORA-03113/03114 Processing

ORA-03113/03114 handle if the database does not set the correct OS core variable during installation, it may be okay when installing the database file, when creating a database, the error 03113 is often returned. Another reason for this is that the processes parameter in the init. ora parameter file specifies an unreasonable value, causing an error when the database is started (of course, this is also the core parameter problem in the final analysis ). This error message is generally as follows: ORA-03113: end-of-file on communication channelORA-01034: ORACLE not availableORA-27101: shared memory realm does not exist solution has two: 1. Modify core parameters, increase the value of the corresponding core parameter (recommended); 2. Reduce init. the Processes value of the ora parameter. Note that SEMMSL must be set to at least 10 + 'maximum Number of processs', and SEMMNS also depends on the process parameter values of each database. Note: This error type only appears on Unix platforms. On Windows, if the processes value is too large, an error similar to the following occurs: ORA-00068: invalid value 24200001 for parameter max_rollback_segments, must be between 2 and 65535/* The specified parameter value exceeds 65535 */or a large parameter value with ORA-27102: out of memory/* Less Than 65535 */software environment: windows 2000 Version 5.0 Service Pack 3, CPU type 586 oracle rdbms Version: 8.1.7.0.0