Oracle Database

SUM fails to call brtools or kernel executables

This is just a short update, during upgrading SAP, SUM will switch to <sid>adm and set up its own environment variables to call brtools or kernel executable. To narrow down this issue, we can do as followings: 1. Call the same command from OS level, if the same error occurs, then it means the problem has nothing to do with SUM, we need to focus on from OS level directly …

Read More »

Get Open SQL from Native SQL (SAP on Oracle)

This is normally helping us to check single SQL performance from application perspective. By doing this we can search the “Open SQL” from SAP note/kba, then we will see whether this is known issue from application point of view, most of time, application already add database hint on this particular Open SQL. There are two ways to get Open SQL: 1.  for running session ST04->Performance->Wait Event Analysis->Wait Event Analysis->highlight the …

Read More »

TIP: SUM PREP_PRE_CHECK/PROFREAD BRCONNECT ERROR

Search tags: “BR0301E SQL error -12154” “ORA-12154: TNS:could not resolve the connect identifier specified” “brconnect -u -c -f dbstate -RDB”   I have had this a few times now, documenting for future reference: SUM PREP_PRE_CHECK/PROFREAD Fails for specified oracle SYSTEM user password.   Checking /usr/sap/<SID>/SUM/abap/log/CHKSYSPWD.LOG EXECUTING /usr/sap/OL6/SYS/exe/uc/rs6000_64/brconnect -u -c -f dbstate -RDB BR0801I BRCONNECT 7.40 (25) BR0280I BRCONNECT time stamp: 2017-08-15 13:32:41 BR0262I Enter database user name[/password]: BR0280I BRCONNECT time stamp: …

Read More »

SAP Migration from HP IA64 architecture to mixed environment PAS/ASCS on Red Hat and Oracle db on Exadata

Dear All, it is my first blog, in which I would like to share my experience and my “meeting” with the world of Oracle Exadata. I completed many heterogeneous System Copies in the past, but never on this mixed environment that involves Oracle Exadata I had to migrate a SAP ECC 6.0 system from an HP IA64 hardware architecture (standard ABAP System) to a new hardware architecture (distributed ABAP System) …

Read More »

ORA-01555 with a LOB segment

If the ORA-1555 is occurring with a LOB segment then, the undo tablespace is NOT used for read consistency. Firstly you must check whether the before images are kept in which storage parameter: PCTVERSION (Manual Undo Management mode) RETENTION (Automatic Undo Management mode). ** ONLY one method can be used. PCTVERSION is the preferred method in 10g. Using RETENTION for SecureFile LOBs is NOT recommended for SAP. Reference 1426979 – …

Read More »

ORA-01555 – causes and solutions

This document focuses on the solutions to “ORA-01555: snapshot too old”. The main note 185822 – ora-1555 – cause and action described the 3 reasons for this error. I believe it nicely has described the technical background. However this document summarizes that note and add some more practical steps to analyse and fix the error. The error is shown mostly in the alert.log or system logs. In all the cases …

Read More »

SAP ORACLE BLOCK CORRUPTION TEST FOR TABLE AND RESOLUTIONS

                        ORACLE BLOCK CORRUPTION TEST FOR TABLE AND RESOLUTIONS     Summary:-  This document contain the details about the various test performed for table block corruption without a validate backup to fix the issue. Oracle classifies the Data File Block corruptions as Physical and Logical.  This is also referred as intra block corruptions.   Table of content for test   …

Read More »

Convert a partitioned table to a non-partitioned table via brspace/brtools

Here is a test case shows how to use brspace to convert a partitioned table to a non-partitioned table.  The basic idea is to use -d (first) option to change table definition during reorg. Brspace help link: https://help.sap.com/saphelp_nw73/helpdata/en/46/ade1f9dac33b2fe10000000a1553f7/content.htm By using -d(first) option brspace will resume and give our opportunity to change ANY ddl we want, here we only care partition. 1. Preparation: 1.1 create a partitioned table partab: create table …

Read More »

Wrong result from SQL command editor in DBACOCKPIT

Hi Folks, Recently we have several customers reported sql aggregation returns wrong result in sql command editor. For example, following sql returns unexpected/wrong result: select sum(column1) from table1 This is not sql command editor “problem”, but a LIMITATION. For the details, please refer to SAP note 2426293 – SQL command editor: Purpose and limitation. That is to say business process must not rely on sql command editor. Technically from certain …

Read More »

Upgrade Oracle Database from 11 to 12c

Hello, Below are resumed steps to take when upgrading Oracle to 12c, using Linux OS. Based on SAP Upgrade documentation. My intention is to show the effort that this process takes, so other members can have an idea of planning. Check before start -> SAP must be 7.00 and above. (System Status) -> Check OS kernel required. Check the necessary Kernel for you on the link: http://docs.oracle.com/database/121/nav/portal_11.htm -> Check Original Version (must be …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration