After completion of SAP R/3 central and database instance, we have to do some initial post installation checks before continue working with R/3 application. I will explain you how to do all those steps in this article. We should get the screen with message “Successfully Installed” in database instance installation wizard before proceeding post installation steps. We have to do the following tasks after successful completion of R/3 installation. I am using ECC 6.0 with sql database to explain this topic. The step are…
- Starting and stopping of SAP system
- Starting and Stopping of database
- Checking database and sap services
- Checking sap system profiles
- Checking sap ports configured
- Installation and configuration of SAPGUI
- Logging into the SAP system using it’s default client and users
- Check the installation after logging into the SAP system
- Creating new users and logging into the SAP system with newly created users
Starting and stopping SAP: We have to start the SAP system as soon as the server starts. We can not access the SAP system without starting it. We can start the SAP system in two ways. One is through SAP Management Console which is installed during the central instance installation. Second is to start through command prompt.
- Starting SAP system from SAP Management Console is very easy. Right click on the SID of the SAP system and click start. Depending on the hardware configuration, this step may take 1/2 a minute to 5 minutes. We have to check ABAP WP Table for all work processes come into wait status. There is an indication of colour green that all the services started and ready for use. This screen is mostly self explanatory.
- We also can start the SAP system using the command “startsap name=sid nr=sn sapdiahost=hostname” All the exe files will be located in the directory ( D:usrsapDEVSYSexeucNTI386) Drive letter may vary from installation to installation based on your selection during central and database instance installations.
Starting and stopping database:We can start and stop oracle database using the command “sapdba” Database administration can be done by using this command in SAP. Database can be stopped and started in MS Sql server is from it’s interface. MS SQL can be accessed from start – programs – Microsoft SQL Server 2005 – SQL Server Management Studio. Right click on the database which is related to SAP and click tasks and detach. You should stop the SAP system first to detach the database. Be careful in managing database, because it is so critical to SAP system. Nothing is there in the SAP system without a database.
SAP and Databse Services:There are 3 services are required in database and 2 services in SAP to start the SAP and Database systems. They are SAPSID_SN, SAPOsCol, SQL Server, SQL Server Agent, SQL Server FullText Search. SN – System Number in the list mentioned. All these services to be in started to start SAP system. Services can be accessed either from command prompt using command “services.msc” or from Programs – Administrative Tools – Services.
System Profiles: We should have system profiles to start SAP system. The SAP system will start by taking parameters from this profile file. There are three types of profiles. They are Default profile, Start profile and Instance Profile. These profile files are located in the folder D:usrsapDEVSYSprofile in a SAP system. We can open these files in the note pad for checking the parameters.
SAP Ports: The ports are most important in SAP system. All the communications will be done using these ports in SAP system. Port is a number which is assigned during the central system (CI + DI) installation. The list of ports assigned can be viewed from C:WINDOWSsystem32driversetcservices. This file can be opened using note pad to view the list of ports and services. We can test by putting # in front of the message port “sapmsDEV 3600/tcp # SAP System Messaging Service Port” and save and try to start the SAP system. SAP system will be started but we can not login into the system without message service. Message service is required to communicate with database. We will get error when we try to login to the SAP system.
Installing and configuring SAPGUI:Installation of SAPGUI (Presentation server) is normal installation just like any other software application. It can be uninstalled from Add/Remove programs in control panel. We will get an icon on the desktop to start the SAPGUI. We need host name, sid and system number to configure SAPGUI. We have to use the button “New Item” to create the entry to login to any specific server with it’s SID and System number. We can configure any number of entries in the SAPGUI screen. The information about this list is stored in the location c:windowssaplogon.ini This file can be stored and send it any body who wants to access the SAP system in network. saplogon.ini file can be copied to the above location to get the list of servers with it’s SID and system numbers. We can use any of the entry to connect to the related SAP system through network.
Default clients and users in SAP System:There are three default clients and two users in SAP system. The clients are 000, 001, 066 and default users are ddic and sap*. The passwords of these users are the same as the password which we give at the time of central instance installation. We should have compulsorily client, user name and password to login to the sap system.
Checking the installation of SAP: We can check the installation of SAP R/3 application software by typing the transaction codes sick or SM28. We should get the information like “no errors reported”. We get this message when the installation of SAP is error free. We also can check the system status by clicking system and status. In this screen we can see the version of the SAP system and also the database version along with patch information.
Creating new users in SAP system:We can create users in SAP system using transaction code SU01. We also can access user creation screen from the navigation menu “Tools – Administration – User Maintenance – Users”. Also can be seen the transaction code of this navigation from the bottom right corner after clicking on the navigation menu item for execution. In this way we can see and learn all transaction codes by following this method. We can create, change, display, delete, copy, lock and change the password of any user if we have proper authorization. The key board shortcuts can be viewed by placing mouse on the related buttons. We can use newly created users to login to the SAP system. We have to change the password of the user when we try to logon for first time.
I think i have covered all the post installation steps to be checked before understanding about advanced topics in the sap basis administration in this article. Please comment on this article for any additions or deletions of the above list. You can ask me for any further doubts using this article’s comments section.