on 05-20-2016 12:43 AM
Hello Experts, I was performing oracle upgrade from 11.2.0.3 to 11.2.0.4 in SAP BW system and it terminated with some solaris AMD memory error during step 'Upgrading Timezone'. From upgrade logs it looks like it terminated while trying to restart DB after timezone upgrade, as from SQL, I checked and found that timezone is also upgraded. I think all post upgrade steps were also completed and I could see log files about post-upgrade and everything looks ok and without errors. DB and SAP is up and running fine with new oracle home since last week without issues. But when I executed post-upgrade checks script after termination of upgrade, it showed some invalid objects, which were not there when pre-upgrade checks was executed. Some examples of invalid objects are given below: SYS.V_$FS_OBSERVER_HISTOGRAM (VIEW) SYS.V_$GG_APPLY_COORDINATOR (VIEW) SYS.V_$GG_APPLY_READER (VIEW) SYS.V_$GG_APPLY_RECEIVER (VIEW) SYS.V_$GG_APPLY_SERVER (VIEW) SYS.V_$GOLDENGATE_CAPABILITIES (VIEW) SYS.V_$GOLDENGATE_CAPTURE (VIEW) SYS.V_$HANG_INFO (VIEW) SYS.V_$LOGMNR_REGION (VIEW) SYS.V_$PROCESS_MEMORY_DETAIL (VIEW) SYS.V_$RESULT_CACHE_OBJECTS (VIEW) SYS.V_$RMAN_STATUS (VIEW) SYS.V_$ROWCACHE (VIEW) SYS.V_$RO_USER_ACCOUNT (VIEW) SYS.V_$RSRC_SESSION_INFO (VIEW) SYS.V_$STREAMS_APPLY_COORDINATOR (VIEW) SYS.V_$XSTREAM_APPLY_COORDINATOR (VIEW) SYS.V_$XSTREAM_APPLY_READER (VIEW) SYS.V_$XSTREAM_APPLY_RECEIVER (VIEW) SYS.V_$XSTREAM_APPLY_SERVER (VIEW) SYS._ALL_STREAMS_PROCESSES (VIEW) SYS._DBA_STREAMS_COMPONENT_EVENT (VIEW) SYS._DBA_STREAMS_COMPONENT_STAT (VIEW) SYS._DBA_XSTREAM_OUTBOUND (VIEW) Though I am able to compile these objects manually with no errors, I just want to know whether there are any other sanity checks I can do to make sure that database and system is healthy after upgrade. Please refer attached screen of DBUA step where upgrade was terminated. Thanks, Ankur SAP Basis Team
There should be be post upgrade scripts in the "sap" folder under the ORACLE_HOME directory. You can also run the timezone script manually from there too.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ankur
Please run t-code SICK in SAP run health check.
Thanks
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.