Understand the profile parameter in SAP

-
Understand the profile parameter in SAP –
Sap profiles contain parameters that specify how to startup an instance and how to setup the various variables that define the way the SAP instances and system work.
There are 3 types of profile by default in sap instance
1)START PROFILE
2)DEFAULT PROFILE
3)INSTANCE PROFILE
Default location for profile : /usr/sap/NW7/SYS/profile  (This is single node installation where DB and application install on same node)
DEFAULT.PFL
 NW7_ASCS31_#####
NW7_D32_######
Startup sequence of these profile are initially start profile read the start instance and then it read the default profile and then instance profile.
1)START PROFILE  —-
The SAP start profile executes commands that start the main services, such as message server and dispatcher etc.
Example of startup profile — profile with ASCS instance are startup profiles
SAPSYSTEMNAME = NW7
SAPSYSTEM = 31
INSTANCE_NAME = ASCS31
DIR_CT_RUN = $(DIR_EXE_ROOT)$(DIR_SEP)$(OS_UNICODE)$(DIR_SEP)linuxx86_64
DIR_EXECUTABLE = $(DIR_INSTANCE)/exe
DIR_PROFILE = $(DIR_INSTALL)$(DIR_SEP)profile
_PF = $(DIR_PROFILE)/NW7_ASCS31_####
SETENV_00 = DIR_LIBRARY=$(DIR_LIBRARY)
SETENV_01 = LD_LIBRARY_PATH=$(DIR_LIBRARY):%(LD_LIBRARY_PATH)
SETENV_02 = SHLIB_PATH=$(DIR_LIBRARY):%(SHLIB_PATH)
SETENV_03 = LIBPATH=$(DIR_LIBRARY):%(LIBPATH)
SETENV_04 = PATH=$(DIR_EXECUTABLE):%(PATH)
#———————————————————————–
# Copy SAP Executables
#———————————————————————–
_CPARG0 = list:$(DIR_CT_RUN)/scs.lst
Execute_00 = immediate $(DIR_CT_RUN)/sapcpe$(FT_EXE) pf=$(_PF) $(_CPARG0)
_CPARG1 = list:$(DIR_CT_RUN)/sapcrypto.lst
Execute_01 = immediate $(DIR_CT_RUN)/sapcpe$(FT_EXE) pf=$(_PF) $(_CPARG1)
#———————————————————————–
# Start SAP message server
#———————————————————————–
_MS = ms.sap$(SAPSYSTEMNAME)_$(INSTANCE_NAME)
Execute_02 = local rm -f $(_MS)
Execute_03 = local ln -s -f $(DIR_EXECUTABLE)/msg_server$(FT_EXE) $(_MS)
Restart_Program_00 = local $(_MS) pf=$(_PF)
#———————————————————————–
# Start SAP enqueue server
#———————————————————————–
_ENQ = enq.sap$(SAPSYSTEMNAME)_$(INSTANCE_NAME)
Execute_04 = local rm -f $(_ENQ)
Execute_05 = local ln -s -f $(DIR_EXECUTABLE)/enq_server$(FT_EXE) $(_ENQ)
Restart_Program_01 = local $(_ENQ) pf=$(_PF)
#———————————————————————–
# SAP Message Server parameters are set in the DEFAULT.PFL
#———————————————————————–
ms/standalone = 1
ms/server_port_0 = PROT=HTTP,PORT=81$$
SETENV_05 = SECUDIR=$(DIR_INSTANCE)/sec
2)DEFAULT PROFILE
Default profile has profile parameter that are applicable to all the application servers of a SAP system.some of the parameter that should be entered in the default profile are message server hostname, transport directory path and default client number
The default profile start with DEFAULT* name
#.******************************************************************************                                                                                                                                                             ************************************************
#.*                                                                                                                                                                                                                                                                                         *
#.*       Default Profile DEFAULT                                                                                                                                                                                                                                                           *
#.*                                                                                                                                                                                                                                                                                         *
#.*       Version                 = 000003                                                                                                                                                                                                                                                  *
#.*       Generated by user = SAPS                                                                                                                                                                                                                                                          *
#.*       Generated on = 03.05.2020 , 14:28:25                                                                                                                                                                                                                                              *
#.*                                                                                                                                                                                                                                                                                         *
#.******************************************************************************                                                                                                                                                             ************************************************
#parameter created                          by: SAPS         03.05.2020 14:27:45
login/fails_to_session_end = 4
#parameter created                          by: SAP*         18.04.2020 07:05:17
login/no_automatic_user_sapstar = 0
SAPDBHOST =#####
j2ee/dbtype = hdb
j2ee/dbname = S4P
j2ee/dbhost = ######
dbs/hdb/dbname = S4P
SAPSYSTEMNAME = NW7
SAPGLOBALHOST = ######
system/type = ABAP
rsdb/ssfs_connect = 1
system/secure_communication = ON
rdisp/mshost = ####
rdisp/msserv = sapmsNW7
rdisp/msserv_internal = 3931
enque/process_location = REMOTESA
enq/enable = TRUE
enq/serverhost = ######
enq/serverinst = 31
is/HTTP/show_detailed_errors = FALSE
icf/user_recheck = 1
icm/HTTP/ASJava/disable_url_session_tracking = TRUE
service/protectedwebmethods = SDEFAULT
rsec/ssfs_datapath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)                                                                                                                                                             data
rsec/ssfs_keypath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)k                                                                                                                                                             ey
gw/acl_mode = 1
gw/sec_info = $(DIR_GLOBAL)$(DIR_SEP)secinfo$(FT_DAT)
login/password_downwards_compatibility = 0
vmcj/enable = off
login/system_client = 000
dbs/hdb/schema = SAPHANADB
3)INSTANCE PROFILE
 Profiles that are specific to a particular instance are entered in this profile.allocation of memory resources is good example of a profile parameter that should be entered in a instance profile
SAPSYSTEMNAME = NW7
SAPSYSTEM = 32
INSTANCE_NAME = D32
DIR_CT_RUN = $(DIR_EXE_ROOT)$(DIR_SEP)$(OS_UNICODE)$(DIR_SEP)linuxx86_64
DIR_EXECUTABLE = $(DIR_INSTANCE)/exe
DIR_PROFILE = $(DIR_INSTALL)$(DIR_SEP)profile
_PF = $(DIR_PROFILE)/NW7_D32_#####
SETENV_00 = DIR_LIBRARY=$(DIR_LIBRARY)
SETENV_01 = LD_LIBRARY_PATH=$(DIR_LIBRARY):%(LD_LIBRARY_PATH)
SETENV_02 = SHLIB_PATH=$(DIR_LIBRARY):%(SHLIB_PATH)
SETENV_03 = LIBPATH=$(DIR_LIBRARY):%(LIBPATH)
SETENV_04 = PATH=$(DIR_EXECUTABLE):%(PATH)
#———————————————————————–
# Copy SAP Executables
#———————————————————————–
Execute_00 = immediate $(DIR_CT_RUN)/sapcpe$(FT_EXE) pf=$(_PF)
Execute_01 = immediate $(DIR_CT_RUN)/sapcpe$(FT_EXE) pf=$(_PF)
SETENV_05 = SECUDIR=$(DIR_INSTANCE)/sec
_CPARG0 = list:$(DIR_CT_RUN)/sapcrypto.lst
Execute_02 = immediate $(DIR_CT_RUN)/sapcpe$(FT_EXE) pf=$(_PF) $(_CPARG0)
#———————————————————————–
# Start ABAP database
#———————————————————————–
Execute_03 = immediate $(DIR_CT_RUN)/startdb
exe/saposcol = $(DIR_CT_RUN)/saposcol
rdisp/wp_no_dia = 10
rdisp/wp_no_btc = 3
rdisp/wp_no_vb = 1
rdisp/wp_no_vb2 = 1
rdisp/wp_no_spo = 1
exe/icmbnd = $(DIR_CT_RUN)/icmbnd
#———————————————————————–
# Start SCSA administration
#———————————————————————–
Execute_04 = local $(DIR_EXECUTABLE)/sapmscsa pf=$(_PF) -n
#———————————————————————–
# Start application server
#———————————————————————–
_DW = dw.sap$(SAPSYSTEMNAME)_$(INSTANCE_NAME)
Execute_05 = local rm -f $(_DW)
Execute_06 = local ln -s -f $(DIR_EXECUTABLE)/disp+work$(FT_EXE) $(_DW)
Start_Program_00 = local $(_DW) pf=$(_PF)
#———————————————————————–
# Start internet graphics server
#———————————————————————–
_IG = ig.sap$(SAPSYSTEMNAME)_$(INSTANCE_NAME)
Execute_07 = local rm -f $(_IG)
Execute_08 = local ln -s -f $(DIR_EXECUTABLE)/igswd_mt $(_IG)
Start_Program_01 = local $(_IG) -mode=profile pf=$(_PF)
rsdb/dbid = S4P
PHYS_MEMSIZE = 6881
NOTE – to generate all profile list , please run t-code se38 and then  execute program: RSPARAM.
Default parameter are in the source code(kernel) and are read first at the instance start. If a user makes any changes to the default parameter , either in the default profile or instance profile, then that overrides the source code default parameter.

Comments

  1. raghu14 July 2021 at 03:27

    You have written an excellent blog. I learned something new from your Blog. Keep sharing valuable information.
    Oracle Training in Chennai
    Oracle Training in Bangalore
    Oracle Training in Coimbatore
    Oracle Course in Chennai
    Oracle Course in Bangalore
    Oracle Certification Course in Coimbatore
    Oracle Training Institute in Chennai
    Oracle Training in Madurai

    ReplyDelete
  2. jackobzaino3 March 2022 at 18:29

    Harrah's Lake Tahoe Casino & Hotel
    Get directions, reviews and 대구광역 출장샵 information for 오산 출장샵 Harrah's Lake Tahoe Casino & Hotel in Stateline, NV. 영주 출장샵 This hotel is 6.7 mi (10.7 km) from Harrah's Lake Tahoe Casino 통영 출장샵 and  Rating: 군포 출장안마 8.3/10 · ‎5,435 reviews

    ReplyDelete

Post a Comment

Popular posts from this blog

Query for Tablespace usage with Autoextend

-
                                         Monitoring Tablespace Usage in Oracle I often see questions in Oracle newsgroups and forums about monitoring space in tablespaces, and many of those questions are regarding Enterprise Manager 12c and the alerts it generates reporting the percentage of used space. Of course how you monitor free space depends on whether or not the datafiles are autoextensible. Let's look at several ways to monitor free and used space, starting with methods used in older releases. In versions prior to Oracle 10 DBA_TABLESPACES, DBA_DATA_FILES and DBA_FREE_SPACE were used to generate such reports. One script, from MOS, uses these three views to compute the used space percentage: SELECT SUM(s.used_gb)/SUM(f.total_gb)*100 FROM dba_tablespaces t, ( SELECT tablespace_name, SUM(NVL(bytes,0))/(1024*1024*1024) total_gb FROM dba_data_files ...
Read more

How to configure multiple Oracle listeners

-
How to configure multiple Oracle listeners It happened to me few times during the stress tests that Oracle listener became a bottleneck and not be able to handle the required workload. It was resolved by creating  multiple  listeners which appeared to be a quick solution.  Here is a short step-by-step procedure to configure multiple Oracle listeners  on Solaris for standalone Oracle 9i and 10g environment. 1)  First of all, add additional NIC and cables. They can be on separate subnetwork or the same. In the later, make sure to set static route if needed.    2) Assume that we are going to configure two listeners,   LISTENER and LISTENER2 Modify listener.ora and tnsnames.ora as following: Here is a sample of   listener.ora  LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.3)(PORT = 1521))     ) ...
Read more

sheel script - automatic tablespace addition in oracle 11g

-
      sheel script - automatic tablespace addition in oracle 11g #!/bin/bash a=`sqlplus -s / as sysdba <<END set pagesize 0 feedback off verify off heading off echo off; select tablespace_name from dba_segments group by tablespace_name having SUM(BYTES)/1024/1024>700; END` f=${#a} c=0 for file in $a ; do eval "var$c=$file"; c=$((c+1)); done echo $var0 array1=$(df -kh | grep '/u0*'|awk '{ print $6}') array2=$(df -kh | grep '/u0*'|awk '{ print $5}') size=${#array1} size1=${#array2} if ["$size" -eq 4] && ["$size1" -eq 3] && ["$array2" -gt 85%] && ["$f" -eq 1] then d=${array1[0]:0:4} sqlplus /nolog <<END connect /as sysdba alter tablespace $a add datafile '$d/$a01.dbf' size 10m autoextend on maxsize 28G; END` fi if ["$size" -eq 9] && ["$size1" -eq 3] && ["$array2 -gt...
Read more