Home / Oracle Database (page 5)

Oracle Database

Get more benefited from ACO

Oracle ACO, a compression methodology launched by Oracle with 11g. Most of the customers got benefited with this in terms of storage reductions, performance improvements etc.. We have this enabled last year in a different way to get more benefited! Details: Oracle ACO is an compression methodology which is a …

Read More »

Oracle KBAs/Notes released/changed on November 2013

Hello, The purpose of this blog is to provide a list of Oracle KBAs/Notes released/changed on November 2013, see below. BC-DB-ORA* 3155 Termination due to tablespace overflow 176754 Problems with CBO and RBO 105047 Support for Oracle functions in the SAP environment 185822 ora-1555 – cause and action 806554 FAQ: …

Read More »

SSFS Implementation for Oracle Database

SSFS Implementation for Oracle Database Author(s): Nitesh Jain Target readers SAP Basis Keywords SAPUSER, ops$-User, ops$-Connect, SSFS, data protection, secure storage, Secure Connect 1.    Introduction – Prior to SSFS, the connection between the SAP system (AS ABAP) and the SAP tools that use the ABAP database interface (R3trans, R3load etc.) …

Read More »

Oracle KBAs/Notes released/changed on october 2013

Hello,   The purpose of this document is to provide a list of Oracle KBAs/Notes released/changed on october 2013. BC-DB-ORA* 830576 Parameter recommendations for Oracle 10g 1020260 Delivery of Oracle statistics (Oracle 10g, 11g) 850306 Oracle Critical Patch Update Program 1171650 Automated Oracle DB parameter check 527843 Oracle RAC support …

Read More »

How to delete sap* from database level

Logon to database server and switch to ora<SID> user (e.g. oraalr) under UNIX (<sidadm> under Windows).Under Windows check correct settings of environment (ORASID, …). Start the database server manager with the command:sqlplus β€œ/as sysdba” Now you’re able to execute SQL statements: to view the entries of the β€œsap*” user type …

Read More »

ORACLE 11g Upgrade

Getting started: This documentation explains how to upgrade the Oracle database for the SAP system from 10.2.0.5.0 to 11.2.0.2.0 on the Windows operating system. Overview procedure: Ø Initial pre-requisites steps before the actual upgrade Ø Upgrading the oracle through the scripts Ø Post upgrades activities. Initial pre requisite: Copy the …

Read More »

SAP 4.7d Installation

Hi All, I had cloud machine linux centos 4.8 32 bit machine. I am going to install SAP 4.7d with oracle 9i database. I had copy SAP media in to cloud machine and when run ./startInstGui then  SDT gui will appear after closing the gui screen then prompt is ready …

Read More »

Identifying Which Indexes to Rebuild

Identifying Which Indexes to Rebuild Indexes require rebuilding when deleted leaf nodes appear or when the index has spawned into too many levels of depth. While it is tempting to write a script that rebuilds every index in the SAPR3 schema, bear in mind that SAP contains many thousands of …

Read More »

Analysing Oracle error ORA-600

In several cases we hit oracle error ora-600 and don’t know exactly what to do, for such errors I’ve created a KBA #1868324 that will help you to check the error and how to proceed with analysis in such cases. As per my experience I can say that most of …

Read More »

Analysing Oracle Deadlocks – ORA-00060

Several times we face deadlocks error sand initially have no clue how to proceed, for that I’ve created a KBA number #1872040 that talks about such scenarios. In fact there are two kinds of deadlocks, ORACLE and APPLICATION deadlocks, most of the times the locks are related to application and …

Read More »

SAPCTL didn’t create SAP Instance Cluster Resource

I recently faced an issue where the Cluster Resource wasn’t created for the SAP instance. At the first look, everything seemed to be correct. After taking a closer look to the command, I recognized that two arguments was mixed up: /usr/sap/sapctl/bin/sapctl create -sapsid RMP -if eth0 -nm 255.255.255.0 -net 10.5.16.0 …

Read More »

ORACLE 11 and Secure Storage in File System

Note 1622837 – Secure connection of AS ABAP to Oracle via SSFS Note 1639578 – SSFS as password storage for primary database connect Preparing and securing the file system In general, we recommend storing the secure storage in the file system and the optional external encryption key on SAPGLOBALHOST under …

Read More »

How to Unlock SAPSR3/SAPR3 user.

Note: Whenever the SAPR3/SAPSR3 user gets locked, the following ABAP dumps occurs in SAP System. β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”     Steps to Unlock SAPSR3/SAPR3 user in database level (Oracle).         Login to database using sqlplus / as sysdba     Execute the query   select username, account_status from dba_users;     Here the status of …

Read More »

Creating DBCO connections

This is a quick guide how to create a DBCO connection to an External Oracle Database- First you create the TNSNAMES.ORA entry, in this case i create a new one called TST.WORLD make sure you can TNSPING TST and its successful (from SIDADM) Logon to SAP and create the entry …

Read More »