BACKGROUND PROCESSES START VERY SLOWLY AND SOMETIMES ORA-445 IS RAISED

(Doc ID 954245.1)

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)


Symptoms

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.

Changes

Upgrade from 9208 to 10.2.0.3 database

Cause

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