--******************

-- ORA-01658 錯誤

--******************

?

??? 最近重新裝個了 Oracle 11g ，在對分區(qū)表導(dǎo)入導(dǎo)出時(shí)碰到了 ORA - 01658 錯誤的問題，因?yàn)閯倓偛叛b的新系統(tǒng)，一導(dǎo)出就碰到了下面的問題，

自己可是納悶了半天，后來才發(fā)現(xiàn)是因?yàn)榇疟P空間不夠引發(fā)的。本人的這個 Oracle 11g 安裝在 rhel 5.5 之上，當(dāng)時(shí)的分區(qū)時(shí)總共分了 16G ， 8G 用

來安裝操作系統(tǒng)， 8G 用來安裝 Oracle 數(shù)據(jù)庫。具體錯誤請看下文。

?

1. 導(dǎo)出數(shù)據(jù)時(shí)產(chǎn)生 ORA - 01658 錯誤 ??

??? [oracle@ora11g ~]$ expdp scott/tiger directory=dmp dumpfile=tb_pt.dmp logfile=tb_pb.log tables=tb_pt parallel=3

?

??? Export: Release 11.2.0.1.0 - Production on Sun Mar 13 18:05:37 2011

?

??? Copyright (c) 1982, 2009, Oracle and/or its affiliates. ? All rights reserved.

?

??? Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

??? With the Partitioning, OLAP, Data Mining and Real Application Testing options

??? ORA-31626: job does not exist

??? ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user SCOTT

??? ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

??? ORA-06512: at "SYS.KUPV$FT_INT", line 798

??? ORA-39244: Event to disable dropping null bit image header during relational select

??? ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

??? ORA-06512: at "SYS.KUPC$QUE_INT", line 1825

??? ORA-02320: failure in creating storage table for nested table column TREAT("USER_DATA" AS "KUPC$_BAD_FILE")."ERROR"

??? ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM

?

2. 根據(jù)錯誤號定位問題

??? SQL > ho oerr ora 31637 ??? -- ORA-31637 不能創(chuàng)建作業(yè)

??? 31637, 00000, "cannot create job %s for user %s"

??? // *Cause: ? Unable to create or restart a job. Refer to any following or

??? // ????????? prior error messages for clarification.

??? // *Action: Eliminate the problems indicated.

?

??? SQL> ho oerr ora 01658 ??

??? 01658, 00000, "unable to create INITIAL extent for segment in tablespace %s"

??? // *Cause: ? Failed to find sufficient contiguous space to allocate INITIAL

??? // ????????? extent for segment being created.

??? // *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the

??? // ????????? tablespace or retry with a smaller value for INITIAL

?

??? 從上面的錯誤描述來看，是因?yàn)榭臻g不夠不能夠創(chuàng)建段，需要添加數(shù)據(jù)文件或?yàn)閰^(qū)間設(shè)置更細(xì)粒度值，因是新裝的系統(tǒng)沒有做個任何調(diào)整，

??? 所以 extent 應(yīng)該是沒有問題的，查看一下系統(tǒng)空間的使用情況

???

??? SQL> ho df

??? Filesystem ?????????? 1K-blocks ????? Used Available Use% Mounted on

??? /dev/sda2 ????????????? 5944440 ?? 3088836 ?? 2548764 ? 55% /

??? /dev/sdb1 ????????????? 8123168 ?? 7701056 ????? 2820 100% /u02

??? /dev/sda1 ?????????????? 155543 ???? 11436 ??? 136077 ?? 8% /boot

??? tmpfs ?????????????????? 517552 ??? 245624 ??? 271928 ? 48% /dev/shm

???

??? 結(jié)果是大吃一驚，原來安裝 Oracle 的 u02 掛載點(diǎn)空間使用率達(dá)到 100 %

?

3. 解決空間問題，不再出現(xiàn) ORA - 01658 錯誤

??? SQL> ho ls /u02

??? database ? dmp ? lost+found ? oracle ? oraInventory

?

??? SQL> ho mv /u02/database /

??? mv: cannot create directory `/database': Permission denied ???????

?

??? SQL> exit

??? Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

??? With the Partitioning, OLAP, Data Mining and Real Application Testing options

??? [oracle@ora11g ~]$ su ? - root

??? Password :

??? [root@ora11g ~]# mv /u02/database / ???? -- 將 Oracle 原始安裝文件轉(zhuǎn)移到 / 分區(qū)

??? [root@ora11g ~]# df

??? Filesystem ?????????? 1K-blocks ????? Used Available Use% Mounted on

??? /dev/sda2 ????????????? 5944440 ?? 5440008 ??? 197592 ? 97% /

??? /dev/sdb1 ????????????? 8123168 ?? 5349900 ?? 2353976 ? 70% /u02

??? /dev/sda1 ?????????????? 155543 ???? 11436 ??? 136077 ?? 8% /boot

??? tmpfs ?????????????????? 517552 ??? 245624 ??? 271928 ? 48% /dev/shm

?

??? 再次導(dǎo)入正常

??? [oracle@ora11g ~]$ expdp scott/tiger directory=dmp dumpfile=tb_pt.dmp logfile=tb_pb.log tables=tb_pt parallel=3

?

??? Export: Release 11.2.0.1.0 - Production on Sun Mar 13 18:34:51 2011

?

??? Copyright (c) 1982, 2009, Oracle and/or its affiliates. ? All rights reserved.

?

??? Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

??? With the Partitioning, OLAP, Data Mining and Real Application Testing options

??? Starting "SCOTT"."SYS_EXPORT_TABLE_01": ? scott/******** directory=dmp dumpfile=tb_pt.dmp logfile=tb_pb.log tables=tb_pt parallel=3

??? Estimate in progress using BLOCKS method... ??????????

??? Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

??? Total estimation using BLOCKS method: 512 KB

??? . . exported "SCOTT"."TB_PT":"SAL_OTHER" ???????????????? 71.73 KB ??? 2880 rows

??? . . exported "SCOTT"."TB_PT":"SAL_11" ??????????????????? 12.45 KB ???? 293 rows

??? . . exported "SCOTT"."TB_PT":"SAL_12" ??????????????????? 14.23 KB ???? 366 rows

??? . . exported "SCOTT"."TB_PT":"SAL_13" ??????????????????? 14.21 KB ???? 365 rows

??? . . exported "SCOTT"."TB_PT":"SAL_14" ??????????????????? 14.20 KB ???? 365 rows

??? . . exported "SCOTT"."TB_PT":"SAL_15" ??????????????????? 14.21 KB ???? 365 rows

??? . . exported "SCOTT"."TB_PT":"SAL_16" ??????????????????? 14.22 KB ???? 366 rows

??? Processing object type TABLE_EXPORT/TABLE/TABLE

??? Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

??? Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

??? Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

??? ******************************************************************************

??? Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:

??? ? /u02/dmp/tb_pt.dmp

??? Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 18:35:59

???

4. 更多參考

有關(guān)性能優(yōu)化請參考

??????? Oracle 硬解析與軟解析

共享池的調(diào)整與優(yōu)化(Shared pool Tuning)

Buffer cache 的調(diào)整與優(yōu)化( 一)

Oracle 表緩存(caching table) 的使用

?

有關(guān)閃回特性請參考

??????? Oracle 閃回特性(FLASHBACK DATABASE)

Oracle 閃回特性(FLASHBACK DROP & RECYCLEBIN)

Oracle 閃回特性(Flashback Query 、Flashback Table)

Oracle 閃回特性(Flashback Version 、Flashback Transaction)

?

有關(guān)基于用戶管理的備份和備份恢復(fù)的概念請參考：

??????? Oracle 冷備份

??????? Oracle 熱備份

??????? Oracle 備份恢復(fù)概念

??????? Oracle 實(shí)例恢復(fù)

??????? Oracle 基于用戶管理恢復(fù)的處理 ( 詳細(xì)描述了介質(zhì)恢復(fù)及其處理 )

???????

??? 有關(guān) RMAN 的恢復(fù)與管理請參考：

??????? RMAN 概述及其體系結(jié)構(gòu)

??????? RMAN 配置、監(jiān)控與管理

??????? RMAN 備份詳解

??????? RMAN 還原與恢復(fù)

???????

??? 有關(guān) Oracle 體系結(jié)構(gòu)請參考：

??????? Oracle 實(shí)例和Oracle 數(shù)據(jù)庫(Oracle 體系結(jié)構(gòu))

??????? Oracle 表空間與數(shù)據(jù)文件

??????? Oracle 密碼文件

??????? Oracle 參數(shù)文件

Oracle 數(shù)據(jù)庫實(shí)例啟動關(guān)閉過程

??????? Oracle 聯(lián)機(jī)重做日志文件(ONLINE LOG FILE)

??????? Oracle 控制文件(CONTROLFILE)

??????? Oracle 歸 檔日志

???

ORA-01658 錯誤