Tips and Tricks ..... Cooking, keep watching this space for new tips
*********************************************************
TU02 Shows current parameters for all hosts and gives a history of changes to parameters
CG3Y export and CG3Z Import files from to sap server
| /$tab | Reset all buffers (for System Administrators) |
| /$sync | Synchronize instances buffers (for System Administrators) |
OY19 contents of a table between two systems can be checked (Table analyses between two systems )
___________________________________________________________
Useful reports :
You can use report RSBDCOS0 to execute OS commands from SAP
SAP system auditors reports (These reports come with the RSUSR prefix)
RSUSR003 : allows you to know from a glance whether standard users like SAP*, DDIC, SAPCPIC and Earlywatch these accounts have been appropriately maintained or not.
RSUSR005 : This report displays users with critical authorizations
RSUSR006 : provides a list of all users that have been locked as a result of entering incorrect password in the system.
RSUSR007 : For some reasons or the other, it is possible to have users that have incomplete address data this report used to generate a list of such users.
RSUSR008 : The report lists users that have incompatible combination of critical authorizations and/or transaction.
RSUSR009 : The report displays users who posses’ critical authorization and it allows you to explicitly specify the critical authorization in the selection criteria.
RSUSR100: This report is generated when you need to review change documents for users. It shows modifications to the user’s security.
RSUSR101: This report is generated when you need to review change document for profiles. it shows modifications made to profile security.
RSUSR102: This report is generated when you need to review change documents for authorization. It shows modifications made to authorization security.
SAP system useful reports:
| RSCLTCOP : Copy tables across clients RSAVGL00 : Table adjustment across clients RSORAREL : To know oracle release |
RSPARAM : Display all instance parameters
RSTPTEST : To test the tp
General Tips:
Work processor conjunction can be checked via transaction AL12 > statistics > cursor cache > all servers you will find total requests handled by each work process, It means time to add more work processors.
To know full path of environment variables in windows use command :
echo %oracle_home%
What is OPS$ User in sap ?
For the database, the SAP system is a single user i.e., SAP<SAPSCHEMAID> or SAPR3 whose password is stored in the table SAPUSER there fore to access the database, the SAP system uses a mechanism called the OPS$ mechanism, which works as follows:
1) When the SAP system accesses the database, it first logs on to the database as user OPS$<operating_system_user>, for example, OPS$<domain>\<sapsid>adm
Note:
The OPS$ user that corresponds to the operating system user must be defined in the database and identified as externally
2) It retrieves the password for SAP<SAPSCHEMAID> or SAPR3 from the SAPUSER table
3) It then logs on to the database as the user SAP<SAPSCHEMAID> or SAPR3.
...
