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

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.

move oraarch files with manual script

while true; do mv <SID>arch file* /oracle/SID/archivpool; sleep 5; done

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.