一、
2022-09-28T15:02:59.678845+08:00
WARNING: too many parse errors, count=300533 SQL hash=0x72edd944
PARSE ERROR: ospid=78460, error=904 for statement:
2022-09-28T15:02:59.679061+08:00
SELECT AUTHID
FROM T_UCP_*****
WHERE (STATUS = 1 OR STATUS IS NULL)
AND STAFFID = :1
AND MODULEID = :2
AND SYSDATE BETWEEN BEGINDATE AND ENDDATE
AND AUTHID IN
(
:3
)
Additional information: hd=0x545ddb150 phd=0x551c904f8 flg=0x100476 cisid=808 sid=808 ciuid=808 uid=808 sqlid=3nxd169tf****
...Current username=TB**
...Application: JDBC Thin Client Action:
oracle@ld:/home/oracle> oerr ora 904
00904, 00000, "%s: invalid identifier"
// *Cause:
// *Action:
SQL> @desc TB**.T_UCP_*****
Name Null? Type
------------------------------- -------- ----------------------------
1 STAFFID NOT NULL VARCHAR2(20)
2 AUTHID NOT NULL VARCHAR2(80)
3 STATUS NUMBER(2)
4 CREATEDATE DATE
5 STATUSDATE DATE
原因：查看对应的表结构，发现在sql中存在表结构中没有的字段。
二、
2022-09-28T16:06:19.198867+08:00
WARNING: too many parse errors, count=218068 SQL hash=0x79fee77a
PARSE ERROR: ospid=983, error=933 for statement:
2022-09-28T16:06:19.199036+08:00
SELECT OPERID,ORGID FROM ACC_JOBRUN_***** WHERE REGION = 10.230.***.**:80 AND JOBID = :JOBID
Additional information: hd=0x198cab320 phd=0x37d6f0f20 flg=0x28 cisid=808 sid=808 ciuid=808 uid=808 sqlid=gnhv2q9w****
...Current username=TB**
...Application: GrpRwdGoodsUnSale@lbkproc-6 (TNS V1-V3) Action:
oracle@ld:/home/oracle> oerr ora 933
00933, 00000, "SQL command not properly ended"
// *Cause:
// *Action:
SQL> @desc TB**.ACC_JOBRUN_*****
Name Null? Type
------------------------------- -------- ----------------------------
1 REGION NOT NULL NUMBER(5)<<<<<<<
2 JOBID NOT NULL VARCHAR2(32)
3 HOSTID NOT NULL VARCHAR2(32)
4 PROCESSID NOT NULL VARCHAR2(32)
5 PINGDELAY NOT NULL NUMBER(5)
6 HEARTBEATTIME NOT NULL DATE
7 SUSPEND NOT NULL NUMBER(1)
8 CHANGETIME NOT NULL DATE
9 OPERID NOT NULL VARCHAR2(32)
10 ORGID VARCHAR2(32)
SQL> SELECT OPERID,ORGID FROM TB**.ACC_JOBRUN_***** WHERE REGION = 10.230.***.**;
SELECT OPERID,ORGID FROM TBCS.ACC_JOBRUN_STATUS WHERE REGION = 10.230.***.**
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> select region from TB**.ACC_JOBRUN_***** where rownum<2;
REGION
----------
310
原因：字段类型不对，region是number类型，sql中的region是字符串。
三、
2022-09-29T17:55:27.823246+08:00
WARNING: too many parse errors, count=100 SQL hash=0x1734c22d
PARSE ERROR: ospid=81807, error=904 for statement:
2022-09-29T17:55:27.823401+08:00
select rectime,billcycle, region, itemcode, itemaddcode, cnt, sum_fee, itemname, packagename from account.sp_******_report@lnk_a******* where rectime>=20220101 and mod(0,:1 )=:2
Additional information: hd=0x1b8393368 phd=0x5ae19fdd0 flg=0x100476 cisid=366 sid=366 ciuid=366 uid=366 sqlid=70557s8bm****
...Current username=REP***
...Application: JDBC Thin Client Action:
因为是dblink所以到对应的库查看
SQL> @desc account.sp_******_report
Name Null? Type
------------------------------- -------- ----------------------------
1 REGION NUMBER(5)
2 BILLCYCLE NUMBER(10)
3 ITEMTYPE NUMBER(2)
4 ITEMCODE VARCHAR2(32)
5 ITEMADDCODE VARCHAR2(64)
6 FEE NUMBER
7 CNT NUMBER
8 REPORT_DD NUMBER
9 FLAG CHAR(2)
原因：查看对应的表结构，发现SQL中存在不在表结构中的字段。
四、
2022-09-27T23:08:05.944428+08:00
opiodr aborting process unknown ospid (16257) as a result of ORA-609
2022-09-28T01:55:27.980577+08:00
WARNING: too many parse errors, count=99812 SQL hash=0x79fee77a
PARSE ERROR: ospid=94951, error=933 for statement:
2022-09-28T01:55:27.980719+08:00
SELECT OPERID,ORGID FROM ACC_JOBRUN_***** WHERE REGION = 10.230.***.**:80 AND JOBID = :JOBID
Additional information: hd=0x11f134080 phd=0x45cd2fee0 flg=0x28 cisid=1277 sid=1277 ciuid=1277 uid=1277 sqlid=gnhv2q9w****
...Current username=TB**
...Application: GrpRwdGoodsUnSale@lbkproc-6 (TNS V1-V3) Action:
原因：字段类型不对，region是number类型，sql中的region是字符串
五、
2022-09-30T11:08:40.561770+08:00
WARNING: too many parse errors, count=6736 SQL hash=0x50594b42
PARSE ERROR: ospid=118582, error=936 for statement:
2022-09-30T11:08:40.561984+08:00
select from dual
Additional information: hd=0x41bfd1f78 phd=0x4157a2bf8 flg=0x28 cisid=1277 sid=1277 ciuid=1277 uid=1277 sqlid=1ugsns5*****
...Current username=TB***
...Application: JDBC Thin Client Action:
原因：明显的语法错误。
