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

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
df

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;

LOG_MODE
------------
NOARCHIVELOG

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