BACKGROUND PROCESSES START VERY SLOWLY AND SOMETIMES ORA-445 IS RAISED
Last updated on APRIL 24, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
IBM z/OS on System z
***Checked for relevance on 13-06-2014***
IBM z/OS (OS/390)
After upgrading Database to version 10203 and patch B8709649 the background processes startup successfully but it takes 40-120 second to start every background process according to alert logs.
Sometimes the startup fails if any process starts more than 120 sec with error message:
|15:41:02.86 00100000 ILAT =13
15:41:02.89 00100000 LICENSE_MAX_USERS = 0
15:41:02.89 00100000 SYS auditing is disabled
15:41:02.90 00100000 ksdpec: called for event 13740 prior to event group initialization
15:41:02.91 00100000 Starting up ORACLE RDBMS Version: 10.2.0.3.0.
15:41:02.91 00100000 optimizer_index_cost_adj = 10
15:41:02.91 00100000 pga_aggregate_target = 104857600
15:42:26.64 00030001 PMON started with pid=2, OS id=00030001
15:44:28.83 00100000 USER: terminating instance due to error 445
15:44:35.66 00100000 Termination issued to instance processes. Waiting for the processes to exit
Database 9208 started quickly correctly in the same lpar and processes are starting quickly also.
Upgrade from 9208 to 10.2.0.3 database
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms