今天在Solaris平臺(tái)的測(cè)試環(huán)境上安裝了Oracle Grid control 10.2.0.1，安裝及配置完成后，發(fā)現(xiàn)在登錄9i數(shù)據(jù)庫(kù)的tablespace維護(hù)頁(yè)面時(shí)，頁(yè)面處于長(zhǎng)時(shí)間的等待狀況。最終返回錯(cuò)誤信息。該頁(yè)面在打開其他較小的數(shù)據(jù)庫(kù)的頁(yè)面時(shí)，均能正常訪問。

解決：

在9i數(shù)據(jù)庫(kù)的后臺(tái)，查找到以下的SQL腳本：

SELECT?? d.tablespace_name, NVL (a.BYTES / 1024 / 1024, 0),

DECODE (d.CONTENTS,

'UNDO', NVL (u.BYTES, 0) / 1024 / 1024,

NVL (a.BYTES - NVL (f.BYTES, 0), 0) / 1024 / 1024

),

DECODE (d.CONTENTS,

'UNDO', NVL (u.BYTES / a.BYTES * 100, 0),

NVL ((a.BYTES - NVL (f.BYTES, 0)) / a.BYTES * 100, 0)

),

DECODE (d.CONTENTS,

'UNDO', NVL (a.BYTES - NVL (u.BYTES, 0), 0) / 1024 / 1024,

NVL (f.BYTES, 0) / 1024 / 1024

),

d.status, a.COUNT, d.CONTENTS, d.extent_management,

d.segment_space_management

FROM SYS.dba_tablespaces d,

(SELECT?? tablespace_name, SUM (BYTES) BYTES, COUNT (file_id) COUNT

FROM dba_data_files

GROUP BY tablespace_name) a,

(SELECT?? tablespace_name, SUM (BYTES) BYTES

FROM dba_free_space

GROUP BY tablespace_name) f,

(SELECT?? tablespace_name, SUM (BYTES) BYTES

FROM dba_undo_extents

WHERE status IN ('ACTIVE', 'UNEXPIRED')

GROUP BY tablespace_name) u

WHERE d.tablespace_name = a.tablespace_name(+)

AND d.tablespace_name = f.tablespace_name(+)

AND d.tablespace_name = u.tablespace_name(+)

AND NOT (d.extent_management = 'LOCAL' AND d.CONTENTS = 'TEMPORARY')

AND d.tablespace_name LIKE :b1

UNION ALL

SELECT?? d.tablespace_name, NVL (a.BYTES / 1024 / 1024, 0),

NVL (t.BYTES, 0) / 1024 / 1024, NVL (t.BYTES / a.BYTES * 100, 0),

(NVL (a.BYTES, 0) / 1024 / 1024 - NVL (t.BYTES, 0) / 1024 / 1024),

d.status, a.COUNT, d.CONTENTS, d.extent_management,

d.segment_space_management

FROM SYS.dba_tablespaces d,

(SELECT?? tablespace_name, SUM (BYTES) BYTES, COUNT (file_id) COUNT

FROM dba_temp_files

GROUP BY tablespace_name) a,

(SELECT?? ss.tablespace_name,

SUM ((ss.used_blocks * ts.BLOCKSIZE)) BYTES

FROM gv$sort_segment ss, SYS.ts$ ts

WHERE ss.tablespace_name = ts.NAME

GROUP BY ss.tablespace_name) t

WHERE d.tablespace_name = a.tablespace_name(+)

AND d.tablespace_name = t.tablespace_name(+)

AND d.extent_management = 'LOCAL'

AND d.CONTENTS = 'TEMPORARY'

AND d.tablespace_name LIKE :b1

ORDER BY 1;

進(jìn)一步分析后發(fā)現(xiàn)以下語(yǔ)句的SQL解析有問題：

SELECT?? tablespace_name, SUM (BYTES) BYTES

FROM dba_undo_extents

WHERE status IN ('ACTIVE', 'UNEXPIRED')

GROUP BY tablespace_name

在metalink上查找到解決方法，找到以下兩個(gè)BUG：

Bug 5029820: POOR PERFORMANCE WHEN ACCESSING TABLESPACE PAGE IN GRID CONTROL FOR APPS DB

Bug 5745040: QUERY AGANST DBA_UNDO_EXTENTS IS VERY SLOWBug 5745040: QUERY AGANST DBA_UNDO_EXTENTS IS VERY SLOW

Oracle建議安裝補(bǔ)丁5562287，但是該補(bǔ)丁沒有for10.2.0.1的。沒有辦法，下載p3731593_10202_SOLARIS64.zip先升級(jí)GC到10.2.0.2,然后安裝5562287_10202_GENERIC.zip補(bǔ)丁。

注意，安裝前。需要執(zhí)行export ORACLE_HOME=$OMS_HOME

$ORACLE_HOME/OPatch/opatch apply

當(dāng)補(bǔ)丁安裝成功后，再次登錄管理表空間的維護(hù)頁(yè)面，系統(tǒng)登錄正常。

至此，問題終于解決。

總結(jié)

以上是生活随笔為你收集整理的oracle不能访问管理页面,Oracle Grid Control CONSOLE无法打开9i数据库的管理维护页面...的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。