遇到oracle错误的自处理方法

来源：互联网发布：足球竞赛编程编辑：程序博客网时间：2024/06/11 19:37

小白在日常的运维中，会经常性的遇到各种数据库的奇葩问题：ORA- IMP- PTS-......每次都因为时间问题或者思维惰性去网上搜索解决办法，不使用oracle的官方文档，不去看正规的数据库报错指导，机械且盲目，今天终于再一次碰到了ERROR的自处理，我决定立帖为记，不把它拿下就去shi~

SQL> ho oerr ora 31637
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

SQL>

根据所报错，应该是哪个表空间空间不够了，查看一下表空间使用率：

SQL> select a.tablespace_name,a.bytes/1024/1024 "Sum MB" ,(a.bytes-b.bytes)/1024/1024 "used MB" ,b.bytes/1024/1024 "free MB" ,round(((a.bytes-b.bytes)/a.bytes)*100,2) "percent_used" from (select tablespace_name, sum (bytes) bytes from dba_data_files group by tablespace_name) a,(select tablespace_name, sum (bytes) bytes, max (bytes) largest from dba_free_space group by tablespace_name) b where a.tablespace_name=b.tablespace_name order by ((a.bytes-b.bytes)/a.bytes) desc;

TABLESPACE_NAME                    Sum MB    used MB    free MB percent_used
------------------------------ ---------- ---------- ---------- ------------
UNDOTBS2                            10340      10316         24        99.77
SYSAUX                               3800 3553.1875   246.8125         93.5

2 rows selected.

扩表空间:

SQL> alter tablespace UNDOTBS2 add datafile '/home/wsj/undotbs02.dbf' size 1024M autoextend off;

Tablespace altered.

SQL> commit;

Commit complete.

总结：

善用：ho error ora 错误编号

0 0