Oracle DB 19.15
RHEL 7
Hello Team,
we did a restore of a dump from source 12c to 19c DB. When application is connecting we are getting
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:
2022-12-16T16:06:45.909357+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
Could you please advise on error?
We do not know wxactly what application is executing.
Thanks,
Roshan