alert log error WARNING: too many parse errors, count=933000

Posted by Roshan on Dec 16, 2022; 12:23pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/alert-log-error-WARNING-too-many-parse-errors-count-933000-tp11376.html

Oracle DB 19c
Oracle Linux 7

Hi,

I did a restore from 12c to 19.3 DB. When application is starting, error below is generated from application

2022-12-16T16:06:45.700524+04:00
DECLARE   v_lockhandle VARCHAR2(200);BEGIN   dbms_lock.allocate_unique(lockname    => :1 ,  lockhandle  => v_lockhandle,expiration_secs =>172800);   :2  := dbms_lock.request(lockhandle  => v_lockhandle, lockmode=> 6,timeout=>0); end;
Additional information: hd=0x6da1bde0 phd=0x6d280198 flg=0x100476 cisid=87 sid=87 ciuid=87 uid=87 sqlid=c8azfa7vb3dkc
...Current username=T24PROD7DEC
...Application: JDBC Thin Client Action:
WARNING: too many parse errors, count=933000 SQL hash=0xf6b1b64c
PARSE ERROR: ospid=389428, error=6550 for statement:

Is it application related?

Regards,

Roshan