Home / Oracle Database (page 4)

Oracle Database

SAP Oracle Restore using Incremental Backup

                             SAP Oracle Restore using Incremental Backup (RMAN) Summary:- This document contains the steps that how to restore the SAP system using RMAN Incremental Backup. This Document give only the restore commands to execute at OS level. There are many pre-Steps and Post steps need to be done once the …

Read More »

Oracle12c Database Installation steps

Oracle12c Installation step on Linux Summary:- This document contains the steps that how to do the oracle12c Database installations steps on Linux. Database: Oracle12c OS Level    : Red Hat Linux 6 Author: Brindavan Mookaiah Designation: SAP BASIS Consultant   Note: The steps are only suitable for NON SAP Oracle Pre …

Read More »

SSFS Oracle Configuration after Upgrade Error

During an EHP7 upgrade of ERP6.0 system (Windows 2008 – Oracle 11G), an error occured during preparation phase (PREP_INPUT): *** ERROR => Connect via SAPUSER not supported for kernel >= 740 According to the note 1904826 – Upgrade error “Connect via SAPUSER not supported for kernel >= 740” we’ve configured …

Read More »

Large client deletion case – Note 857973

This document explains a sample large client deletion case. I tried to delete a huge productive client with size some hundred gigabytes. I needed to follow those instructions expressed in Note 857973 – Deleting clients efficiently using Oracle. Login with sapsr3 in order to create _TMP tables under sapsr3’s schema. …

Read More »

Analyzing and Optimizing Oracle Database Performance – Part II

Analyzing and Optimizing Oracle Database performance – Part II You will find summary information about memory management,  analyzing  and optimizing database performance below. For detailed information check the related SAP Notes. For Part I – Analyzing and Optimizing Oracle Database Performance – Part I V- Analyzing Storage Quality DBACOCKPIT –> …

Read More »

Oracle Upgrade 11G to 12C

                                    Oracle Upgrade 11G to 12C Summary:- This document contains the steps that how to do the oracle upgrade 11 G to 12C. Author: Brindavan Mookaiah Designation: SAP BASIS Consultant Note: The steps are only suitable for NON SAP Oracle Upgrade. For SAP oracle upgrade 11g to 12 c on …

Read More »

Analyzing and Optimizing Oracle Database Performance – Part I

Analyzing and Optimizing Oracle Database Performance – Part I For Part II – Analyzing and Optimizing Oracle Database Performance – Part II You will find summary information about memory management,  analyzing  and optimizing database performance below. For detailed information check the related SAP Notes and related documentation, please. I- Memory …

Read More »

EM console setup in SAP environment

This document should explain how to configure Oracle EM console in SAP environment, because there is one big issue with ORACLE_HOME environment variable. As in SAP installation on Linux (or other unix OS), normally installation is done into /oracle/<SID>/11203 or /oracle/<SID>/112_64 directory, but ORACLE_HOME is set to /oracle/<SID>/112, which is …

Read More »

‘ORA-12577 occurred when reading from a LOB’ on kernel 7.41

I have seen a couple of dumps occured with the new kernel, the issue seems to be fixed with the latest DBSL. The DBIF_REPO_SQL_ERROR dump and developer trace refer to such entiries: C     OCILobRead2(substring) failed with SQL error 12577: C     ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA C                                                           C  <–OCILobRead2(con=0, …

Read More »

DBA Cockpit:Non-ABAP/Java Oracle databases

We have many applications in our SAP productive landscape apart from regular ABAP and JAVA stack systems, which have oracle or other database technology as the underlying database platform. An example of this type of application can be SAP MDM or SAP business objects.. These type of application’s databases can …

Read More »

Backup cycle planning for Oracle database

I recently faced an issue regarding designing a careful approach to backup. If you are planning the backup cycle for your Oracle database and you don’t know how to proceed, check the KBA #2084077 I’ve created. In such case, firstly you must identify what needs to be backed up, the …

Read More »

SAP oracle upgrade 10G to 11G on AIX

SAP oracle upgrade 10G to 11G on AIX Summary:- This document contains the steps of  SAP oracle upgrade 10G to 11G on AIX (Operating system) using oracle DBUA menthod. Author: Brindavan Mookaiah Designation: SAP BASIS Consultant Pre-requisite steps Backup   1) Before starting the ORACLE Upgrade 11g please take the …

Read More »

ORA-00942 and BR0310E Error – Solution

Hello All; After a successful system refresh you may want to start taking backups of this system, but you may face errors, and in my case I had the following errors: ———————————————————————————————————————————————————— BR0310E Connect to database instance SID failed BR0301E SQL error -942 at location BrDbConnect-6, SQL statement: ‘SELECT NAME, …

Read More »

How to locate an incident trace within ADRCI

This one is very useful while collecting and sending data either to Oracle or SAP. As in my example, I had a problem with ORA-600 [16500]. 1.) Execute “show problem” 2.) Execute “show tracefiles”.       Here we have to use LAST_INCIDENT as a filter.     The path here does not …

Read More »

Change the size of the RedoLog group (Statement collection)

To collect information regarding the active RedoLog groups and members configuration on database level, you can choose the following SQL-Statements: col MEMBER format a38; SELECT v$logfile.group#, v$logfile.member, v$log.bytes/1024/1024 as FS_SIZE, v$log.status FROM v$logfile LEFT JOIN v$log ON  v$logfile.group#=v$log.group# ORDER BY v$logfile.group#, v$logfile.member; The statement above is an combination of the …

Read More »

How to Handle long running backup

This document is based on my personal experience and all the suggestions and feedbacks are welcome to improve this. How to Handle long running backup Syntomes :- Backup is running longer than expected and not canceling as well . $SAPBACKUP%.lock.brb no lock file at the location.( if there remove the …

Read More »

Quick guide for SSFS on windows

The procedure works for both ABAB for JAVA system. For implement  Password storage for primary database connect you need to do 5 step Create directory structure Give permission Set windows registry keys Changethe default profile Excecute rsecssfx Create directory structure Log on to SAPGLOBALHOST to the operating system as user …

Read More »

How to trace out oracle performance issues

Many a times we come across situation where we need to troubleshoot performance problems related to Oracle database. This blog is meant to provide some basis guideline on tracing out performance problems with Oracle database. 1)  Use below SQL query command to confirm the status of Oracle patch set.    …

Read More »

Recovering Oracle DB from Online Backup

Below are the detailed steps to be performed for recovering a DB from a Online backup of another oracle system. Below are the assumptions: You are using online backup of the Source system. Source and target system have the similar /oracle/<SID>/sapdata<n> structure The host is a UNIX server Restore of …

Read More »

[Oracle] DB Optimizer Part X – Looking under the hood of Adaptive Query Optimization / Adaptive Statistics – SQL Plan Directives (Oracle 12c)

Introduction In the first part of the “Adaptive Query Optimization” series we looked at the feature set called “Adaptive Plans”, which is completely new in Oracle 12c. However Adaptive Query Optimization consists of two feature sets called “Adaptive Plans” and “Adaptive Statistics”. The latter (or better said the new features …

Read More »