Database Administration (MOSC)

MOSC Banner

ORA-56938: occurs after alter session events '30090 NAME CONTEXT FOREVER, LEVEL 32'

Hi,

Upgraded database from 12R2 to 18c. No I plan to upgrade to 19c. This is a test for other databases already at 18c to determine what issues I will encounter. I ran the preupgrade .jar. Item below is causing a problem.

There is an unfinished DST update operation in the database. It's

    current state is: DATAPUMP(1)

-- did the following.

ALTER SESSION SET EVENTS '30090 TRACE NAME CONTEXT FOREVER, LEVEL 32';

exec dbms_dst.unload_secondary;

Results

ORA-56938: no secondary time zone data file being loaded by on-demand or a

datapump job

ORA-06512: at "SYS.DBMS_DST", line 1975

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center