Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00604 & ORA-28003 - Even when not trying to change password (oracle 11g)
ORA-00604 & ORA-28003 - Even when not trying to change password [message #678834] Fri, 17 January 2020 00:20 Go to next message
IshwaryaMurali
Messages: 7
Registered: January 2020
Junior Member
Hi Everyone,

I am trying to create java source from Oracle DB. Tried with the sample code, yet not able to create and receiving errors. Also, checked for the triggers(which will invoke while CREATE OR REPLACE), there are no valid triggers.Here is the below code and errors. Searched so many resources still not able to resolve the issue.

CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "Hello" AS
public class Hello
{
public static String World()
{
return "Hello World!";
}
};
/

Error report:
ORA-00604: error occurred at recursive SQL level 1
ORA-28003: password verification for the specified password failed
ORA-20002: Password length less than 8
00604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack
can be corrected, do so; otherwise contact Oracle Support.

Re: ORA-00604 & ORA-28003 - Even when not trying to change password [message #678835 is a reply to message #678834] Fri, 17 January 2020 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 67364
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, Make sure that lines of code do not exceed 80 characters.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

Quote:
I am trying to create java source from Oracle DB.

With which client tool? SQL*Plus?

Quote:
there are no valid triggers.

Prove this claim.

Note: the problem does not come from the code you posted.
Re: ORA-00604 & ORA-28003 - Even when not trying to change password [message #678841 is a reply to message #678835] Fri, 17 January 2020 04:28 Go to previous messageGo to next message
IshwaryaMurali
Messages: 7
Registered: January 2020
Junior Member
Thank you for your response

trying to create from sql developer

Please find the below screenshots.




  • Attachment: trigger.jpg
    (Size: 36.99KB, Downloaded 180 times)

[Updated on: Fri, 17 January 2020 04:31]

Report message to a moderator

Re: ORA-00604 & ORA-28003 - Even when not trying to change password [message #678842 is a reply to message #678841] Fri, 17 January 2020 05:04 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
So there is a create trigger.
What does it do?
Re: ORA-00604 & ORA-28003 - Even when not trying to change password [message #678851 is a reply to message #678842] Fri, 17 January 2020 08:47 Go to previous messageGo to next message
IshwaryaMurali
Messages: 7
Registered: January 2020
Junior Member
below is the code of the trigger

DECLARE
error boolean;
st_syn_detected EXCEPTION;
PRAGMA EXCEPTION_INIT(st_syn_detected, -995);
BEGIN
if((sys.dbms_standard.dictionary_obj_type!='SYNONYM')or(sys.dbms_standard.dictionary_obj_owner!='PUBLIC'))
then
return;
end if;
error :=
CASE sys.dbms_standard.dictionary_obj_name
WHEN 'ST_GEOMETRY' THEN TRUE
WHEN 'ST_SURFACE' THEN TRUE
WHEN 'ST_POLYGON' THEN TRUE
WHEN 'ST_POINT' THEN TRUE
WHEN 'ST_MULTISURFACE' THEN TRUE
WHEN 'ST_MULTIPOINT' THEN TRUE
WHEN 'ST_MULTILINESTRING' THEN TRUE
WHEN 'ST_MULTICURVE' THEN TRUE
WHEN 'ST_LINESTRING' THEN TRUE
WHEN 'ST_GEOMCOLLECTION' THEN TRUE
WHEN 'ST_CURVE' THEN TRUE
WHEN 'ST_CURVEPOLYGON' THEN TRUE
WHEN 'ST_COMPOUNDCURVE' THEN TRUE
WHEN 'ST_CIRCULARSTRING' THEN TRUE
WHEN 'ST_INTERSECTS' THEN TRUE
WHEN 'ST_RELATE' THEN TRUE
WHEN 'ST_TOUCH' THEN TRUE
WHEN 'ST_CONTAINS' THEN TRUE
WHEN 'ST_COVERS' THEN TRUE
WHEN 'ST_COVEREDBY' THEN TRUE
WHEN 'ST_INSIDE' THEN TRUE
WHEN 'ST_OVERLAP' THEN TRUE
WHEN 'ST_OVERLAPS' THEN TRUE
WHEN 'ST_EQUAL' THEN TRUE
WHEN 'ST_OVERLAPBDYDISJOINT' THEN TRUE
WHEN 'ST_OVERLAPBDYINTERSECT' THEN TRUE
WHEN 'ST_GEOMETRY_ARRAY' THEN TRUE
WHEN 'ST_POINT_ARRAY' THEN TRUE
WHEN 'ST_CURVE_ARRAY' THEN TRUE
WHEN 'ST_SURFACE_ARRAY' THEN TRUE
WHEN 'ST_LINESTRING_ARRAY' THEN TRUE
WHEN 'ST_POLYGON_ARRAY' THEN TRUE
ELSE FALSE
END;

if(error) then
raise st_syn_detected;
end if;
END;

Please help to resolve the issue!!!
Re: ORA-00604 & ORA-28003 - Even when not trying to change password [message #678856 is a reply to message #678851] Fri, 17 January 2020 10:58 Go to previous messageGo to next message
Michel Cadot
Messages: 67364
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ Format your post as requested.
2/ You must query DBA_TRIGGERS.
3/ Other triggers may raise, your WHERE clause should search for triggering event like '%CREATE%' (note the 2 %) or '%DDL%' (and maybe other ones).
4/ What is the status of MDSYS account?

Re: ORA-00604 & ORA-28003 - Even when not trying to change password [message #678888 is a reply to message #678856] Tue, 21 January 2020 00:08 Go to previous messageGo to next message
IshwaryaMurali
Messages: 7
Registered: January 2020
Junior Member
sorry for the delayed reply and thank you for your response

I tried removing JVM in Oracle DB and re-installed it. Now the program is working fine
Re: ORA-00604 & ORA-28003 - Even when not trying to change password [message #678890 is a reply to message #678888] Tue, 21 January 2020 00:39 Go to previous message
Michel Cadot
Messages: 67364
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What are the steps you used?

Previous Topic: Hierarchy Queries
Next Topic: Query on Oracle JVM
Goto Forum:
  


Current Time: Tue Sep 22 10:39:36 CDT 2020