On Tue, 2006-04-04 at 15:20, Seah Hong Yee wrote:
>
> I kept seeing the following line appear on my alert log.
>
> Are these to be concerned with ?
>
> Thanks
>
>
> Errors in file /u01/app/oracle/admin/compiere/udump/compiere_ora_30803.trc:
> 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
> Mon Apr 3 02:00:18 2006
> Shutting down instance (immediate)
>

Oddly enough yes. It would appear that the OLAPI triggers are installed
and seeded on your DB, but you haven't installed OLAP?

Diable olapistartuptrigger and olapishutdowntrigger and the errors will
stop:

alter trigger olapistartuptrigger disable;
alter trigger olapishitdowntrigger disable;

and try again.

Cheers,

Pete





--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting