Sapdatabase for all sap modules

sapdatabase provides you all sap modules information,latest updates

Sapdatabase for sap education

sapdatabase provides you all sap modules material,interview needs

Sapdatabase for all sap information

Sapdatabase makes you as a sap professional

Sapdatabase for outsourcing and online training

Sapdatabase provides you online training,outsource services for all sap modules in econamic fee

Sapdatabase for sap jobs

Sapdatabase makes job searching for you

Showing posts with label SAP BASIS. Show all posts
Showing posts with label SAP BASIS. Show all posts

Friday, October 3, 2014

Saposcol and hostcontrol stop and start procedure to reflect services in wily

Saposcol  and hostcontrol start procedure

1. Go to the OS level of the affected system.
2. Check the SAPHOSTEXEC and SAPSTARTSRV process via "ps -ef | grep hostctrl".
3. Remember that both processes should be running,if 1 of those process is not running. Restart both processes.
4. Kill the existing SAPOSCOL process, make sure that the oscol shared memory is also cleared up.
Check via "ipcs | grep 4dbe" and clear the oscol shared memory via "ipcrm -m sharedMemoryNo" .
5. To startup the SAPHOSTEXEC and SAPSTARTSRV processes, execute following with those sequence as ROOT user.

a. Go to /tmp directory and delete the file .sapstartsrv99_sapstartsrv.log
b. cd /usr/sap/hostctrl/exe
c. Execute the command line "./sapstartsrv pf=/usr/sap/hostctrl/exe/host_profile -D"
d. Execute the command line "/usr/sap/hostctrl/exe/saphostexec pf=/usr/sap/hostctrl/exe/host_profile"
e. Execute the command line "/usr/sap/hostctrl/exe/sapstartsrv pf=/usr/sap/hostctrl/exe/host_profile -D"

6. Check the processes via "ps -ef | grep hostctrl" ; 3 processes should be running SAPHOSTEXEC, SAPSTARTSRV and SAPOSCOL.
7. Restart the SMDAgent and verify again in Wily.

Sunday, January 19, 2014

How to check sap systems status at os level in one Vlan and host names

Run this scripts from only pacadm
acservices --services ---->   All the sap systems status in Vlan  (up and running or not)
acservices --hosts    ----->  All the systems hosts in Vlan  

How to clear shared when restart the sap server

Clear Shared Memory:

cleanipc <sys no> –remove all
 ipcs –m|grep <sidadm>
 ipcrm –m <process ID>
 ipcs –s|grep  <sidadm>
 ipcrm –s <process ID>

Commands at AIX and Linex os level to know the status process in sap

Commands at os level

ps -ef|grep sap
ps -ef|grep ora
ps -ef|grep ctm
ps -ef|grep ccm
ps -ef|grep smd
ps -ef | grep igs
ps -ef | grep jl
df -k
df -h

Steps to Change ARCHIVELOG to NOARCHIVELOG in oracle database

Change ARCHIVELOG  to NOARCHIVELOG in oracle database

1. Login as ORA<SID>
2. sqlplus "/as sysdba"
3. select log_mode from v$database; - check if value is still as below:
4. Stop SAP (CI and Apps) and Database using scripts.
5. SQL> startup mount;
6. SQL> alter database noarchivelog;
7. SQL> alter database open;
8. SQL> select log_mode from v$database;


9. Restart the system from Apps -> CI -> DB using scripts.
10. Perform health check.

Tuesday, October 2, 2012

perform the System Monitoring configuration using Solution manager in the Landscape

Execute the Transaction code “DSWP”
Select the Solution
Come to Operations Setup and click System Monitoring
Click the Setup System Monitoring
Click on Setup System Monitoring:Note: Operation cannot be created with error” not a Number” Cannotconvert the “INITIAL” (CX_SY_REF_IS_INITIAL occurred) this errorsmeans that the installation number is not available or license is notappliedSelect
Select the check box Active and save to display the monitoringactivities

Double-click on SM_WHPCLNT800_READ RFC and change theusername and password in logon & Security Tab

Click on ‘save”
Click on “Remote Logon”
Now the RFC is working successfully
CCMS connectivity is Done Successfully.
Select the alert and specify the own threshold values and click on‘save”
Click on “Yes”
Select the alerts that need to display in the alert overview.The System Monitors all the selected Activities against thresholdvalues for every 5 minutes and displays them in the alert overview
The System Monitoring is Configured Successfully.

Saturday, September 29, 2012

Sample Fresher SAP Basis Security resume

Abdhul kalam

Professional Summary:

·         Having 1+ year of experience in SAP as a SAP Basis and Security Consultant. Experience in R/3, GRC Authorizations, GRC and Security Project Support, R/3 monitoring. Documenting the Procedures and policies.
·         Preventative, mitigating and compensation controls to ensure the appropriate level of protection and adherence to the goals of the overall SAP security strategy
·         Experienced in background job management like monitoring, Defining and scheduling background jobs.
·         Experienced in user Administration Creation of users, mass users, user groups, Lock and unlock the users.
·         Experienced in client Administration & Maintenance, Creation of clients and defining Client settings, Create Logical System names and Assigning logical system names to Clients. Local client copy, Remote client copy.
·         Knowledge on BW Administration workbench- BW Info cubes, Info objects, Hierarchy, Variables, Update and transfer rules, Info Areas, Info object catalog.
·         R/3 profile maintenance, maintain parameters in default, startup, instance profiles.
·         Knowledge on Maintenance of HR organizational structure to administer and control user access, including time-delimited access (e.g. temporary assignments to positions)

Technical skills:

ERP                       :   ECC 6.0 ehp5
Database               :   Oracle 10g,11g
Operating Systems: Windows server 2008R2,Suse linux 11sp1  


·         Currently working at SAPDATABASE as SAP Security Consultant.

Education Qualification:

·         2010 Mater in Computer Application Acharya Nagarjuna University, India.

Current project:

SAPDATABASE from April 2010 to till date 
Client Description:
SAPDATABASE is one of the Largest 3rd party web portal in india.
Client                          :           SAPDATABASE
Environment               :            ECC 6.0 ehp5 & Net weaver 7.3, GRC 5.3, Oracle 10g
Designation                 :           Junior Basis Consultant.
Duration                      :           April 2010 to till date
Project type                 :           Support
Team size                    :           2

Roles and Responsibilities
  •  Checking the SOD while creating the new userids.
  • Checking the SOD for New roles and existing roles.
·         Creating and testing the RFC destinations.

  • Restricted users access to transaction SE38 and advised alternate solutions to it.

  • Creating the mitigation controls.
  • Taking the Fire fighter reports.
  • Created the Base and derived roles.
·         Creating new user accounts and user groups
·         Analyze the user problems by using SU53.
·         Role maintenances and creating transport request for roles.
·         Mass user Maintenance.
·         Removed the SAP Roles
·         Identifying potential SOD issues before assigning new roles to the user.
  • Providing the firefighter access to the users.
  • Periodical checking daily firefighter ID logs.
  • Tracing the missing authorizations and analyze the user problems by using ST01.
  • Creating new user accounts and user groups.
  • Spool Administration.
  • Table space Administration: Checking for space problems in table space, adding data file to table space using BRTOOLS.
  • Configuring Logon Load Balancing using SMLG.
  • Applying Support Packs and add-on via SPAM/SAINT.
  • Monitoring System Logs and ABAP Dump Analysis.
  • Day to day monitoring of systems.
  • Monitoring and scheduling background jobs
  • Monitoring database backups and archive log space.
  • Database administration and adding Data file when required.
  • User Administration like user creation, deletion of users and mass user creation.
  • Handling user problems like resetting passwords, unlocking the users.
  • Handling security issues like role creation, role modifications.

Transferring Users from Central to Client system in CUA

You would have heard about transferring the users from client system to central system in CUA using transaction code SCUG
       But you can also transfer the user information including role assignment from central system to client system using report RSCCUSND.
1) Go to SA38 -> RSCCUSND -> 
2. Here you can specify the receiving or child system name and other information and execute.

This is helpful when you perform the client refreshment and you need the old users and role assignments information back from central system