遇到oracle错误的自处理方法

小白在日常的运维中，会经常性的遇到各种数据库的奇葩问题：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 错误编号