Re: Oracle 10g error

From: Steve Perry <sperry_at_sprynet.com>
Date: Wed, 12 Apr 2006 21:43:42 -0500
Message-Id: <3379EC55-078A-4C3D-A189-458FF5225B45@sprynet.com>

I think this is for Oracle SE and using DBCA to create the database from a template.
Here are my notes on it.

steve

see Note:266728.1

BUG 3386542 - OLAPI trggers that are installed with seed database, (OLAPISTARTUPTRIGGER and OLAPISHUTDOWNTRIGGER), does not handle absence of Oracle OLAP.

ALTER TRIGGER OLAPISTARTUPTRIGGER DISABLE; ALTER TRIGGER OLAPISHUTDOWNTRIGGER DISABLE; On Apr 4, 2006, at 07:29 AM, ora_forum wrote:

> Hi All:
>
> After creating new 10gR2 database on Sun I receiving this message
> every day:
>
> Mon Apr 3 23:22:41 2006
> ORA-00604: error occurred at recursive SQL level 1
> Mon Apr 3 23:22:41 2006
> ORA-12663: Services required by client not available on the server
> Mon Apr 3 23:22:41 2006
> ORA-36961: Oracle OLAP is not available.
> Mon Apr 3 23:22:41 2006
> ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
> Mon Apr 3 23:22:41 2006
> ORA-06512: at line 15
>
> But I'm not using OLAP?
>
> Thanks.
>
> Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and
> 30+ countries) for 2¢/min or less.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 12 2006 - 21:43:42 CDT