SAP - Systems Applications and Products in Data Processing

In transaction ST03 or ST03N, the system does not recalculate or display any weekly workload data.

Cause:This problem occurs as of February 22, 2010 (22.02.2010).

Particularly for the weekly workload data, the entries in the key field SRTFD in the table MONI are created so that the last four digits are reserved for the consecutive week number, starting with December 24, 1990 (24.12.1990).

correction: Implement SAP note:1443908

Crontab – Quick Reference

Setting up cron jobs in Unix and Solaris

cron is a unix, solaris utility that allows tasks to be automatically run in the background at regular intervals by the cron daemon. These tasks are often termed as cron jobs in unix , solaris. Crontab (CRON TABle) is a file which contains the schedule of cron entries to be run and at specified times.

A crontab file has five fields for specifying day , date and time followed by the command to be run at that interval.

*     *     *   *    *        command to be executed

-     -     -   -    -

|     |     |   |    |

|     |     |   |    +----- day of week (0 - 6) (Sunday=0)

|     |     |   +------- month (1 - 12)

|     |     +--------- day of        month (1 - 31)

|     +----------- hour (0 - 23)

+------------- min (0 - 59)

Before we move on to learning commands used in Linux. Let us walk through the important Linux Directories, Configuration files and block devices in Linux.
It is important that we understand the file system in linux and also have a basic knowledge about where the programs reside in the machine, where to look for what and how to make it easy for ourselves when working on a Linux machine.

To Change Oracle database archive log mode

To check archive log mode of Oracle Database trigger the following command
in SQL Prompt.

SQL> select log_mode from v$database;

1) Turn Archive Log Mode ON:

Login to Database host
SQL> sqlplus "/as sysdba"
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;

2) Turning OFF Archive Log Mode:

SQL> shutdown immediate
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;

It all began in 1991 when a Finnish student, Linus Torvalds started working on a personal project and required posix standard definition which led to the creation of a new operating system kernal. Since then the Linux Kernal has been constantly updated and improved to meet the never ending requirements of the world. Since the initial release of its source code in 1991, it has grown from a small number of C files under a license prohibiting commercial distribution to its state in 2009 of over 370 megabytes of source under the GNU General Public License.

While doing ABAP + JAVA System Copy Following Error occurred:
FJS-00003 TypeError: sourceProps.get ("src.ci.host") has no properties

Solution:
Copy the SOURCE.PROPERTIES from the Central Instance export
to the Java export DVD or add the property src.id.host to the
SOURCE.PROPERTIES file using the value created by the Central
Instance export.

Here I went to the location of JAVA Dump and opened SOURCE.PROPERTIES file
Added src.ci.host=

SAP Note 1238351 explains this issue in more detail.

ORA-12560: TNS:protocol adapter error while connecting to Oracle Database through SQL Prompt

Possible reasons why you are facing the error:

1) Oracle Service has not yet started
Check:

Start Run --> Services.msc --> search for oracleservice --> Right click and start if it is stopped

2) Check if ORACLE_SID environmental variable is set and value has correct Database SID.

Right click on My computer --> Properties --> Advanced --> Environmental Variables --> Search for ORACLE_SID in User Variables for current user

3) Check parameter SQLNET.AUTHENTICATION_SERVICES value is set to NTS in sqlnet.ora

4) Check if TNS_ADMIN environmental variable is set on Database host and pointing to right directory. This should be pointing to drive:\ORACLE_HOME\network\admin

5) Check if listener is up and running. This is again in windows services or you can type the following command in command prompt for status

lsnrctl status

If you find listener is not running then type the following command

lsnrctl start

startsap and stopsap is not working on virtual host installation or high availability installation.

Error: No Profiles Found

This issue usually arises when Virtual Host was used for installation. You have couple of options which you might explore.

Temporarily you can use startsap [Virtual Host] and stopsap [virtual Host] for starting and stopping SAP.

If you want to fix this permanently then follow one of the two methods below:

1) First Method:

a) Make a copy of startsap script.
SIDADM> cp startsap startsap_orig

b) Edit startsap and Search for string START_PROFILE=START_${1}_${HOSTNAME}

c) Replase ${HOSTNAME} with the Virtual Hostname Used for installation.

2) Second Method:

a) Find the string setTrace "##### getarg() start"

b) Replace VHOST="" with VHOST="Virtual Hostname"

Repeat the same for stopsap script.

What is SLD?
SLD is the acronym of “System Landscape Directory» - Is a Java Application running
in all the Sap Java Systems - Is used like Central Information repository of all your
system Landscape - SLD use the Common Information Model (CIM), this is a
standard object oriented modeling DB.

Who use SLD?
SLD is used by:
- Process Integration.
PI/XI use SLD like the repository of all the Business Systems definitions, without this service PI/XI doesn’t run.
- Solution Manager
SM Read the Information from the SLD and refresh the technical definition on SMSY.
- Portal
Used by the JCO Destination.
- NWDI
Identify the role of the system and the Name reservation
- .SLM
Software Lifecycle Management is the tool provide by SAP to make the pacification of you Landscape.
- NWA
In SLD you can create Groups used by NWA to administrate more efficiently the Landscape.
- ACC
To know all the Systems in your Landscape.

SLD Strategy
The strategy for the SLD is very important, you need to decide in witch way you want administrate the SLD Information, there are several way and key
points(Important, Version, Etc) - You can check in
https://www.sdn.sap.com/irj/sdn/nw-sld the SLD paper to develop your strategy.
(My recommendation is read the Planing Guide for SLD).

Access to the SLD
To access to the SLD you can run the transaction SLDHTMLGUI or Goto
http://:500/SLD

Create Landscape
The Landscape definition are used by different applications, Is the best way to
group your systems to Administrate better - You can create Landscape to:
- Administration
which is created for administration purposes, for example, for common
monitoring.
- General
which can contain all types of application systems.
- NWDI Systems
that contains servers of the NWDI
- Scenario
is created for a specific business scenario - Scenario landscapes are used in the Software
Lifecycle Manager of SAP Netweaver.
- Transport
is created for transport purposes - For example, all SAP Web AS systems that are connected by an
ABAP transport path distributing the ABAP development.
- Web Service
is created to collect systems offering Web services and their clients - The hierarchy of these
landscapes defines the Web service that is most appropriate for a given client.
click in “New Landscape”
Complete with the Name and Landscape Type and Create
You can add new Systems to this landscape clicking in “Add System to
Landscape..”.

Create Technical System
Is recommendable to create the System in Automatic way using RZ70 in Abap, SLD
Data Supplier in Java or sldreg in other instances types. If you want you to create manually you need to go to SLD main Screen and click in Technical System.

• Click in New Technical System.
• Complete with the System Name and Hostname
• Select the Installed Product and the Software component and then click in Finish button.
• Now you can see the System in defined in the technical Systems Screen.

1) Unlocking User Account in Oracle

SQL> Alter user account unlock;

Note: in the above command needs to be substituted by the user account you want to unlock.

2)Adding Datafile to tablespace from Oracle.

SQL> ALTER TABLESPACE ADD DATAFILE ''
SIZE 5000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M;

= Tablespace name in CAPS
= Destination of datafile (Ex: /oracle/PRD/sapdata1/data_7/..)
Note: Data file added through oracle should be in correct sequence to previous one.

Also You can use BRTOOLS to do the same.

3) To Find all the datafiles of a tablespace / list of datafiles for tablespace:

SQL> select file_name from dba_data_files where tablespace_name='';

4) To get the number of active sessions in Oracle

SQL> select count(*) from v$session where status ='ACTIVE';
or
SQL> select count(*) from v$session;

5) Following command gives you the size of oracle database in GB

SQL> Select sum(bytes)/1024/1024/1024 from dba_data_files;

Symptom: While doing refresh on Windows using SAPINST you get the following error:
"Service marked for deletion"

Solution: This happens as SAPINST tries to delete the existing SAP Service from services.msc and create a new one with same name. Please follow the procedure below to resolve this.

GOTO run and type regedit

1. Stop the service you want to remove

2. Find the registry entry:

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services

4. Find the service name there and delete it.

Also you can run sc delete from cmd

Note: Please be careful while handling Microsoft registry as it can cause non-reverse-able damage to your system.

Then restart SAPINST and continue old installation

Reason: If all the administrative users are locked and if no other user has access then you have to unlock SAP* to be able to login to SAP.

Solution:

First insert the following parameter in Instance Profile:
login/no_automatic_user_sapstar = 0

Restart SAP Only.

Then login to Oracle and execute the following commands:

SQL> Delete from .usr02 where bname = 'SAP*' and mandt = '***';
SQL> Commit;

Note: Please substitute mandt=*** with the client number and with actual schema.
Example: So the command would look like this if SAPSHEMA is SAPSR3 and Client you want to unlock SAP* is 400
SQL> Delete from sapsr3.usr02 where bname = 'SAP*' and mandt = '400';

1) When running SAPINST for DB Installation you encounter following error:
Error:
FCO-00011 The step checkForLoadType with step key |NW_Java_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_CreateDB
|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|checkForLoadType was executed with status ERROR.

Solution:
Edit the control.xml in the installation directory:
Search for "update ORACHECK_PAR" and delete the row "row.createDb = false;" underneath.

This error happens typically when using Homogenous Backup/Restore Procedure in SAPINST.

Then restart SAPINST with old options.

Also SAP Note 970518 might help you

Requirement: Need to create multiple users in SAP
Creating multiple users can be a hectic tasks specially when you have to create multiple users with same roles

Procedure:

Enter Transaction SU10 in SAP
Enter all the users in the table below
Press Create Button
Enter User Type --> Dialog
Depending on the requirement fill out the other details
Goto Roles tab and enter the roles required (Please note that same roles will be given to all the users)
Based on the requirement you can also assign profiles / groups
Then Press Save

Result: You have created mass users with same role.

Note: All the users are assigned random system generated password which can be viewed in log which is in the screen after you save.

To configure a system as the transport domain controller (and thereby configure a new transport domain):