Oracle Database case study-failed to log on to the Oracle database-the number of processes started is greater than the number of processes set by the Oracle System

1.1 symptom Description: failed to log on to the database. The system displays the following error message:
% Sqlplus/as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Feb 5 14:42:29 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ERROR:

ORA-00020: maximum number of processes (%s) exceeded

1.2 The possible cause is that the number of processes started on the machine where the database is located is greater than the number of processes set in the Oracle database. 1.3 locate the concept and check the number of processes set in the Oracle system.
SQL> show parameter process;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

aq_tm_processes                      integer     0

cell_offload_processing              boolean     TRUE

db_writer_processes                  integer     1

gcs_server_processes                 integer     0

global_txn_processes                 integer     1

job_queue_processes                  integer     1000

log_archive_max_processes            integer     4

processes                            integer     150

The system displays that the number of processes set by the Oracle system is 150, which is smaller than the number of processes to be started on the machine where the database is located. 1.4 procedure OracleThe machine on which the user logs on to the database. Back up the database logically.

Exp Username/password Full = y file = file_name log = logname

Note:

Username is the user name. Password is the user password. To RootThe machine on which the user logs on to the database. Query Process Pid.

# Ps-ef

According PidClose the application process.

# Kill-Pid

To SysdbaThe user connects to the database.

% Sqlplus/as sysdba

Modify the value of the process parameter "processes.

SQL> alter system set processes =OracleNumber of System Processes Scope = spfile;;

Note:

The number of Oracle system processes to be modified is greater than the number of processes actually started by the system.

Shut down the database.

SQL> shutdown immediate

Restart the database.

SQL> startup

Log out of the database.

SQL> quit

To SysdbaLog on to the database again.

% Sqlplus/as sysdba

Log on successfully. The system displays the following information:

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Aug 24 08:45:02 2011 

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options