SAP BASIS & Security

BR*Tools for Oracle DBA

2012-02-16T21:06:00.001+05:30

The BR*Tools are installed automatically on the database server in the directory /usr/sap/<SAPSID>/SYS/exe/run. We classify BR*Tools as functional, help, batch, and interactive tools: Tool Types for BR*Tools Type Tool Description Functional BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, and BRCONNECT Perform actions directly on database files or objects Help BRTOOLS and BRCONNECT ●

SAP Naming Conventions for Tablespaces and Data Files

2012-02-16T21:03:00.001+05:30

Tablespace Naming Convention as of SAP Web Application Server 6.10 The following table contains an overview of all the tablespaces in an SAP system and how they are used: Tablespace Name Use SYSTEM Oracle system tablespace SYSAUX Oracle auxiliary system tablespace PSAPTEMP Temporary obejcts (system default temporary tablespace) PSAPTEMP<name> Additional temporary objects, if required.

Operating System Users and Groups & Database Users and Roles

2012-02-16T21:01:00.001+05:30

Operating System Users In the SAP system the roles of the users ora<dbsid> and <sapsid>adm on UNIX, or <sapsid>adm and SAPSERVICE<SID> on Windows, used to be separate. Due to the requirements for RMAN backup, this is no longer true. Both users now belong to the operating system groups dba andoper, as shown in the tables below. Database Roles · SYSDBA All authorizations· SYSOPER

Oracle Database Directory Structure (UNIX)

2012-02-16T20:58:00.001+05:30

This section describes the directory structure for the Oracle database with the Windows operating system. The directories contain a range of files such as profiles, log files, scripts, executables, and so on. The following conventions apply to this section: Term Meaning %<name>% Environment variable <DBSID> %$ORACLE_DBSID% <TSP> Tablespace short name For example, BTABD for the tablespace

Oracle Database Directory Structure (UNIX)

2012-02-16T20:56:00.001+05:30

This section describes the directory structure for the Oracle database with the UNIX operating system. The directories contain a range of files such as profiles, log files, scripts, executables, and so on. The following conventions apply to this section: Term Meaning $<name> Environment variable <DBSID> $ORACLE_SID <TSP> Tablespace short name For example, BTABD for the tablespace PSAPBTABD.

Environment Variables (Windows) for Oracle database and BR*Tools

2012-02-16T20:53:00.001+05:30

Environment variables define parameter values used by the Oracle database and BR*Tools. This section describes the variables used when the operating system is Windows. The database uses the parameter values for many different purposes. BR*Tools also uses the parameter values. The following variables are required: · ORACLE_SID System ID of the database instance Example: C11 SAPSID or

Environment Variables (UNIX) for Oracle database and BR*Tools

2012-02-16T20:52:00.001+05:30

Environment variables define values used by the Oracle database and BR*Tools. This section describes the variables used when the operating system is UNIX. The database uses the environment values for many different purposes. BR*Tools also use the values. The following variables are required: · ORACLE_SID System ID of the database instance Example: C11 SAPSID or sapsid refers to the SAP

Starting BR*Tools

2012-02-16T20:49:00.001+05:30

You can use this procedure to start BR*Tools for Oracle. You can only use BR*Tools to manage a database system that is running on the same host system. Check the below points before starting BR*Tools · Make Sure you have configured: ¡ The database system ¡ BR*Tools · Logon user You can log on as the operating system user who owns the data files of the database system

Configuration of BR*Tools

2012-02-16T20:39:00.001+05:30

To get started with BR*Tools, you need to configure it. Prerequisites · You have made any required settings in the initialization profile. The default Initialization Profile init<DBSID>.dba is: UNIX: <ORACLE_HOME>/dbs/init<DBSID>.sap Windows: %<ORACLE_HOME>%\database\init<DBSID>.sap Changes to profile parameters become active when you start BR*Tools. · You have set the environment

Oracle Restore and Recovery for SAP

2012-02-16T20:34:00.001+05:30

This section helps you to develop an approach to restore and recover of your Oracle database in the event of failure. Always analyze the problem carefully before attempting to recover your database. If in doubt, seek support from SAP. The business costs of an incorrect or delayed recovery can easily outweigh consultancy fees. We strongly recommend you to practice restore and recovery on a test

SAP eBooks Complete Collection (File4sharing Links)

2012-02-01T00:21:00.002+05:30

http://file4sharing.com/1gqvmv63vx0t/ABAP151 - ABAP Objects for Java Developers.pdf.html http://file4sharing.com/togone52q2wx/ABAP152 - Efficient Database Programming with ABAP.pdf.html http://file4sharing.com/hpdnhxb2lfpb/AC010 - Business Processes in Financial Accounting.pdf.html http://file4sharing.com/k41hqp8sfhdc/AC020 - Investment Management.pdf.html http://file4sharing.com/nhve1veaqizp

Client is not Available in this System

2012-01-11T13:26:00.001+05:30

Symptom You get an error " Client is not available in this system" when trying to login to the SAP system. Solution Login to the SAP system using client 000. Execute transaction code SCC4 to check all the client list that are available in the system.

How to Check ABAP System Logs & Traces

2012-01-11T13:24:00.001+05:30

1. During the starting of SAP system, events are written to log files. These files are extremely important from the point of view of identifying and troubleshooting problems. Logs of the SAP start process are stored in the file system and can be opened and read by the <SID>adm user. 2. Log file in Windows. • Filepath where logs reside : <Drive>:\usr\sap\<Sys-ID>\DVEBMGS<Sys-Nr>\Work. •

How to Specify Update Server Name if Load Balancing is Deactivated

2012-01-11T13:22:00.001+05:30

In the standard system, this parameter, rdisp/vbname specifies the name of an update server (set when the update server is created). If rdisp/vb_dispatching is set to 0, the updates are only processed by the server in rdisp/vbname. If the parameter has not been set correctly (not to an update server), this is reported when the installation check is performed (transaction sick ). You need to

SAP Start Job Conditions

2012-01-11T13:19:00.001+05:30

Immediate This job will start as soon as possible, subject to job priority and the availability of background work processes. Users granted the appropriate authorizations for background processing can have their jobs released automatically as soon as they are scheduled, without special attention from a system administrator. Date/time The job will start at the date and time specified, subject

How to Configure & Activate SAP TMS Backup Domain Controller

2012-01-11T13:15:00.001+05:30

Configuring the Backup Domain Controller Prerequisites In your transport domain, the SAP System that is configured as the domain controller is of special significance. If this SAP System fails, you cannot make changes to the TMS configuration during this time. Therefore if your transport domain contains more than three SAP Systems, we recommend configuring a backup domain controller. If your

Recommended Buffer Quality in SAP System

2012-01-11T13:13:00.001+05:30

The following describes how the buffer quality of the SAP buffers should be in a SAP System with good performance. Repository buffers (nametab buffers) The qualities of the Repository buffers can reach 99.9% in a system that has been running for a few days. If the buffer quality is less than 95%, you should investigate the situation further. Check the: • Available freespace• Available

STMS: Request is After End Mark

2012-01-11T13:12:00.001+05:30

Symptom Requests after the end mark are not imported during the next import. The end mark is automatically deleted only when the next import has completely ended. Afterwards, the requests can be imported. Solution 1. Choose the transport request. Go to Queue > Move end mark. or 2. Open the import queue (the import queue may accidentally lock by user). Click on the lock icon (next to lorry icon

How to test RFC authorization for TMSADM & Reset TMSADM

2012-01-11T13:11:00.001+05:30

Symptom When you try to execute authorization test for TMSADM in transaction code SM59, you see this error, " User TMSADM has no RFC authorization for function group SYST ". (SM59 -> TMSADM@<SID>.DOMAIN_<DomainController <SID> -> Test Connection / Remote Logon) Solution 1. Check the TMSADM authorization profile S_A.TMSADM is already assigned or not. The TMSADM must be check via client 000. 2.

Download SAP Training Simulators (Includes All Modules)

2012-01-11T12:40:00.002+05:30

SAP Visual | 2008 | SAP iTutor Video files | 800x573 | English | 1376 files | SIM | Learn SAP on your system without installing SAP with SAP Visual's Training Simulator pack consisting of 1300+ sap simulators useful for beginners and professionals to learn all SAP modules. SAP is the acronym for Systems, Applications and Products in Data Processing. It was started in 1972 by

How to Find SAP Objects in Requests & Tasks

2011-12-22T23:01:00.001+05:30

This program searches for objects in requests and tasks. You can specify the objects in the selection screen. Some object types used frequently are already listed, you only need to enter the name of the object itself (generically if you want). You can enter other object types yourself. You can restrict the requests/tasks by entering, for example, the number of the request, the owner, date

How to Troubleshoot Mapping Error: JCO Communication Failure

2011-12-22T22:59:00.001+05:30

Sympton • In transaction code SMQ2, you received "XI Error JCO_COMMUNICATION_FAILURE.MAPPING: Queue error".• When executing the RFC test connection on AI_RUNTIME_JCOSERVER, AI_VALIDATION_JCOSERVER, LCRSAPRFC and SAPSLDAPI, you received error " ERROR: program AI_RUNTIME_SID not registered". Cause At first, go for the logs file. From there, you'll find the specific root cause of the error.

How to Delete Short Dumps from the SNAP Table

2011-12-22T22:57:00.001+05:30

There are different ways of deleting short dumps from the SNAP table. However, before you delete them, you must analyze the cause of the short dump using transaction code ST22. If the issue related to short dumps is resolved, you can proceed to remove the short dumps before they all filling up the hard disk of your system. Here are the several ways to delete the short dumps: 1. Dump analysis:

How to Lock & Unlock Whole SAP System

2011-12-22T22:56:00.001+05:30

You can lock and unlock whole SAP system using command prompt. This example is tested in UNIX and Linux environment. Please use adm user when executing the command. • To lock the whole SAP system execute this command: > tp locksys pf=/usr/sap/trans/bin/TP_DOMAIN_.PFL initial value of NLS_LANG: 'AMERICAN_AMERICA.UTF8' This is tp version 372.05.14 (release 700, unicode

How to Configure RFC Destinations in ABAP & JAVA Environments

2011-12-22T22:52:00.001+05:30

You need to create the following RFC destinations with both transaction SM59 (ABAP) and the Visual Administrator (Java). AI_RUNTIME_JCOSERVER Points from the Integration Server to the mapping runtime. The program ID corresponds to the entry under JCo RFC provider for the J2EE Engine (used for the mapping runtime, value mapping, and the exchange profile). AI_DIRECTORY_JCOSERVER Points from the