sde版本为:9.3.1
oracle版本为:10.2.0.4 rac环境
sde服务启动的时候,报错。日志如下:
ST_Geometry Schema Owner: (SDE) Type Release: 1007 Instance initialized for ((sde)) . . . Connected to instance . . . DBMS Connection established... Error -51 in purge unused shared entries. DBMS error code: -6508 Error in PL/SQL block to clean upleftover entries for SDE instance ORA-06508: PL/SQL: could not find program unit being called ERROR: Cannot Initialize Shared Memory (-51)[/INDENT]
经排查,sde环境变量和授权均没有问题。又经现场人员回顾,之前oracle rac更换过磁盘组,可能与这个有关。猜测为sde部分package 有问题。
select * from dba_objects where status = 'INVALID' and owner='SDE'
执行后,发现有三条数据,
执行 alter package sde.*** compile 直到sde用户下所有package 都可用
然后再启动sde服务,发现sde可以正常使用