Home / Oracle Database

Oracle Database

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 …

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 …

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. …

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 …

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 …

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 …

Read More »

Upgrade Experiences Oracle RAC 12c

Dear all, want to share some upgrade experiences when going from Oracle Grid/RAC 11g to 12c. Hoping that my experiences can make life easier for others. We are dealing with Oracle Grid/RAC in a NetApp/NFS shared storage environment. Based on the documents from the Oracle community here (and of course …

Read More »

Update Statistics Error on DB13 – SQL error -20000 at location stats_ind_collect-3

Hello all, I want to share a simple solution for the issue below, when scheduled “Update Statistics” on DB13: Error details log: BR0301E SQL error -20000 at location stats_ind_collect-3, SQL statement: ‘BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => ‘”SAPSR3″‘, INDNAME => ‘”/ABC/INDEXNAME~010″‘, ESTIMATE_PERCENT => 3, DEGREE => NULL, NO_INVALIDATE => FALSE); END;’ ORA-20000: …

Read More »

Upgrade from Oracle 11.2 to Oracle 12 (Linux Red Hat) (1/3)

Upgrade from Oracle 11.2 to Oracle (Linux Red Hat) (2/3) Upgrade from Oracle 11.2 to Oracle (Linux Red Hat) (3/3) Disclaimer Creating SSFS Creating directories Maintaining the SSFS profile parameters Maintaining the SSFS environment variable Setting up the SSFS storage Changing to the new connection method Checking the successful changeover …

Read More »

ORA-00932 and SQL Command Editor

As a co worker once said “Everyday’s a school day”, and I certainly learnt something new today. Hopefully, this will help you in the future. … I was debugging the presence of a text entry for an issue with the APO SDP Note functionality. Using SE16, I was able to …

Read More »

Index storage capacity analysis & Re-build

Index storage capacity analysis & Re-build Introduction: Indexes are the vital component in database to search data in most optimal way using filter. By continuous changes in the data due to Insert, Update and Delete operations, the index stored on the database gets fragmented thus increasing Application response time and …

Read More »

Oracle 12c Upgrade

                                                            Oracle 12c Upgrade This document describes the process of executing Oracle 12c Database upgrades, from the source 11g. In addition, this manual provides information about compatibility, upgrading applications, and important changes in the new Oracle Database release. 1 Preparations/Prerequisites Step’s The following activities can be executed with the system …

Read More »

Oracle compression, a week out of port

After a week of minor fire-fights and other business as usual, I took a look at several systems that had gone through Oracle database compression and storage improvements.  Some performance metrics would be influenced by one or the other or both; space consumption is only from the compression work. The …

Read More »

Change default port Oracle

This document show some step to do for change the default port to Oracle Listener “1521” First that all, check the port. Use the command “lsnrctl status”. Stop SAP with the database too, change the port onthe “tnsnames.ora” file. That’s all

Read More »

72 Hours After Oracle Compression

Previously: 24 Hours After Oracle Compression Quite previously: Our Oracle compression project progress Batch Run times should go down, or, at the worst, stay around the same.  So how are we going to notice something drifting in the wrong direction?  That’s not something that can be definitively answered in 3 …

Read More »

24 Hours After Oracle Compression

After the completion of the work alluded to in Our Oracle compression project progress I took a look at the systems.  As it’s the weekend, normal (much less peak) volumes have yet to occur, but there are early indications of database behavior, specifically, and application health in general. First, the …

Read More »

Our Oracle compression project progress

This will be a rather abbreviated blog, as unlike our Unicode migrations several years ago (when I started blogging on SCN), I am not involved in a hands-on fashion.  That allowed me to go the the Sapphire conference this week while the database, server, and Basis teams prepare for several …

Read More »

ORA-00372: file cannot be modified at this time

You notice that you have following errors in SAP R/3, Database Alert.log file, or BR*Tools log: ORA-00372: file cannot be modified at this time Short dump: ABAP runtime error DBIF_RSQL_SQL_ERROR                     SQL error 372 occurred in statement ORA-00372: file xx cannot be modified at this timeORA-01110: data file xx: <data file …

Read More »

Change the redundancy of the Disk Group of the ASM instance

You want to change the redundancy of the Disk Group of the ASM instance. Current situation: If you try to dismount/drop: Why? Because the ASM instance has its spfile on it: [grid@ora-asm:+ASM ~]$ asmcmd ASMCMD> spget +DATA/asm/asmparameterfile/registry.253.907250463 How to procede then Firts, you need to add another diskgroup (VOL3): [root@ora-asm …

Read More »