LINUX AS3下ORACLE 从9.2.0.1升级到9.2.0.4出现个问题

xiete

不同STARTUP下
SQL> create table t (id number);
create table t (id number)
*
ERROR 位于第 1 行:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2

startup migrate下:
SQL>  create table t (id number);

表已创建。

coolyl

This is bug3090258 (not published yet, you may not see it on Metalink)

which will be fixed in 92041.

For now use the workaround:


Run the commands below as olapsys


drop table olapsys.olap_session_objects
/
create global temporary table olapsys.olap_session_objects (
version_id char(4),
objtype char(4),
id number
)
on commit preserve rows
/
ALTER PACKAGE olapsys.cwm2_olap_mr_session_pop COMPILE BODY
/
ALTER PACKAGE olapsys.cwm2_olap_verify_access COMPILE BODY
/
ALTER VIEW olapsys.mrv$mrall_cwm1_aggop COMPILE
/
ALTER VIEW olapsys.mrv$mrall_cwm1_aggord COMPILE
/
ALTER VIEW olapsys.mrv$olap1_facttblfctmaps COMPILE
/
ALTER VIEW olapsys.mrv$olap1_facttblkeymaps COMPILE
/
ALTER VIEW olapsys.mrv$olap2_agg_uses COMPILE
/
ALTER VIEW olapsys.mrv$olap2_catalog_entity_uses COMPILE
/
ALTER VIEW olapsys.mrv$olap2_cube_measures COMPILE
/
ALTER VIEW olapsys.mrv$olap2_dim_attributes COMPILE
/
ALTER VIEW olapsys.mrv$olap2_dim_hierS COMPILE
/
ALTER VIEW olapsys.mrv$olap2_dim_hier_level_uses COMPILE
/
ALTER VIEW olapsys.mrv$olap2_dim_level_attr_maps COMPILE
/
ALTER VIEW olapsys.mrv$olap2_entity_desc_uses COMPILE
/
ALTER VIEW olapsys.mrv$olap2_facttblfctmaps COMPILE
/
ALTER VIEW olapsys.mrv$olap2_facttblkeymaps COMPILE
/
ALTER VIEW olapsys.mrv$olap2_hierdims COMPILE
/
ALTER VIEW olapsys.mrv$olap2_hierdim_keycol_map COMPILE
/
ALTER VIEW olapsys.mrv$olap2_hier_custom_sort COMPILE
/
ALTER VIEW olapsys.mrv$olap2_join_key_col_uses COMPILE
/
ALTER VIEW olapsys.mrv$olap2_listdims COMPILE
/

xiete

[oracle@localhost admin]$ sqlplus

SQL*Plus: Release 9.2.0.4.0 - Production on ÐÇÆÚËÄ 12ÔÂ 16 16:50:24 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: olapsys/olapsys
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2

之后我用SYS用户做的
错误依旧

coolyl

最初由 xiete 发布
[B][oracle@localhost admin]$ sqlplus

SQL*Plus: Release 9.2.0.4.0 - Production on ÐÇÆÚËÄ 12ÔÂ 16 16:50:24 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: olapsys/olapsys
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2

之后我用SYS用户做的
错误依旧 [/B]

这就奇怪了，metalink有个跟你一样的错误，就这么解决的。
如果实在不行试试升级到9205吧，metalink说92041解决了这个问题的

xiete

我会把结果贴上来