| SQL Plus error [message #58038] |
Mon, 28 July 2003 06:06  |
raman
Messages: 66
Registered: February 2000
|
Member |
|
|
Getting the following error when doing just about anything in SQL plus, anyone have any ideas please???
THanks.
ORA-00604: error occurred at recursive SQL level 1
ORA-04098: trigger 'SYS.JIS$ROLE_TRIGGER$' is invalid and failed re-validation
|
|
|
|
| Re: SQL Plus error [message #58039 is a reply to message #58038] |
Mon, 28 July 2003 06:42  |
sabir
Messages: 18
Registered: April 2003
|
Junior Member |
|
|
Read below mentioned quotes.Seems system triggers belonging to SYS schema have got invalid.Recompile them.....should work that way...........
-----------------------------------------
ORA-04098 trigger 'string' is invalid and failed re-validation
Cause: A trigger was attempted to be retrieved for execution and was found to be invalid. This also means that compilation/authorization failed for the trigger.
Action: Options are to resolve the compilation/authorization errors, disable the trigger, or drop the trigger.
ORA-00604 error occurred at recursive SQL level string
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 Customer Support.
|
|
|
|
| Re: SQL Plus error [message #58041 is a reply to message #58038] |
Mon, 28 July 2003 06:43 |
sabir
Messages: 18
Registered: April 2003
|
Junior Member |
|
|
Read below mentioned quotes.Seems system triggers belonging to SYS schema have got invalid.Recompile them.....should work that way...........
-----------------------------------------
ORA-04098 trigger 'string' is invalid and failed re-validation
Cause: A trigger was attempted to be retrieved for execution and was found to be invalid. This also means that compilation/authorization failed for the trigger.
Action: Options are to resolve the compilation/authorization errors, disable the trigger, or drop the trigger.
ORA-00604 error occurred at recursive SQL level string
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 Customer Support.
|
|
|
|
| Re: SQL Plus error [message #58053 is a reply to message #58038] |
Tue, 29 July 2003 00:51 |
Dhiren Patel
Messages: 16
Registered: December 2002
|
Junior Member |
|
|
Hi
only way to solve this error is connect as internal login and the drop the trigger.by doing this also u cannot drop the trigger then shutdown the database,manually start the database by connecting internal account and drop the particular objects
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
