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
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系統顯示Oracle系統設置的進程數為150,小於數據庫所在機器需要啟動的進程數。
exp username/password full=y file=file_name log=logname
說明:
username是用戶名。 password是用戶密碼。以root用戶登錄數據庫所在機器。 查詢進程pid。# ps -ef
根據pid關閉對應應用進程。# kill –pid
以sysdba用戶連接數據庫。% sqlplus / as sysdba
修改進程參數“processes”的參數值。SQL> alter system set processes=Oracle系統進程數 scope=spfile;;
說明:
需要修改的“Oracle系統進程數”大於系統實際啟動的進程數。
關閉數據庫。SQL> shutdown immediate
重新啟動數據庫。SQL> startup
退出數據庫。SQL> quit
以sysdba用戶重新登錄數據庫。% sqlplus / as sysdba
登錄成功,系統顯示如下信息:
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