Problém 60:
Tue Sep 20 08:12:48 2011
Errors in file /data/oracle/admin/gf/udump/prod_ora_19786.trc:
ORA-00604: Vyskytla s chyba v rekurzĂ­vnĂ­ Ăşrovni SQL 1
ORA-06521: PL/SQL: Chyba pĹi mapovĂĄnĂ­ funkce
ORA-06512: na „SYS.OLAPIHISTORYRETENTION“, line 1
ORA-06512: na line 6
Tue Sep 20 08:12:48 2011
Řešení:

SQL> select * from v$option where parameter like ‚%OLAP%‘;
PARAMETER VALUE
—————————————————————-
OLAP Window Functions TRUE
OLAP FALSE
SQL> select comp_name, version, status from dba_registry where comp_name like ‚%OLAP%‘;
COMP_NAME VERSION STATUS
——————————————————————————–
OLAP Analytic Workspace 10.1.0.2.0 OPTION OFF
Oracle OLAP API 10.1.0.2.0 OPTION OFF
OLAP Catalog 10.1.0.2.0 OPTION OFF

SQL> SELECT TRIGGER_NAME FROM DBA_TRIGGERS WHERE TRIGGERING_EVENT LIKE ‚%STARTUP%‘;
TRIGGER_NAME
——————————
OLAPISTARTUPTRIGGER
AURORA$SERVER$STARTUP
SQL> alter trigger AURORA$SERVER$STARTUP disable;
Trigger zmenen.
SQL> alter trigger OLAPISTARTUPTRIGGER disable;
Trigger zmenen.
SQL> shutdown immediate;
Databaze zavrena.
Databaze odpojena (dismounted).
Instance ORACLE uzavrena.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
Instance ORACLE spustena.
Total System Global Area 1577058304 bytes
Fixed Size 779560 bytes
Variable Size 367794904 bytes
Database Buffers 1207959552 bytes
Redo Buffers 524288 bytes
Databaze pripojena (mounted).
Databaze otevrena.



Komentáře