Greetings can you tell me how to resolve and fix the issues in this oracle database so these types of errors will go away when I attempt to startup the oracle database?
*** SERVICE NAME:(SYS$USERS) 2009-11-03 08:14:46.413
*** SESSION ID:(431.3) 2009-11-03 08:14:46.413
kwqmnich: current time:: 8: 14: 46
kwqmnich: instance no 0 check_only flag 1
kwqmnich: initialized job cache structure
Error in executing triggers on database startup
*** 2009-11-03 08:14:49.412
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-06564: object AC.AX_OTK does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 114
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at "SYS.KEEP_OBJ_IN_SGA", line 18
ORA-06512: at line 3
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
What virdi_ds said, you have a system level trigger that fires on database startup and it can't find a table it needs.
You need to debug this trigger:
select text from dba_source where name='AX_OTK' and owner='AC' order by line;
You can then fix the trigger or drop it. Before dropping it you need to find out who put it there.
Business Accounts
Answer for Membership
by: virdi_dsPosted on 2009-11-04 at 12:41:24ID: 25743666
It looks like there is an Oracle trigger on Instance startup. Is that correct?