Dear support,
We were applying patches on Netweaver 2004s Oracle 10.2.0.2 Windows platform server. Basis patch 12 and it was successfull in Test mode , but during standard mode suddenly machine got restarted because of power problem.
Now database and SAP is up and running , but i am unable to proceed with any of transactions ( like SPAM ) as i get <b>syntax_error</b>. Patch is in IMPORT_PROPER phase so i cannot reset until i do some database work.
What i am just aware i need to check entries in PAT01 , PAT02 , PAT03 and TRBAT tables and delete entries from PAT01 there to reset the queue and run patch again.
I can login to database with user SAPSR3 and there are entries for Basis patch 12 in table PAT01.Can anyone tell me further actions and querry which need to be executed to delete entry in detail , as i am having one week old backup which is not usefull for me.Please let me know safest way out of this issue.
Please help me at earliest.
Best Regards,
AjitR