ReSQL.ru
     
powered by simpleCommunicator - 2.0.51     © 2025 Programmizd 02
Мобильная версия    Контакт    Правила    FAQ    Помощь
Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр
Форумы / Oracle [игнор отключен] [закрыт для гостей] / 12.1.0.2 при старте: ORA-00020: maximum number of processes (550) exceeded
5 сообщений из 5, страница 1 из 1
12.1.0.2 при старте: ORA-00020: maximum number of processes (550) exceeded
    #40011754
ora_dummy
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ora_dummy
Гость
Добрый день.
12.1.0.2
Win 2008 R1. x64.
При работе столкнулся с ORA-00020: maximum number of processes (550) exceeded.
Увеличил processes до 550.
shutdown immediate;
Рестарт винды.

Получил:
Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
Starting ORACLE instance (normal) (OS id: 648)
Fri Oct 23 08:15:40 2020
CLI notifier numLatches:7 maxDescs:932
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 4
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =70
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
Windows NT Version V6.1 Service Pack 1 
CPU                 : 4 - type 8664, 4 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:14792M/16383M, Ph+PgF:27909M/32765M 
VM name             : VMWare Version (6)
Using parameter settings in server-side spfile C:\APP\ADMLOCAL\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEMES2010.ORA
System parameters with non-default values:
  processes                = 550
  sga_max_size             = 3424M
  pga_aggregate_limit      = 2397483648
  sga_target               = 3424M
  control_files            = "C:\APP\ADMLOCAL\ORADATA\MES2010\CONTROL01.CTL"
  control_files            = "C:\APP\ADMLOCAL\RECOVERY_AREA\MES2010\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "12.1.0.2.0"
  log_archive_dest_1       = "LOCATION=E:\OracleArch"
  db_recovery_file_dest    = "C:\app\admlocal\recovery_area"
  db_recovery_file_dest_size= 6420M
  transactions             = 700
  undo_tablespace          = "UNDOTBS1"
  sec_case_sensitive_logon = FALSE
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=mes2010XDB)"
  audit_file_dest          = "C:\APP\ADMLOCAL\ADMIN\MES2010\ADUMP"
  audit_trail              = "DB"
  db_name                  = "mes2010"
  db_unique_name           = "mes2010"
  open_cursors             = 300
  pga_aggregate_target     = 819M
  diagnostic_dest          = "C:\APP\ADMLOCAL"
Deprecated system parameters with specified values:
  sec_case_sensitive_logon 
End of deprecated system parameter listing
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
PMON started with pid=2, OS id=4180 
Starting background process PSP0
PSP0 started with pid=3, OS id=4668 
Starting background process VKTM
VKTM started with pid=4, OS id=4660 at elevated (Time Critical) priority
Fri Oct 23 08:15:43 2020
VKTM running at (5)millisec precision with DBRM quantum (100)ms
Starting background process GEN0
GEN0 started with pid=5, OS id=3608 
Starting background process MMAN
MMAN started with pid=6, OS id=2032 
Starting background process DIAG
DIAG started with pid=8, OS id=4692 
Starting background process DBRM
DBRM started with pid=9, OS id=4684 
Starting background process VKRM
VKRM started with pid=10, OS id=4676 
Starting background process DIA0
DIA0 started with pid=11, OS id=4708 
Starting background process DBW0
DBW0 started with pid=12, OS id=4716 
Starting background process LGWR
LGWR started with pid=13, OS id=260 
Starting background process CKPT
CKPT started with pid=14, OS id=3688 
Starting background process SMON
SMON started with pid=16, OS id=3432 
Starting background process RECO
RECO started with pid=18, OS id=4000 
Starting background process LREG
LREG started with pid=19, OS id=4436 
Starting background process PXMN
PXMN started with pid=20, OS id=3672 
Starting background process MMON
MMON started with pid=21, OS id=4856 
Starting background process MMNL
MMNL started with pid=22, OS id=1136 
Fri Oct 23 08:15:47 2020
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = C:\app\admlocal
alter database mount exclusive
Fri Oct 23 08:15:56 2020
Successful mount of redo thread 1, with mount id 29623348
Fri Oct 23 08:15:56 2020
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Ping without log force is disabled
.
Fri Oct 23 08:15:58 2020
Beginning crash recovery of 1 threads
 parallel recovery started with 3 processes
Fri Oct 23 08:15:58 2020
Started redo scan
Fri Oct 23 08:15:59 2020
Completed redo scan
 read 333 KB redo, 205 data blocks need recovery
Fri Oct 23 08:15:59 2020
Started redo application at
 Thread 1: logseq 6132, block 3
Fri Oct 23 08:15:59 2020
Recovery of Online Redo Log: Thread 1 Group 3 Seq 6132 Reading mem 0
  Mem# 0: C:\APP\ADMLOCAL\ORADATA\MES2010\REDO03.LOG
Fri Oct 23 08:15:59 2020
Completed redo application of 0.23MB
Fri Oct 23 08:16:00 2020
Completed crash recovery at
 Thread 1: logseq 6132, block 670, scn 126676087126
 205 data blocks read, 205 data blocks written, 333 redo k-bytes read
Starting background process TMON
TMON started with pid=28, OS id=1956 
Fri Oct 23 08:16:00 2020
LGWR: STARTING ARCH PROCESSES
Starting background process ARC0
ARC0 started with pid=29, OS id=5032 
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Fri Oct 23 08:16:00 2020
ARC0: STARTING ARCH PROCESSES
Starting background process ARC1
ARC1 started with pid=30, OS id=5040 
Fri Oct 23 08:16:00 2020
Thread 1 advanced to log sequence 6133 (thread open)
Thread 1 opened at log sequence 6133
  Current log# 1 seq# 6133 mem# 0: C:\APP\ADMLOCAL\ORADATA\MES2010\REDO01.LOG
Successful open of redo thread 1
Fri Oct 23 08:16:00 2020
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Oct 23 08:16:00 2020
SMON: enabling cache recovery
Starting background process ARC2
ARC2 started with pid=31, OS id=3920 
Starting background process ARC3
Fri Oct 23 08:16:01 2020
ARC1: Archival started
ARC2: Archival started
Fri Oct 23 08:16:01 2020
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
Fri Oct 23 08:16:01 2020
ARC1: Becoming the heartbeat ARCH
ARC3 started with pid=33, OS id=3824 
Fri Oct 23 08:16:02 2020
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Fri Oct 23 08:16:02 2020
Archived Log entry 6135 added for thread 1 sequence 6132 ID 0x192471d dest 1:
Fri Oct 23 08:16:05 2020
[2088] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:362998 end:366103 diff:3105 ms (3.1 seconds)
Verifying minimum file header compatibility (11g) for tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Fri Oct 23 08:16:06 2020
SMON: enabling tx recovery
Starting background process SMCO
SMCO started with pid=34, OS id=4964 
Fri Oct 23 08:16:06 2020
Database Characterset is CL8MSWIN1251
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Oct 23 08:16:11 2020
ORA-00020: maximum number of processes (550) exceeded
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.
Starting background process AQPC
Process AQPC submission failed with error = 20
Fri Oct 23 08:16:13 2020
Errors in file C:\APP\ADMLOCAL\diag\rdbms\mes2010\mes2010\trace\mes2010_ora_2088.trc:
ORA-00444: сбой фонового процесса "AQPC" во время запуска
ORA-00020: превышено максимальное количество процессов ()
Fri Oct 23 08:16:13 2020
Errors in file C:\APP\ADMLOCAL\diag\rdbms\mes2010\mes2010\trace\mes2010_ora_2088.trc:
ORA-00450: фоновый процесс 'AQPC' не запущен
ORA-00444: сбой фонового процесса "AQPC" во время запуска
ORA-00020: превышено максимальное количество процессов ()
Fri Oct 23 08:16:13 2020
Errors in file C:\APP\ADMLOCAL\diag\rdbms\mes2010\mes2010\trace\mes2010_ora_2088.trc:
ORA-00450: фоновый процесс 'AQPC' не запущен
ORA-00444: сбой фонового процесса "AQPC" во время запуска
ORA-00020: превышено максимальное количество процессов ()
Fri Oct 23 08:16:13 2020
Error 450 happened during db open, shutting down database
USER (ospid: 2088): terminating the instance due to error 450



Длаее:
Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 3590324224 bytes
Fixed Size                  3051856 bytes
Variable Size             922750640 bytes
Database Buffers         2650800128 bytes
Redo Buffers               13721600 bytes
Database mounted.
ORA-00450: background process 'CJQ0' did not start
ORA-00444: background process "CJQ0" failed while starting
ORA-00020: maximum number of processes () exceeded


БД открыта.
Не понял, как при старте можно такое получить.
...
Рейтинг: 0 / 0
26.10.2020, 03:43
| Ответить | Цитировать | Написать  
12.1.0.2 при старте: ORA-00020: maximum number of processes (550) exceeded
    #40011755
ora_dummy
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ora_dummy
Гость
Содержимое трейса:
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
Trace file C:\APP\ADMLOCAL\diag\rdbms\mes2010\mes2010\trace\mes2010_ora_2088.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Windows NT Version V6.1 Service Pack 1 
CPU                 : 4 - type 8664, 4 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:11519M/16383M, Ph+PgF:27847M/32765M 
VM name             : VMWare Version (6)
Instance name: mes2010
Redo thread mounted by this instance: 1
Oracle process number: 25
Windows thread id: 2088, image: ORACLE.EXE (SHAD)


*** 2020-10-23 08:15:56.274
*** SESSION ID:(213.64708) 2020-10-23 08:15:56.274
*** CLIENT ID:() 2020-10-23 08:15:56.274
*** SERVICE NAME:() 2020-10-23 08:15:56.274
*** MODULE NAME:(oradim.exe) 2020-10-23 08:15:56.274
*** CLIENT DRIVER:() 2020-10-23 08:15:56.274
*** ACTION NAME:() 2020-10-23 08:15:56.274
 
krsd_cb_role_change: role 1

*** 2020-10-23 08:15:58.848
Successfully allocated 3 recovery slaves
Using 45 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 6132, block 2, scn 126676086431
  cache-low rba: logseq 6132, block 3
    on-disk rba: logseq 6132, block 670, scn 126676087126
Synchronized sync destination connectivity mask for thread 1 is 0x0
  start recovery at logseq 6132, block 3, scn 0

*** 2020-10-23 08:15:59.019
Started writing zeroblks thread 1 seq 6132 blocks 670-677

*** 2020-10-23 08:15:59.035
Completed writing zeroblks thread 1 seq 6132
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 333Kb in 0.15s => 2.17 Mb/sec
Longest record: 0Kb, moves: 0/962 (0%)
Longest LWN: 16Kb, moves: 0/298 (0%), moved: 0Mb
Last redo scn: 0x001d.7e7bb155 (126676087125)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 262144
Longest hash chain = 1
Average hash chain = 205/205 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 1426/1631 = 0.9
----------------------------------------------

*** 2020-10-23 08:15:59.035
KCRA: start recovery claims for 205 data blocks

*** 2020-10-23 08:15:59.534
KCRA: blocks processed = 205/205, claimed = 205, eliminated = 0

*** 2020-10-23 08:15:59.643
Recovery of Online Redo Log: Thread 1 Group 3 Seq 6132 Reading mem 0

*** 2020-10-23 08:15:59.659
Completed redo application of 0.23MB

*** 2020-10-23 08:16:00.111
Completed recovery checkpoint
----- Recovery Hash Table Statistics ---------
Hash table buckets = 262144
Longest hash chain = 1
Average hash chain = 205/205 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 1631/1631 = 1.0
----------------------------------------------
Recovery sets nab of thread 1 seq 6132 to 670 with 8 zeroblks

*** 2020-10-23 08:16:08.395
Count of ofsmtab$: 0 entries

*** 2020-10-23 08:16:13.777
 10/23/2020 08:16:10 10/23/2020 08:16:11ORA-00020: превышено максимальное количество процессов (550)
ORA-00444: сбой фонового процесса "AQPC" во время запуска
ORA-00020: превышено максимальное количество процессов ()
ORA-00450: фоновый процесс 'AQPC' не запущен
ORA-00444: сбой фонового процесса "AQPC" во время запуска
ORA-00020: превышено максимальное количество процессов ()
ORA-00450: фоновый процесс 'AQPC' не запущен
ORA-00444: сбой фонового процесса "AQPC" во время запуска
ORA-00020: превышено максимальное количество процессов ()

*** 2020-10-23 08:16:13.777
USER (ospid: 2088): terminating the instance due to error 450
...
Рейтинг: 0 / 0
26.10.2020, 03:54
| Ответить | Цитировать | Написать  
12.1.0.2 при старте: ORA-00020: maximum number of processes (550) exceeded
    #40011859
Фотография Vadim Lejnin
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Vadim Lejnin
Участник
авторПри работе столкнулся с ORA-00020: maximum number of processes (550) exceeded.
Увеличил processes до 550.


Было 550, стало 550...


Код: plsql
1.
2.
3.
...
  transactions             = 700
...




Oracle Documentation -> Reference PROCESSES
...
The default values of the SESSIONS and TRANSACTIONS parameters are derived from this parameter. Therefore, if you change the value of PROCESSES, you should evaluate whether to adjust the values of those derived parameters.
...


С какой целью экономите параметр?
параметры определяют размерность внутренних структур, с учетом современных RAM, разница 550 и 2048, это копейки
Сделайте
Код: plsql
1.
2.
3.
processes 4096
sessions 8192
transactions 4096



автор...
БД открыта.
Не понял, как при старте можно такое получить.


У Вас свалился
AQPC

AQ Process Coordinator

Per instance AQ global coordinator

AQPC is responsible for performing administrative tasks for AQ Master Class Processes including commands like starting, stopping, and other administrative tasks. This process is automatically started on instance startup.


Или, если кто то выкрутил настройки connect pool приложения, стартует сразу много сессий этого пула.


p.s. параметр устарел, уберите
Deprecated system parameters with specified values:
sec_case_sensitive_logon
...
Рейтинг: 0 / 0
26.10.2020, 13:34
| Ответить | Цитировать | Написать  
12.1.0.2 при старте: ORA-00020: maximum number of processes (550) exceeded
    #40011949
landy
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
landy
Участник
Vadim Lejnin,
p.s. параметр устарел, уберите
Deprecated system parameters with specified values:
sec_case_sensitive_logon


Да убрать-то не проблема, только у него может половина приклада отвалиться )))
А как водится - пароль давно забыли и где вводить - тоже
...
Рейтинг: 0 / 0
26.10.2020, 17:09
| Ответить | Цитировать | Написать  
12.1.0.2 при старте: ORA-00020: maximum number of processes (550) exceeded
    #40016719
ora_dummy
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ora_dummy
Гость
Vadim Lejnin
Сделайте
Код: plsql
1.
2.
3.
processes 4096
sessions 8192
transactions 4096




По объему памяти проблем не будет ?
Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
Memory (Avail/Total): Ph:14792M/16383M, Ph+PgF:27909M/32765M 
VM name             : VMWare Version (6)
Using parameter settings in server-side spfile C:\APP\ADMLOCAL\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEMES2010.ORA
System parameters with non-default values:
  processes                = 550
  sga_max_size             = 3424M
  pga_aggregate_limit      = 2397483648
  sga_target               = 3424M
...
Рейтинг: 0 / 0
10.11.2020, 03:49
| Ответить | Цитировать | Написать  
5 сообщений из 5, страница 1 из 1
Форумы / Oracle [игнор отключен] [закрыт для гостей] / 12.1.0.2 при старте: ORA-00020: maximum number of processes (550) exceeded
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение
NoSQL.ru       Новости, Чат       Фотоальбом: Участники, Встречи
Закрыть
start [/forum/search_topic.php?author=_%D0%93%D0%BE%D1%81%D1%82%D1%8C_%D1%81_%D0%B2%D0%BE%D0%BF%D1%80%D0%BE%D1%81%D0%BE%D0%BC&author_mode=last_topics&do_search=1]:
 0ms
get settings:
 10ms
get forum list:
 11ms
get settings:
 8ms
get forum list:
 13ms
check forum access:
 3ms
check topic access:
 3ms
track hit:
 46ms
get topic data:
 10ms
get forum data:
 2ms
get page messages:
 41ms
get tp. blocked users:
 1ms
others: 445ms
total:  593ms
созд. / загр.: 593ms
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]