Troubleshooting

SQL> select BUILD_DATE,dump(build_date) from jmjk_jilin_th_mhk.ehealth_arch_basicinfo where BUILD_DATe>sysdate
2 ;
ERROR:
ORA-01877: string is too long for internal buffer

今天遇到了一个奇怪的问题，有一个表空间无法删除，开始删除提示表空间内有对象，加上INCLUDING CONTENTS选项级连删除又报
ORA-01561: failed to remove all objects in the tablespace specified，查一些系统视图该对象还不存在

ERROR at line 1:
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at line 4

今天发现了这个问题，分析记录一下问题是这样子的，有一个表记录7亿，要在表上建索引，临时表空间已分配32G，DB DEFAULT BLOCK SIZE 8K，建索引时报了这个错误

exp,imp到其他9i数据库里出现部分数据变成了 46588.21 ,只因为指定了buffer

Connected to an idle instance.

SQL> startup
ORA-00443: background process “PMON” did not start

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at “WMSYS.WM_CONCAT_IMPL”, line 30

SQL> delete test where id=1;
SP2-0544: Command “delete” disabled in Product User Profile

SQL> conn zwz/zwz;
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

if export specify the FILESIZE parameter,so when you import specify TABLES parameter and you must specify the FILESIZE same ths export filesize too

今天无意执行了一个脚本，后来发现kill 了j000和m000的进程，oracle被僵死在那里，j000是job的守护进程，m000是MMON进程启动的从属平行进程，都是轻量级但不容忽视！

SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

alter database mount
*
ERROR at line 1:
ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version 10.2.0.1.0

Connected.
ERROR:
ORA-01012: not logged on

ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure “ANBOB.P_INSERT”

EXP-00008: 遇到 ORACLE 错误 904
ORA-00904: “MAXSIZE”: invalid identifier

今天 有人提起了这个异常，未能将审计记录写入Windows 事件日志，这是WINDOWS平台的一个通病，如果开启了审计，如果应用软件再有频繁操作，一会儿功夫可能就会写满日志最大容量。

sys@ORCL> DESC DBA_ROLLBACK_SEGS;
SP2-0749: Cannot resolve circular path of synonym “DBA_ROLLBACK_SEGS”