Cannot run utlirp.sql Because Of ORA-1031 Errors (Doc ID 1202513.1)

Last updated on NOVEMBER 04, 2015

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

As part of migrating a database from a 32 bit platform to a 64 bit one it is necessary to run the utlirp.sql script. While running this script the following error is seen :


SQL>  @?\rdbms\admin\utlirp.sql
ORA-01031: insufficient privileges


The trace file generated by the 1031 errorstack event shows the following call stack:



ORA-01031: insufficient privileges
----- Current SQL Statement for this session (sql_id=3zwd8htqr10hv) -----
update obj$ set status = :"SYS_B_00"
where ((type# in (:"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10")) or
(type# = :"SYS_B_11" and subname is null))
and ((subname is null) or (subname <> :"SYS_B_12"))
and status not in (:"SYS_B_13",:"SYS_B_14")
and linkname is null
and not exists (select :"SYS_B_15"
from type$
where (bitand(properties, :"SYS_B_16") = :"SYS_B_17")
and toid = obj$.oid$)

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <- dbgdProcessEventAc <- tions <- VInfreq__dbgdChkE <- ventKgErr <- dbkdChkEventRdbmsE <- VInfreq___PGOSF34 <- ksfpec <- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgesev <- ksesec0 <- kzpchkbu <- PGOSF86__ksfchk <- kglchk3 <- kglchk1 <- qcsbxl <- qcspqbDescendents <- qcspqb <- kkmdrv <- opiSem <- opiDeferredSem <- opitca <- PGOSF526__kksFull <- TypeCheck <- rpiswu2 <- kksSetBindType <- 851 <- kksfbc <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- opimai <- OracleThreadStart@



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