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

[Roshan]

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

[ErmanArslansOracleBlog]

Find the SQL using SQL_HASH.
The error in the background is ORA-06550.. Probably you have some invalids there.