I had installed a NW7.31 and also an ECC6.0 EHP6 system, both on Oracle DB and while trying to patch the core components SAP_ABA, SAP_BASIS, PI_BASIS and SAP_BW, in the phase IMPORT_PROPER, i faced an error stating that some tables are missing. I tried to re-import the patches after re-setting the OCS queue but it again stopped in DDIC_ACTIVATION phase of SAP_BASIS component. Finally, i re-installed the system but there were some important post-installation, pre-patching steps that i performed which led to proper, hassle free patching.
NOTE : These steps need to be performed before you start the patch upgrades.
1) Read the central SAP Note 1597765, “Known problems with Support Packages in SAP NW 7.31 AS ABAP” and implemented the other notes that were mentioned in the central note
2) Added parameter “_USE_ZERO_COPY_IO=FALSE “
Steps to add the parameter to the database. In my case, the DB was Oracle.
a) Open init<DBSID>.ora file in Notepad
b) Add parameter into the file, as
Note : The parameter should be mentioned in Capitals.
c) Save the file
d) Shutdown Database
e)Create sp file using p file by executing the following command in command prompt.
CREATE SPFILE FROM PFILE;
f) Start Database
g) Restart instance
h) Delete OCS queue
Run OCS_RESET_QUEUE program in se37 tcode
Enter IV_TOOL as SPAM or SAINT, whichever is applicable and IV_FORCE as X and execute (F8)
i) Run import again from the beginning
Thanks and Regards,