Таблицы с информацией о ролях в системах SAP. Крайне полезная штука. AGR_DEFINE – имя роли и присвоение функциональной роли типовой AGR_PROF – профили полномочий для ролей и их имена AGR_TCODES – транзакции включенные в роли AGR_1251 – объекты и значения полномочий к роли AGR_1252 – значения организационных уровней в функциональных ролях
30 years in IT
Oracle dictionary statistics and system statistics | Create new statistics for all tables without a necessity check
We have Note 838725 – Oracle dictionary statistics and system statistics Creating Oracle dictionary statistics using BRCONNECT BRCONNECT command to create Oracle dictionary statistics: OS> brconnect -u / -c -f stats -t oradict_stats Creating Oracle system statistics using BRCONNECT Creating Oracle system statistics (NOWORKLOAD) using brconnect $ brconnect -u / -c -f stats -t system_stats Create new statistics for all tables without a necessity check brconnect -u / -c -f stats -t all -f collect
Saposcol: data collection not up to date
Symptom We have an alert from our solution manager regarding the os collector where the Alert text shows the above message “Saposcol: data collection not up to date” Solution On AIX, this usually means the saposcol program has crashed, but the shared memory has not been released. Most of the time this can be corrected by running saposcol -f (force option). Another way to release shared memory I describe in post Problem with stop/start saposcol
Error: Remote access to the NetWeaver Administrator is forbidden. See SAP Note 1451753 for details.
Symptom We have error Remote access to the NetWeaver Administrator is forbidden. See SAP Note 1451753 for details. Solution The URLs for NWA have a unique prefix and can be filtered out in the ICM on a rule basis. In the profile file (we recommend the default profile DEFAULT.PFL), configure the following modification handler: icm/HTTP/mod_0 = PREFIX=/,FILE=$(DIR_GLOBAL)/security/data/icm_filter_rules.txt If you do not want to restrict access to the administration requests to certain clients, remove the lines from the file or turn the lines into a comment: #if %{REMOTE_ADDR} !stricmp 127.0.0.1 [AND] #if %{REMOTE_ADDR} !stricmp ::1 #RegIRedirectUrl ^/webdynpro/resources/sap. com/tc~lm~itsam~ui~mainframe~wd/(.)*$ /nwa/remote_access_error [QSA] Then restart … Continue Reading
Brtools permissions
For set correct permission and owners for brtools execute: chmod 4774 brarchive brbackup brconnect chown <orasid>:sapsys brarchive brbackup brconnect Note 113747 – Owners and authorizations for BR*Tools Solution The following settings are required to call the BR*Tools correctly, especially when using transaction DB13 or DBACOCKPIT: (1) ora<sid> and <sid>adm on DB server have a search path on /sapmnt/<SID>/exe. (All br* are contained in this directory.) ora<sid> belongs to the dba group, <sid>adm belongs to the sapsys group, (2) <sid>adm on the database server has the rhosts entry: “+ <sid>adm”. (3) The ops$<sid>adm Oracle user must be created in the DB and must … Continue Reading
Example ALTER DATABASE DATAFILE AUTOEXTEND ON MAXSIZE UNLIMITED
ALTER DATABASE DATAFILE ‘/oracle/SID/sapdata4/sr3731_4/sr3731.data4’ AUTOEXTEND ON MAXSIZE UNLIMITED;
How to delete entires from TPSTAT table
Symptom You want delete inconsistent entires from TPSTAT table (for example in case error message “Import for system SID target client already running”), Solution 1. Go to transaction stms. 2. Then push on truck icon->go into system queue 3. Menu GoTo->Import Monitor 4. Click on inconsistent entire right mouse button, in context menu select delete entry.
JRE 7.25 incompatible with PI Tools | LAZY_CLASSLOADING_FAILED
Symptom We perfromed upgrade JRE to version 7.25. We tried to run Enterprise Services Builder, we have error in popup window with text LAZY_CLASSLOADING_FAILED and buttons CHECK_LOG and CLOSE_BUTTON. Solution For temporary resolve this problem without deeper into OS config, We can disable the new version Java in Windows Control Panel -> Java -> “Java” tab page -> “View” button -> unmarked the “Enable” checkbox Now PI Tools work fine.
Problem with stop/start saposcol
Sometimes it may be impossible to stop saposcol either by “saposcol -d” –> kill or by “saposcol -k”. The system produces messages similar to: ======================================== can’t kill process 99687. kill: No such process ERROR:No reaction from collecting process 99687! Please kill collecting process. ======================================== Although no process with PID 99687 exists, the output of command “saposcol -s” shows that saposcol is running and shared memory is attached. In this case, stop the collector running by removing the shared memory key of saposcol. For this, execute command “ipcs -ma” and note the line that contains saposcol key “4dbe”. You need the shared memory … Continue Reading
SAP NW Java: Delete old dumps and trace files with command find
We recomend regulary check directory /usr/sap/<SID>/<INSTANCE>/j2ee/cluster/server<N>/, where can be hold old dumps and trace files. For examle, in Note 1289240 – How to deal with out of memory errors we can read The heap dump is generated in directory /usr/sap/<SID>/<INSTANCE>/j2ee/cluster/server<N>/ where N is the server node number. Automatically created heap dump on out of memory event is in OOM.hprof and OOM.addons files. User generated heap dump is in files named as java_pid<PID>.hprof and java_pid<PID>.addons, where PID is the process ID (9848 for example). Also we can find *.trc files. We recomend delete unnecessary files In case Unix We use command find cd /usr/sap/<SID>/<INSTANCE>/j2ee/cluster/server<N>/ find … Continue Reading