OraFAQ Forum: Server Administration » ERROR in executing triggers

Home » RDBMS Server » Server Administration » ERROR in executing triggers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ERROR in executing triggers [message #153295]

Fri, 30 December 2005 20:19

760613
Messages: 16
Registered: March 2005

Junior Member

Hi,
please help me to solve this, I ve searched the web but could not find any good answer.

I see this errors during oracle 10g shutdown, and startup.
It is a pretty new installed oracle.
Did I miss something during the installation ???

Please advice,

THANKS

SHUTDOWN

Oracle Database 10g Release 10.1.0.3.0 - Production
ORACLE_HOME = /u01/app/oracle/product/10.1.0.3/db_1
System name:    SunOS
Node name:      testapp1
Release:        5.10
Version:        Generic_118844-20
Machine:        i86pc
Instance name: test1
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 3502, image: oracle@testapp1 (TNS V1-V3)
 
*** SERVICE NAME:(SYS$USERS) 2005-12-30 02:11:49.667
*** SESSION ID:(75.341) 2005-12-30 02:11:49.667
[B]Error in executing triggers on instance shutdown[/B]
*** 2005-12-30 02:11:49.668
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 6
*** 2005-12-30 02:11:55.883 52278 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
*** 2005-12-30 02:11:56.920 52278 kcrr.c
ARCH: Archival disabled due to shutdown: 1089

STARTUP

-bash-3.00$  cat test1_ora_3579.trc
/u01/app/oracle/admin/test1/udump/test1_ora_3579.trc
Oracle Database 10g Release 10.1.0.3.0 - Production
ORACLE_HOME = /u01/app/oracle/product/10.1.0.3/db_1
System name:    SunOS
Node name:      testapp1
Release:        5.10
Version:        Generic_118844-20
Machine:        i86pc
Instance name: test1
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 3579, image: oracle@testapp1 (TNS V1-V3)
 
*** SERVICE NAME:(SYS$USERS) 2005-12-30 02:14:12.697
*** SESSION ID:(107.3) 2005-12-30 02:14:12.697
adbdrv:  lang flag = 0
[B]Error in executing triggers on database startup[/B]
*** 2005-12-30 02:14:14.932
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 7

Report message to a moderator