Database Administration (MOSC)

MOSC Banner

ORA-07445 after patch 27 of 10.2.0.4

edited Oct 30, 2009 3:28AM in Database Administration (MOSC) 10 commentsAnswered
I applied the patch 27 on Oracle 10.2.0.4 for Win 2003 x64 (before was applied patch 25). No problems on opatch, catcpu.sql, view_recompile... execution. But now this simple script (as SYSTEM user) breaks the sqlplus connection that launches it:

select OBJECT_NAME from ALL_OBJECTS a
where  object_type in ('TABLE','VIEW')
and NOT EXISTS (SELECT TABLE_NAME from MY_SW_SYS_SCHEMA.MY_SW_METADATA WHERE a.OWNER||'.'||a.OBJECT_NAME = MY_SW_TABLE)

and I found in the trace file:

ORA-07445 ... memory dump [ACCESS_VIOLATION] [kkoajt+74] [PC:0x1B4A9AA] [ADDR:0x0] [UNABLE_TO_READ] []

The sql script ran fine when there was patch 25.

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