Learn SAP Basis

Alter database end backup

2012-01-28T05:49:00.000-08:00

To find if database or any tablespace is in backup mode, the status in V$BACKUP is ACTIVE
SQL) select * from v$backup;

If the backup is stuck and you need to end that back up, give the below sql command :

SQL) ALTER DATABASE END BACKUP;
Database altered.

If one tries to perform shutdown of database when database is in BACKUP mode, you will receive the following error “ORA-01149″

SQL) shutdown immediate;
ORA-01149: cannot shutdown – file 1 has online backup set
ORA-01110: data file 1: ‘/oracle/SRS/sapdata1/sys_01.dbf’

If one tries to set the database that is already in backup mode, one will receive the following error “ORA-01146″

SQL) alter database begin backup;
alter database begin backup
*
ERROR at line 1:
ORA-01146: cannot start online backup – file 1 is already in backup
ORA-01110: data file 1: ‘/oracle/SRS/sapdata1/sys_01.dbf’

Using Device Pools in SPAD

2012-01-12T22:37:00.000-08:00

There was a requirement from customer to create a printer that saves a file at specific location and also prints simultaniously on a given printer.

In SPAD, instead of choosing it as a standard printer give Device Pool and save.
You will get a new tab Device pool where in you can define both the printers and choose option to print on both.

This works !!!:)

Kernel Downgrade

2012-01-12T22:29:00.000-08:00

We had a requirement where customer wanted to downgrade the kernel: The kernel in sandbox system EBS was on a lower level 7.20 90 and on test system EBQ it was on a higher level 7.20 114.

Due to some project go live that was scheduled the development was working in EBS System but when it was taken to the EBQ System, it didn't work well. SAP told that this is a kernel bug.

So, customer wanted to downgrade the same.

We followed the below procedure :

1) Dowloaded SAPEXE and SAPEXEDB files of version 90 from Service Marketplace.
2) Extracted those files in the already existing kernel of EBQ /sapmnt/EBQ/exe
3) We checked for lib dbsl there are two files dbhdbsllib.so dbsdbslib.so that also came included in the SAPEXE sar file.

In nutshell, extracting SAPEXE and SAPEXEDB kernel files in /sapmnt/EBQ/exe did the trick and the kernel was successfully downgraded from "Rel 7.20 patch 114" to "Rel 7.20 patch 90" exaclty same as in EBS System.

Security parameters related to Passwords expiry and other settings

2012-01-09T07:14:00.000-08:00

LOGIN/PASSWORD_EXPIRATION_TIME
0 (Number of days after which users will be required to change the parameters)

login/min_password_lng
6 8 Minimum password length will change from 6 to 8 characters

login/min_password_digits
0 1 Users will be required to use atleast 1 digit in their passwords

login/min_password_letters 0 1 Users will be required to use atleast 1 alphabet in their passwords

login/min_password_lowercase 0 1 Users will be required to use atleast 1 lowercase alphabet in their

login/min_password_uppercase0 1 Users will be required to use atleast 1 uppercase alphabet in their
passwords

login/min_password_specials 0 1 Users will be required to use atleast 1 special character in their passwords

login/password_max_idle_initial 0 14 Validity of initial password 0 0 Dates until password must be changed

Oracle sql query for autoextend off

2012-01-09T07:11:00.000-08:00

To find dba data files which are autoextensible:

$select FILE_NAME, AUTOEXTENSIBLE from dba_data_files where FILE_NAME like '%sapdata2%' and AUTOEXTENSIBLE='YES';

To turn off the auto extend for a file :

$ALTER DATABASE DATAFILE '/oracle/BIP/sapdata2/sr3usr_3/sr3usr.data3' autoextend off;

Oracle sql query to find sequence number of archive logs

2012-01-09T07:09:00.001-08:00

Oracle sql query to find sequence number of archive logs to be applied for recovery during restoring online database:

$ Select SEQUENCE#,to_char(FIRST_TIME,'YYYY-MM-DD:HH24:MI:SS') FIRST_TIME from v$archived_log where to_char(FIRST_TIME,'YYYY-MM-DD HH24:mi:ss') between '2011-01-10 01:26:54' and '2011-01-11 21:00:00';

Index related oracle sql queries

2012-01-09T07:01:00.000-08:00

To create index GLPCA~YG at Database level :

$create index 'GLPCA~YG' on 'GLPCA' ('RCLNT', 'KOKRS', 'RBUKRS', 'RYEAR', 'RPRCTR', 'RACCT', 'POPER') PCTFREE 01 INITRANS 002 TABLESPACE PSAPSR3 STORAGE (INITIAL 000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)
To display all indexes starting with the name GLPCA in database:

$select index_name from dba_indexes where index_name like 'GLPCA%';
To drop index GLPCA~YG1 in database:

$drop index sapsr3."GLPCA~YG1";

sort command in unix

2012-01-02T05:40:00.000-08:00

To find out the biggest file in the directory in descending order

$du -sk * | sort -n

other beautiful command to find in which file the parameter is defined in directory:

$cd /sapmnt/PEP/profile
$grep "DIR_CCMS" *

ccms agent shared memory problems

2012-01-02T04:14:00.000-08:00

During startup of CCMS agent, we were getting the shared memory errors:

$sapccm4x -DCCMS pf=/sapmnt/PEP/profile/PEP_DVEBMGS00_pep0v

INFO: use SAPLOCALHOST ew1app

INFO: CCMS agent sapccmsr working directory is /usr/sap/ccms/EW1_02/sapccmsr

INFO: CCMS agent sapccmsr config file is /usr/sap/ccms/EW1_02/sapccmsr/csmconf
INFO: Central Monitoring System is EW1. (found in config file)
INFO: additional Central Monitoring System is SMS. (found in config file)
INFO: Agent is running (actual pid file is detected)

**********************************************************
Another CCMS Agent is already running with this profile.
**********************************************************

EXITING with code 1

Executing the below command resolved this issue:

sapccm4x -initshm pf=/sapmnt/PEP/profile/PEP_DVEBMGS00_pep0v

when we started again it came up.

Unix command to sort biggest size file in the directory

2011-12-22T20:55:00.000-08:00

$du -sk * | sort -n

How to empty a Unix file system with cat /dev/null command dev null

2011-12-22T20:51:00.000-08:00

First take the backup of existing file :

$cp dev_rd.log /sapcd/XVPdev

then empty the file

$cat /dev/null > dev_rd.log

still it was giving error : File exists.

It meant that noclobber option is set so gave command

$cat /dev/null >! dev_rd.log

and it worked

Removing semaphores shared memory keys with ipcrm

2011-12-08T02:22:00.000-08:00

Sometimes we are not able to remove the shared memory keys with cleanipc 52 remove command, we can find the culprit this way :

ipcs | grep crdadm | awk '{printf("ipcrm -s %s\n", $2);}'

or if we already have the error like that

Dec 8 10:52:08 root@globiz63 logpipe[16010]: (start_app crd0v 52 crdadm 1): OsKey: 25238 0x00006296 Semaphore Key: 38 remove failed **** - errno = 1 (Not owner)

you may find the cultprit by

## ipcs | grep 0x00006296

it will give the ownere as well

now log in as the owner and give the command

## ipcrm -s 687 (687 is the semaphore ID)

it should go now.

Downloading from SAP no options for spreadsheet to choose different formats

2011-11-30T08:19:00.000-08:00

As per our understanding, you need the below dialog box again to select any other format than Excel (in MHTML format) that you have choosen with "Always Use Selected format" checked:

Please follow the below link in order to do that :

http://help.sap.com/saphelp_nw70/helpdata/en/45/6e983a53ad487fe10000000a114a6b/content.htm

We tried on our end and this is working for us.

In our test scanario when we clicked on spreadsheet option it is not showing the other formats and directly taking to the path where to save the file:

In order to get the options again, we chose one of the line items that we need to export :

Now right click on the selected line item and select spreadsheet :

It will ask again for the selection screen with "Always Use selected format" option selected:

Please uncheck the option "Always Use Selected Format" and take the export.

Now next time onwards, it will always show the dialog box showing the formats in which you need to take the exports.

XVP Messaging adapter hung for FTP TIMOUT

2011-11-16T03:02:00.000-08:00

There was a scenario where the Rail Cargo messages stuck in the XVP system and every time we need to take a system restart in order to enable the server to process the messages again.

We checked the communication channel there also the FTP timout was 60 sec. Obviously, the messages stuck due to the FTP Timout but after that the messaging server was not able to process any of the message.

Root cause and work around suggested by David from XI team to set the value of parameter messaging.system.queueParallelism.maxReceivers to 2 for SAP XI AF Messaging and SAP XI AF Core adapters in visual admin.

We checked the value of the same was 2 in server0 but was 0 in server1. Change raised to correct the same in server1

For more information on messaging parameters follow below link:

http://help.sap.com/saphelp_nwpi71/helpdata/en/59/25ee41c334c717e10000000a155106/content.htm

Relevant material :
messaging.system.queueParallelism.maxReceivers
Value type: Integer

Default: 0 (disabled)

This property specifies the maximum number of parallel worker threads per queue, based on the receiver fields of the processed messages. A value of 2, for example, will limit the amount of parallel worker threads for one receiver channel instance to 2, allowing the remaining configured worker threads to process messages for other receiver channel instances of the same adapter type.

DB13 update stats will fail with error

2011-11-10T02:19:00.000-08:00

In this scenario update stats was never successful and failed with error :

BR0301E SQL error -2132 at location thr_db_connect-3, SQL statement:
'ENABLE THREADS'

we checked the brtools permissions in /sapmnt/BIP/exe and they were wrong

SAP Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA provides permissions for brtools, they are as follows :

brarchive, brbackup, and brconnect have permission 4775:
-rwsrwxr-x ora sapsys ...
These can be started by the ora or the adm OS user.

brrestore, brrecover, brspace, brtools, and sapdba have permission 755:
-rwxr-xr-x adm sapsys ...
These should only be started by the ora OS user.

Missing Oracle client on Application Server

2011-11-03T02:25:00.001-07:00

The Scenrio is that one of the application servers of PEQ is not starting. When we checked the database connection it is showing return code 12 with R3trans -d command.

trans.log shows that the version of oracle client can't be ascertained.

we checked the env with env command

and it shows that variable SHLIB_PATH contains value

SHLIB_PATH=/usr/sap/PEQ/SYS/exe/run:/oracle/PEQ/client/11x_64/instantclient

Here in this environment the oracle client is maintained for each SID separately but we verified the physical path of oracle client it is present in /oracle/client/11x_64/instantclient

so we temperarily changed the env to physical path and it worked

$setenv SHLIB_PATH /usr/sap/PEQ/SYS/exe/run:/oracle/client/11x_64/instantclient

$R3trans -d
This is R3trans version 6.22 (release 720 - 02.05.11 - 15:56:00).
unicode enabled version
R3trans finished (0000).

How to unlock any SAP user from Oracle level

2011-10-11T04:36:00.000-07:00

First check the Schema user Id from the below command.

$select username, user_id, account_status from dba_users;

normally the schema user id is sapsr3 or sapr3 (in old versions) or sap(sid)

first display the user using below sql:

$select bname, mandt, UFLAG from sapsr3.usr02 where bname='JSINGH' and mandt=300;

The above query will display the UFLAG value for user JSINGH.
UFLAG value 64 means locked due by administrator and 128 means locked due to incorrect logon attempts. Unlocked user will have UFLAG value set to 0.

Now we will set the UFLAG value of user 'JSINGH' to 0 with below sql command:

$update sapsr3.usr02 set UFLAG=64 where bname='JSINGH' and mandt=300;

$commit;

Now try to login at SAP level, your user has been unlocked :)

File Transfer to OS level from within SAP

2011-10-07T06:00:00.000-07:00

You may transfer file to OS level from within SAP using TCODe CG3Z and CG3Y where in CG3Z is used to transfer file from SAP to OS level and CG3Y is used to transfer file from OS level to SAP (Your own desktop)

Maximum number of Datafiles in Oracle

2011-08-16T08:18:00.000-07:00

Oracle supports maximum 1023 number of data files to be added for extending table space.

Support Pack implementation in Dialog Mode

2011-07-27T16:04:00.001-07:00

SP implementation in Dialog Mode will never time out. It doesn't depend upon the parameter rdisp/max_wprun_time.Even if it runs for 15 hours or more continuously.

start JSPM with changed EPS location

2011-07-27T15:58:00.001-07:00

You may start JSPM with different EPS/in directory than default. There are two methods

1. You may set the parameter DIR_EPS_ROOT in DEFAULT.PFL and point the same to the directory you want.

2. You may start the JSPM with parameter :

./go '-config=/JSPM/inbox=/usr/sap/trans_rep/SPR7/P3'

The JSPM session will start with the current parameter only. It will point to the path given in above parameter and will upload the patches from the same path.

R3trans used for System Refresh activity

2011-07-10T13:09:00.000-07:00

R3tans command can be very handy for System Refresh as we can take export of tables relevant to RFCs, Partner profiles, tRFC ports and distribution models :

command for export

R3trans -w exp.log AE1_export.ctl

example of AE1_export.ctl

export
client=100
file='expAE1100_tables.dmp'
select * from edipoa
select * from edipod
select * from ediport
select * from edp12
select * from edp13
select * from edp21
select * from edpp1
select * from filename
select * from filetext
select * from kcdrm
select * from kcdrs
select * from kcdsm
select * from t462a
select * from tbd00
select * from tbd00t
select * from tbd05
select * from tbd06
select * from tbd30
select * from tbda2
select * from tbdlt
select * from tede2
select * from vari
select * from varid
select * from varit
select * from TBLSYSDEST
select * from TVARVC
select * from CIF_IMOD
select * from TBLSYSDEST
select * from EDPPV
select * from EDPVW
select * from TBDBR
select * from TBDBRF
select * from edpar
select * from edpi1
select * from edmat
select * from edmms
select * from edpo1
select * from edpo3
select * from ediphone
select * from EDPST
select * from EDIPO2
select * from EDIPOACODPAG
select * from EDIPOF
select * from EDIPOI
select * from EDIPOX
select * from EDIPOXH
select * from EDIPOXU

export
file='expAE1_tables.dmp'
select * from crep
select * from crep_http
select * from crepdescr
select * from dbsnp
select * from devaccess
select * from e070l
select * from edbas
select * from edbast
select * from edcim
select * from edcimt
select * from edimsg
select * from edimsgt
select * from edma
select * from edmsg
select * from edview
select * from edviewt
select * from filenameci
select * from filetextci
select * from moni
select * from ndisystems
select * from osmon
select * from pahi
select * from prgn_cust
select * from rslogsysmap
select * from rzllitab
select * from ssf_pse_h
select * from ssf_pse_d
select * from t000
select * from t002
select * from t002t
select * from tbdls
select * from tbdlst
select * from tdevc
select * from tedst
select * from tedtt
select * from toaar
select * from tpfet
select * from tpfht
select * from edipo
select * from crep_rfc
select * from btcomset
select * from STRUSTCERT
select * from STRUSTSSL
select * from STRUSTSSLT
select * from tmsqlastwl
select * from tmsqnotes
select * from tmsqwl
select * from tmsqwlf
select * from HTTPURLLOC
select * from rspor_t_portal
select * from EDPO_QUEUE

export
file='expAE1RFC_tables.dmp'
select * from RFC2SOAPS
select * from RFCADPTATTR
select * from RFCADPTRCVLOG
select * from RFCADPTSNDLOG
select * from RFCATTRIB
select * from RFCCHECK
select * from RFCCMC
select * from RFCDES
select * from RFCDESSECU
select * from RFCGO
select * from RFCLIST
select * from RFCSTXTAB
select * from RFCSYSACL
select * from RFCTRUST
select * from RFCTSTLOG
select * from RFCTSTTAB
select * from RFCTYPE
select * from RFCTA
select * from RFCDOC

After system refresh, we need to import the above exported tables. While importing we need to reverse the process :

command

R3trans -w imp.log AE1_import.ctl

example of AE1_import.ctl

remove
client=100
select * from edipoa
select * from edipod
select * from ediport
select * from edp12
select * from edp13
select * from edp21
select * from edpp1
select * from filename
select * from filetext
select * from kcdrm
select * from kcdrs
select * from kcdsm
select * from t462a
select * from tbd00
select * from tbd00t
select * from tbd05
select * from tbd06
select * from tbd30
select * from tbda2
select * from tbdlt
select * from tede2
select * from vari
select * from varid
select * from varit
select * from TBLSYSDEST
select * from TVARVC
select * from CIF_IMOD
select * from TBLSYSDEST
select * from EDPPV
select * from EDPVW
select * from TBDBR
select * from TBDBRF
select * from edpar
select * from edpi1
select * from edmat
select * from edmms
select * from edpo1
select * from edpo3
select * from ediphone
select * from EDPST
select * from EDIPO2
select * from EDIPOACODPAG
select * from EDIPOF
select * from EDIPOI
select * from EDIPOX
select * from EDIPOXH
select * from EDIPOXU

import
client=100
file='expAE1100_tables.dmp'

remove
select * from crep
select * from crep_http
select * from crepdescr
select * from dbsnp
select * from devaccess
select * from e070l
select * from edbas
select * from edbast
select * from edcim
select * from edcimt
select * from edimsg
select * from edimsgt
select * from edma
select * from edmsg
select * from edview
select * from edviewt
select * from filenameci
select * from filetextci
select * from moni
select * from ndisystems
select * from osmon
select * from pahi
select * from prgn_cust
select * from rslogsysmap
select * from rzllitab
select * from ssf_pse_h
select * from ssf_pse_d
select * from t000
select * from t002
select * from t002t
select * from tbdls
select * from tbdlst
select * from tdevc
select * from tedst
select * from tedtt
select * from toaar
select * from tpfet
select * from tpfht
select * from edipo
select * from crep_rfc
select * from btcomset
select * from STRUSTCERT
select * from STRUSTSSL
select * from STRUSTSSLT
select * from tmsqlastwl
select * from tmsqnotes
select * from tmsqwl
select * from tmsqwlf
select * from HTTPURLLOC
select * from rspor_t_portal
select * from EDPO_QUEUE

import
file='expAE1_tables.dmp'

remove
select * from RFC2SOAPS
select * from RFCADPTATTR
select * from RFCADPTRCVLOG
select * from RFCADPTSNDLOG
select * from RFCATTRIB
select * from RFCCHECK
select * from RFCCMC
select * from RFCDES
select * from RFCDESSECU
select * from RFCGO
select * from RFCLIST
select * from RFCSTXTAB
select * from RFCSYSACL
select * from RFCTRUST
select * from RFCTSTLOG
select * from RFCTSTTAB
select * from RFCTYPE
select * from RFCTA
select * from RFCDOC

import
file='expAE1RFC_tables.dmp'

Table export import with R3trans directly from OS level

2011-07-10T12:55:00.000-07:00

For exporting the tables:

command :

R3trans -w exp.log exp.ctl

example of exp.ctl:

export

client = 200

file = '/usr/sap/trans/data/export.dat'

select * from COEP

select * from BSIS
select * from ACCTCR
select * from COEP
select * from BALDAT
select * from MLIT
select * from MLPP
select * from MSEG
select * from MSTA
select * from NAST

select * from ONR0

select * from S033

select * from S700
select * from FAGLFLEXA
select * from CKIS
select * from KEKO

For importing the same table(s)

command :

R3trans -w imp.log imp.ctl

example of imp.ctl file :

import

file = '/usr/sap/trans/data/export.dat'

client = 200

Problems faced in Language Installation

2011-07-02T00:21:00.000-07:00

There are 3 major parts of Language Installation

1) First Import the Language Package in 000 SMLT

2) Import the language part of all old Support packages in 000 client

3) Supplement the language in each client

We majorly faced the problem in step 2, where first we searched the location for all old support packages with

find . | grep "KGPHD*"

command

Secondly, as we were using A port, we started the import of language part of support package and logged off, this happens only in Dialog :) so the R3trans will work as the control is with SMLT import language part of support packages. This is not the case when we import the language "Import package" because it will show that the control has been transferred to R3trans in Action log.

Another issue we faced, there was import issue return code (16) while doing Import of language part of support package SAPK-603DFINSAPAPPL, actually this support package didn't exist in the system, this is a sub support package, we can find this using SE16 table PAT13:

the solution was in below link :

http://forums.sdn.sap.com/thread.jspa?threadID=1881224

quoting the solution:

"please check table PAT13 in SE16; you'll see that these packages are listed in column SEC_NAME. Please refer to the main package that it belongs to on the PATCH column - this is the main package file that you should look for in SAP MarketPlace and unpack in EPS/in. Then you can repeat the process, it'll find the missing Meta-Commandfiles and continue w/o problems.

By the way, please check note #1508122, it might be that you have the incorrect language package installed on your system. This note explain in details how to check and install the correct language package on your system."

Use find command in Unix to find the required files

2011-07-01T10:43:00.000-07:00

During language installation, one of the step is "Importing of Language part of support packages after language installation".

It requires all the old support packages to be present in EPS/in (default) directory. But there were many support packages missing. Downloading was not the option as it required approval from Solution Manager and we don't have access for the same.

So, the only option left was to search where is the location of the missing support packages not present in /usr/sap/trans/EPS/in directory. Actually we were looking for CAR files.

The command that came handy was

find . | grep "KGPHD*"

we were in location /usr/sap/trans/EPS and we gave this command

ultimately we were able to locate the missing support packages in directory /usr/sap/trans/EPS/languages_stack_01_17

How to find job name from process ID (BI System Slow Analysis)

2011-06-22T13:51:00.000-07:00

We used this scenario in term of BI system being slow :

Analysis steps :

1) Go to DB01 and find if there are any exclusive locks i.e. in HOLD _WAIT status

2) If yes find out the process ID and application server name of the locks in HOLD status.

3) Log on to the application server on which the process in Hold status is found and goto SM66

4) Find out the process ID against BTC and double click

5) Click on Job Information, it will give you the job name, you may find this on another application server as well but you need to enable below settings :

"For background processes, additional information is available for the background job that is currently running. You can only display this information, if you are logged onto the instance where the job is running, or if you choose Settings and deselect Display only abbreviated information, avoid RFC. In any case, the job must still be running".

For more information on this please goto below link:

http://help.sap.com/saphelp_nw70/helpdata/en/c4/3a6a6a505211d189550000e829fbbd/content.htm

6) Once you have found the job, you may give it to BI guys to relate the same to the Process Chain and kill the job / cancel the process chain.

Kernel upgrade procedure - Traditional Method

2011-06-18T04:28:00.001-07:00

(Please note that this is not the recommended method as this involved exchanging of kernel directories which may omit many other dependant files. The best way to avoid any inconsistency is to overwrite the old kernel directory by extracting new kernel binaries in the same directory).

Step I : Make directory /sapmnt/(SID)/exenew with full permissions

Step II: Extract the following files in the newly created directory

SAPEXE
SAPEXEDB
DBATL

Step III: Change premissions for these three type of files in exenew

$Chown ora(SID):dba br*
$Chown root:sapsys saposcol
$Chown root:sapsys icmbnd

*all other files should be (sid)adm:sapsys

Step IV: Stop sap and saposcol

(sid)adm : stopsap
saposcol -k

Step V: Interchange the kernel directories

$ mv sapmnt/(SID)/exe exeold
$ mv sapmnt/(SID)/exenew exe

Step VI : Execute the following script as a root user

cd /sapmnt/(SID)/exe
./saproot.sh (SID)

Step VII: Start SAP

(sid)adm : startsap

Step VIII: run the following scripts as oracle user

su - ora(sid)
cd /sapmnt/(sid)/exe

now run the scripts from here only

sqlplus /nolog @sapdba_role (SID)
sqlplus /nolog @sapconn_role (SID)

after executing the scripts check the log files

Step IX: Log in as (sid)adm user and check R3trans

$R3trans -d

It should give return code (0000)

Now login in the system goto System -> status and check the kernel patch level.

Kernel Upgrade Procedure - Simplest

2011-06-18T04:22:00.000-07:00

Steps :- for 701 systems
1. cd /usr/sap/common/exe
2. ./OperInfo.ksh down "SR 2298151 Kernel Upgrade"
3. vis_stopsap r3
4. Login with adm
5. saposcol –k
6. cd /sapmnt/
7. cp -R exe exe
8. cd exe
9. cp -R /usr/sap/trans/SPR5/KERNEL_701_69/R5_Kernel_Extracted/* .

Steps :- For 700 Systems(*M2 and *S1 systems)
1. cd /usr/sap/common/exe
2. ./OperInfo.ksh down "CRQ 92360 Kernel Upgrade"
3. vis_stopsap r3
4. Login with adm
5. saposcol –k
6. cd /sapmnt/
7. cp -R exe exe
8. cd exe
9. cp -R /usr/sap/trans/SPR5/S1KRNL/R5_700_Kernel/* .

Steps for changing the kernel files permission to root (in all systems)
1. login as root user
2. cd /sapmnt//exe
3. ./saproot.sh

Steps:- Checking new kernel (in all systems)
1. Login as adm
2. cd /sapmnt//exe
3. disp+work (Take Screenshot of this Screen)

Please check and validate backint permission
1.cd /opt/networker/bin
2. ls -l | grep backint and check permission of listed files
lrwxr-x--- root sys backint --> backint_hpux11_ia64_LGTsc19983_LGTsc28795_3.0.2
-rwsr-xr-x root sys backint_hpux11_ia64_LGTsc19983_LGTsc28795_3.0.2

3. if sticky bit is missing for backint_hpux11_ia64_LGTsc19983_LGTsc28795_3.0.2 run below command with root access

chmod 4755 backint_hpux11_ia64_LGTsc19983_LGTsc28795_3.0.2

Mass rename script in Unix (HP-UX)

2011-06-17T23:46:00.000-07:00

(#!/bin/ksh) - remove the brackets in real scenario

cd /oracle/GE1/saparch
for file in *arch*; do

newfile=`echo $file | sed 's/ZE1/GE1/'`
mv $file $newfile

done

Mass copy script in HP-UX Unix

2011-06-17T23:37:00.000-07:00

(#! /bin/ksh) - remove brackets in real scenario

cd /usr/sap/ZE1/EXT/M100/D2DWHP/out/MDT

for file in *ZORDERHIS*;do

mv $file /usr/sap/trans_rep/IBM_Transfer/DE0198_interface_files_MM

echo $file 'moved'

done

How to change some character in mass in vi editor

2011-06-17T23:27:00.000-07:00

:%s/^M//g

In above example %s means search for character ^M and replace it with nothing / g for globally

Or if you need to change the same with some other character say ^M with ^S then

:%s/^M/^S/g

Remedy query to find out last resolved requests

2011-06-12T08:38:00.000-07:00

Log on to the Remedy tool, Choose resolved in the category after giving till Solution Manager in Assignee :

click on Advance and fill in the below query

'Last Resolved Date ' >= "22/05/2011 00:00:00" AND 'Last Name*+' != "HP_OVO_Ratingen"

Here you may give in any date from that date onwards all the Resolved Incidents in Solution Manager group excluding the Alerts ('Last Name*+' != "HP_OVO_Ratinge")

NWDI Change Management Service - Transports

2011-06-12T08:35:00.000-07:00

This one is related to Track management. You may import / Assemble SCs (containing many DCs) in your track.

First thing to log on to the NWDI CMS

http://avggstah.dc-ratingen.de:51000/devinf/main

then choose the Change Management Service

Choose the track that you may want to do the changes and import / Assemble as per requirement

Parallel processes for Client Copy

2011-06-02T15:16:00.001-07:00

Option for selecting the number of Parallel Process for Client Copy is available in SCC9, you may go to manu option Goto ---) Parallel Processes.

Here you will get options :

Maximum Number of Processes : 35

Logon/Server Group : parallel_generators

Command to Rebuild Indexes

2011-06-01T12:02:00.000-07:00

We used the following command to rebuild the indexes in ZE1 System :

brspace -f idrebuild -i (index_list)

For eg :

brspace -f idrebuild -i /COCKPIT/THDRV~DEL

behind the scenes, it is using the below sql command :

sql) alter index "SAPEVO", "/COCKPIT/THDRV~DEL" rebuild online;

in generic terms

alter index "(schemaname)", "(indexname)" rebuild online;

Temp file movement in Oracle database

2011-05-31T15:45:00.000-07:00

ZB1 System was frequently facing ORA-01114

ORA-01114:
IO error writing block to file string (block # string)

Cause: The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.

and ORA-12805: parallel query server died unexpectedly, errors frequently. So it was decided to move temp files to separate mount point. It included moving temp files from different locations to separate mount point only dedicated for temp files:

Please find the steps for the same :

Check whether listner is down Or Down Listener First

Take Name and open mode of database
SQL ) Select name,open_mode from v$database;

Take screen shot of location + status of tempfile

SQL ) set pagesize 0
SQL ) spool filetemp.txt
SQL ) select TS#,NAME,STATUS from v$tempfile;
SQL ) spool off

Now shut down the database and copy the files to new location

sqlplus / as sysdba
shutdown immediate

Note :: During shutdown of the database it hung for about 45-50 minutes, checked alert file nothing was happening, killed the ora_lgwr process with "kill -9" command then started the database with "startup" and then "shutdown immediate" it was smooth then started copying the files.

copy files from existing location to new mount point :

cp -pr /oracle/ZB1/sapdata1/temp_1/temp.data1 /oracle/ZB1/sapdata_temp1/temp_1 cp -pr /oracle/ZB1/sapdata8/temp_2/temp.data2 oracle/ZB1/sapdata_temp1/temp_2
cp -pr /oracle/ZB1/sapdata8/temp_3/temp.data3 oracle/ZB1/sapdata_temp1/temp_3

SQL ) startup mount

SQL ) alter database rename file '/oracle/ZB1/sapdata1/temp_1/temp.data1' to '/oracle/ZB1/sapdata_temp1/temp_1/temp.data1';
SQL ) alter database rename file '/oracle/ZB1/sapdata8/temp_2/temp.data2' to '/oracle/ZB1/sapdata_temp1/temp_2/temp.data2';
SQL ) alter database rename file '/oracle/ZB1/sapdata8/temp_3/temp.data3' to '/oracle/ZB1/sapdata_temp1/temp_3/temp.data3';

SQL ) alter database open;

Check the current status of updated temp files
SQL ) select TS#,NAME,STATUS from v$tempfile;

Query to ascertain database size

2011-05-27T23:22:00.000-07:00

select (select sum(bytes)/1024/1024 from dba_data_files)+ (select sum(bytes)/1024/1024 from dba_temp_files) "Size in MB" from dual;

Table Reorg - Pre-requisites

2011-05-01T23:43:00.000-07:00

1. No backup should be running in the system

select * from v$backup.

2. No archiving job should be running in the system, check from SM37

3. The size of oraarch (saparch) - should be free at least to the size of Table to be reorganized. Normally 30-40 GB free

4. Size of Table space PSAPSR3 should by 120% of the size of table to be reorganized.

5. Run the stats and check the table size before and after Reorg.

Table Reorg - How to do - commands

2011-05-01T23:26:00.000-07:00

1. archive destination (sufficient space) - 20GB - 22GB (screen shot)
bdf | grep saparch (SID)

2. Tablespace PSAPEVO - object - SPACE should be same as table size - (20%). (screen shot)

select tsu.tablespace_name, ceil(tsu.used_mb) "size MB"
, decode(ceil(tsf.free_mb), NULL,0,ceil(tsf.free_mb)) "free MB"
, decode(100 - ceil(tsf.free_mb/tsu.used_mb*100), NULL, 100,
100 - ceil(tsf.free_mb/tsu.used_mb*100)) "% used"
from (select tablespace_name, sum(bytes)/1024/1024 used_mb
from dba_data_files group by tablespace_name union all
select tablespace_name
, sum(bytes_used + bytes_free)/1024/1024 used_mb
from v$temp_space_header group by tablespace_name) tsu
, (select tablespace_name, sum(bytes)/1024/1024 free_mb
from dba_free_space group by tablespace_name union all
select tablespace_name,sum(bytes_free)/1024/1024 free_mb from v$temp_space_header group by tablespace_name ) tsf
where tsu.tablespace_name = tsf.tablespace_name (+)
order by 4;

3. Collect table statistics

brconnect -c -u / -f stats -t /BIC/B0000032000 -f collect -p 2

4. Checking TOP 20 Fregmented tables.

SELECT * FROM
(SELECT
SUBSTR(TABLE_NAME, 1, 21) TABLE_NAME,
NUM_ROWS,
AVG_ROW_LEN ROWLEN,
BLOCKS,
ROUND((AVG_ROW_LEN + 1) * NUM_ROWS / 1000000, 0) NET_MB,
ROUND(BLOCKS * (8000 - 23 * INI_TRANS) *
(1 - PCT_FREE / 100) / 1000000, 0) GROSS_MB,
ROUND((BLOCKS * (8000 - 23 * INI_TRANS) * (1 - PCT_FREE /
100) -
(AVG_ROW_LEN + 1) * NUM_ROWS) / 1000000) "WASTED_MB"
FROM DBA_TABLES
WHERE
NUM_ROWS IS NOT NULL AND
OWNER LIKE 'SAP%' AND
PARTITIONED = 'NO' AND Table_name in ('/BIC/B0000034000
','/BIC/B0000582000',
',
(IOT_TYPE != 'IOT' OR IOT_TYPE IS NULL)
ORDER BY 7 DESC)
WHERE ROWNUM <=20;

5. Getting Table & DB size

select sum(bytes)/1024/1024/1024 from dba_segments;

select sum(bytes)/1024/1024/1024 from dba_segments where segment_name='';
select sum(bytes)/1024 from dba_segments where segment_name='

';

6. Reorg Table

brspace -u / -f tbreorg -t

7. brconnect -c -u / -f stats -t EDI40 -f collect -p 2
z

8. Getting Table & DB size

select sum(bytes)/1024/1024/1024 from dba_segments;
select sum(bytes)/1024/1024/1024 from dba_segments where segment_name='

Transaction to check ZR2 (Recruitment) System connectivity to TREX (Search Engine) // SRMO

2011-03-28T07:28:00.000-07:00

SRMO - It will show the RFC connection from ZR2 to TREX is working or not.

E071 // Details about the transports done in the system

2011-02-25T06:20:00.000-08:00

To check the status of transports, we can there is one table E071 where we can check the details of transports imported in the system.

Tuning Oracle DB Parameters - Steps to follow

2011-02-16T19:18:00.000-08:00

First we can check the existing parmaters with following commands:

$show sga

$show parameter shared_pool;

$show parameter sga_max_size;

$show parameter db_cache_size;

Then take backup for pfile and spfile (initSID.ora and spfileSID.ora)

/oracle/SID/102_64/dbs

$create pfile from spfile

then edit pfile with the parameters that are recommended

start database with changed pfile

$startup pfile='/oracle/SID/102_64/dbs/initSID.ora'

check the parameters

if they are correct then

$create spfile from pfile

then shutdown and restart the database

$shutdown immediate
$startup

//Issue faced
while restarting database listener not found

$tnsping SID

gave error for resolving name

resolution

setenv TNS_ADMIN /oracle/SID/102_64/network/admin

later on added the same in .dbenv.csh and .dbenv_avggstqh.csh to make the same permanent.

//we can dynamically set the parameters in spfile online but this is not recommended as Oracle needs to adjust the parameters as well.

$alter system set shared_pool_size=400M scope=spfile;

How to find out UID and GID for HP-UX users

2011-02-16T03:20:00.001-08:00

HP-UX command

$id oraeb3

$id dn1adm

HP-UX command for looking at memory with Graphics

2011-02-14T07:04:00.000-08:00

glance | gpm

Excellent Unix Commands for finding and replacing in vi and file system

2011-02-08T22:40:00.000-08:00

If you want to find something

$ find . | xargs grep "string"

It will find all the files recursively and then display the strings

vi commands (advanced)

Go to / Replace functionality can be used in vi... like this

:%s/stringtobereplaced/stringwithwhichtoreplace/g

(Esc + colen (:) + percentage (%) s /string1/string2/g

for eg:

:%s/avggstdh/avggstrh/g

will replace all the occurences of avggstdh with avggstrh.

BRCONNECT command for collecting stats for all tables

2011-02-04T20:54:00.000-08:00

brconnect -c -u / -f stats -t all -f collect -p 4

Listener Issues - TNS_ADMIN parameter

2011-02-03T04:26:00.000-08:00

If you face listener Issues make sure that TNS_ADMIN parameter is set in your DB environment

setenv TNS_ADMIN /oracle/SID/102_64/network/admin

also you may use

tnsping SID to test (It should be running) (Your listener should be up)

We faced the situation when we were using dbua for upgrading oracle. DBUA uses tnsping, also tnsnames.ora should be set correctly

Setting parameters in Oracle - New way

2011-02-03T04:20:00.000-08:00

We may set the parameters in oracle with Alter command as well. We need not set the parameter in pfile and then create pfile. Easy way

How to free MDM Port

2011-02-03T04:16:00.000-08:00

Our MDM Server uses port 20005 and if it is busy it wont start, it means some other application is waiting for the port.

we find out by this command

netstat -a | grep 20005

if it gives FINWAIT_1 then it is OK it will get free in some time, but if it gives FINWAIT_2 then we need to free the same manually

After analysis we found the destination host where three EP server are hosted EP1, EP2 and EP3

we logged on to each one and found which process is looking keeping busy port 20005, with below command

lsof -i | 20005

on EP3 we found the process

killed the process by kill -9 pid

Now the port became free :)

Host Movement - Profile Dependencies ABAP

2011-01-27T22:12:00.000-08:00

Following profiles need to be changed for ABAP Host Movement and for Java apart from profile changes there need to be changes in configtool as per SAP Note 757692.

How to check what users have FF Access

2010-12-03T16:48:00.001-08:00

1. Go to SE16
2. Give Table Name /VIRSA/ZFFUSERS
3. See the contents, it will tell what all users have FF IDs.

BI Dataload - Users that needn't be locked

2010-12-03T15:08:00.001-08:00

DDIC
RFC*
EBY*
MDBTC
REDWOOD
BW*
PI*
NWDI*
*ADMIN*
j2ee_admin
wf-batch
tmsadm
FF_*

Defining ABAP ALV export format for spreadsheet

2010-10-12T15:20:00.000-07:00

Users sometimes cannot export the data from SAP to spreadsheet in prescribed format, for eg. they are only able to see (MHTML)format while exporting to excel.

There is SAP Note 1080608 for the same. Also please find the below link for more details:

http://help.sap.com/saphelp_nw04/helpdata/en/66/79ad48157f11d2953700a0c930328a/content.htm

Sample process managing SAP environment

2010-10-11T14:29:00.000-07:00

Please find below the Sample Process to manage SAP environment based on metrics and SLAs

Landscape

Project - Where implementation is taking place

BAU - Business As Usual (where actual Business is running)

The Project landscape has each and every system with integration that exists in BAU landscape.

Now all the developments that are done in Project are moved to BAU environment say in every 4-5 months, it is known as Cutover or Release 2/3/4/5 etc. Each release is for some new country or geographical area.

Now if the change has to be moved in BAU, there is a procedure that needs to be followed : (Eg. applying SAP notes)

1) There should be a change request (CRQ) created by the functional people that are facing the issue.

2) The transport requests are based on the above CRQ

3) Then there will be a developer designated who will implement that change say apply SAP note may be BASIS / ABAP against the transport request given above, they will fill in the checklist what action they will be performing. the checklist will contain the tester as well who will test the functionality after the note has been implemented in the system.

4) After applying notes, the developer will release the task of transport request not the transport request.

5) There will be a Change Advisory Board (CAB) who will approve the request till applying in Dev system the CRQ will be in draft mode, before implementing in test environment there should be RFA (Request for approval) for CAB and then after it gets approved and tested the same can be applied in production not before.

Please note in above scenario there is immense traceability on who has done what based on some ticket number which has all the documentation. The above scenario is fruitful in the scenarios where multiple 3rd party vendors are working in the same environment.

ZE3 ICM not coming up

2010-10-01T23:29:00.000-07:00

There was a application server redesign activity last week where in we were involved in shutting down some application servers in backend /communication zones and changing parameters as per SAP TPO recommendations. But the issue came in where half of the processes in SM50 were showing in running status and other were in stopped status, when we reverted back the values of rdisp/wp_no_dia and btc it came again with correct status.

The logs were showing the database errors, we tried to connect to database and it showed connected to an idle instance even though the SAP system was working.

It immediately striked to us that database is not accepting more connections, we checked the value of V$session variable using following query;

The number of sessions the database was configured to allow

Select name, value from v$parameter WHERE name = 'sessions';

The number of sessions currently active

Select COUNT(*) from v$session;

for more info follow the below link
http://stackoverflow.com/questions/162255/how-to-check-the-maximum-number-of-allowed-connections-to-an-oracle-database

Though the connections were increased but still Business wanted justification on what basis the connections were increased.

We checked the ICM connection in SMICM in one of the instances was showing RED, we reverted the settings and it came up again, because of that the Adobe services and all JCo connections failed.

T77UU table for structural Authorization

2010-10-01T23:20:00.001-07:00

Again we faced the issue, where all the OpCos were getting smoother response times from ESS in portal but only the newer ones (VGS) were not able to get the good response times when the employees checked there salaries /personal info/Bank Info from portal (29 secs) on an average.

First line of investigation was with BASIS Team only where we need to check the response times in Portal but we need WILY access for the same but indeed we checked from our side the CPU/Memory utilization for all application servers and we involved the Proxy Team as well to check the times.

We checked VAdmin Performance Tuning to check the stats but it was somewhere between 8ms -800ms not more than that.

Finally we did the trace of users getting the issue in ST05 (SQL and RFC trace) and sent the same to implementation partner for analysis. SAP also analyzed the same and came to conclusion that the client needs to maintain structural authorization data in table T77UU and T77PR.

This is the second post where structural Authorization again came to forefront in terms of issue resolution

MM IDocs got stuck

2010-09-23T21:23:00.000-07:00

It was related to MM team the IDocs got stuck and even by manually processing the IDocs in background with program RBDAPP01, it was getting hung ( the job was running for infinite time.

We were checking the Idocs in transaction WE02 and putting 64 (Idocs ready to be processed) in "Current Status" and Message Type in "Logical Message", but the numbers were not reducing.

Upon Analysis, we came to know that there was a long running process on application server avggsqeh by user 10501828 which was indirectly holding a table lock on NRIV table.

How we got the clue ?

In t-code DB01 there were entries like HOLD and __WAIT, the application server which was holding the lock was avggsqeh but it was not relevant to our activity,"Linked Locks" button but it was showing up time and again when we clicked on anyhow we logged on to the application server and saw that there was a long running process there and we killed that after that everthing went on fine.

UID error while adding dialogue instance

2010-08-22T23:04:00.000-07:00

Hi,

Last night we had an issue with this server where we were adding application servers as dialogue instances and it was throwing us the errors, viz changue uid of the user zb5adm as it doesn't match with zb1adm.

As on single host there were many installations we were trying to figure out the relationship between zb5adm and zb1adm..at last we figured out that someone has compied profiles from zb1 to zb5 in /sapmnt/ZB5/profile directory and system was confused to read multiple profiles in one profile directory.

At the OS level the SAP application can only see uid and not the usernames, so issue was resolved by removing the redundant ZB1 profiles from /sapmnt/ZB5/profile directory.

SAPJSF user locked for UME connection

2010-08-06T08:08:00.001-07:00

The scenarion is that the user SAPJSF got locked in ABAP stack of PI ZX2, the reason being UME Tech Team changed password of that user, now in configtool the ume.master.password is configured with SAPJSF user earlier old password so it got locked.

Secondly ZX2 system has eight application servers, even after changing the password in Global configuration of configtool the SAPJSF user is getting locked in backend ABAP stack, guess what, all the RFC of local server nodes are configured with SAPJSF user old password.

Resolution

First we configured the configtool of Global configuration in CI with RFC_USER so that we can run the visual admin because visual admin will not respond because of locked SAPJSF user, secondly we logged on to each application server node "RFC Provider " service to change the password of SAPJSF user as the RFC are configured for each local node and cannot be configured globally.

Easy way to list out software components of System

2010-08-02T10:22:00.000-07:00

Goto SE16
put in CVERS table name and list out its components, it will give you the software component versions at one go in table form, much more visible than going to system and then status.

PA20 and PA30 tcode execution is very slow

2010-07-29T03:16:00.000-07:00

There was an issue in our Project some users were facing extraordinarily long response times while using transactions PA20 and PA30, the resolution was as follows:

Do you happen to have structural authorization implemented ? If yes, this can cause performance issue when doing authrorization checking. To resolve this (only if you have struct auth implemented) , the user id would need to be added in T77UU, and SAP utility to re-generate index for structural auth (RHBAUS00) to be run after .

Source : https://forums.sdn.sap.com/thread.jspa?threadID=1458192

Oracle Schema User Locked in trans.log ORA-28000

2010-07-20T17:27:00.001-07:00

951167- ORA-28000: the account is locked

Problem
You cannot log on to the Oracle database and the program returns the message:

ORA-28000: the account is locked

Reason and Prerequisites

ORA-28000 is usually triggered because someone has previously attempted to log on several times using an incorrect password, which causes the logon to fail and returns ORA-01017. The number of allowed logon attempts is defined by the resource FAILED_LOGIN_ATTEMPTS in the profile. You can determine the current value of this parameter using the following query:

SELECT LIMIT FROM DBA_PROFILES
WHERE
PROFILE = 'DEFAULT' AND
RESOURCE_NAME = 'FAILED_LOGIN_ATTEMPTS';

Until Oracle 10.1, this parameter had the default value UNLIMITED, so that no ORA-28000 messages would normally occur. As of Oracle 10.2, this standard value has been set to 10.

A further option in the case of a locked user is an explicit lock as follows:

ALTER USER ACCOUNT LOCK;

Solution

To prevent ORA-28000 errors, and avoid similar problems in future, be aware of the following:

If you use Oracle 9i or earlier, do not manually restrict the authorizations of the default profile (also refer to Note 700548 (16)).
If FAILED_LOGIN_ATTEMPTS is not set to UNLIMITED, you can adjust it as follows:

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
This is also possible for Oracle 10. 1 and earlier and Oracle 10.2 and later.

If a user is already locked, you can unlock it as follows:

ALTER USER ACCOUNT UNLOCK;
If the ORA-28000 error occurred due to a large number of failed logon attempts, you must check why these logon attempts were unsuccessful and returned the ORA-01017 error. The cause is often an incorrect configuration of the OPS$ mechanism. In this case, refer to Note 400241.

Why is it necessary to delete the tables ALCONSEG, ALSYSTEMS, DBSNP, MONI, OSMON, PAHI, SDBAD, SDBAP, SDBAR, TPFET, and TPHFT in an SAP System Refresh

2010-07-19T18:26:00.000-07:00

Those tables contain information specific to the source system. On the target system this piece of information will be misleading or wrong.

Tables SDBAD, SDBAP, SDBAR are about backup history. Backups of the source system won't tell you anything about backups of the target system.

TPFET and TPHFT are about SAP instance profiles. You can't keep profiles of the source system; you will have to create new ones for the target system anyway.

Below tables:

SDBAP = SAP DBA Plan Table
SDBAR = SDBA Resource Table
SDBAH = Header table for DBA protocols
SDBAD = Detail table for DBA protocols

belong to sapdba. They contain the log information of the logs that
sapdba and BrBackup and BrArchive write. The sapdba -cleanup function
will enable you to delete the entries from the db-tables, as well as the
respective files in the operating system.

The tables
MONI = Monitor table
PAHI = History of OS system, DB and SAP parameters
ALAMO = Collector of alert events
OSMON = Operating system monitor data
DBSNP = Table for DB snapshots

contain statistical data tha can be displayed in transaction st04. They
can partially be deleted from within the R/3-System following
st04->Monitor->Performance->Database

Tables:
ALSYSTEMS:CCMS Central System Management: Remote Managed Systems

As they contain information related to that source system and will be misleading if copied to target system.

They can partially be deleted from within the R/3-System following
st04->Monitor->Performance->Database

If not work, you can truncate these tables with sqlplus.

sqlplus sapr3/sap
truncate table ;

There is another option to delete all the data with SE14, using database
utility.

Source : https://forums.sdn.sap.com/thread.jspa?threadID=1204044

Disconnecting System from CUA

2010-07-15T21:42:00.000-07:00

Log on to the CUA central system for eg DE2 050 or EE2 050 and then run the report in SE38

RSDELCUA

then choose the system that you need to disconnect and then resynchronize.

GRC Java System Info has different link

2010-07-13T00:59:00.000-07:00

When clicked on System Info link for SAP GRC 5.3 system (AS JAVA) took us to the below standard link :
http://server:port/monitoring/SystemInfo
but it gave us the below error :
Requested Resource [/SystemInfo] not found.
changed the above link to the following and it worked
http://server:port/sap/monitoring/SystemInfo

SAP Note 1086644 Pcd clean Inconsistencies in Portal

2010-07-11T23:54:00.000-07:00

We can run PcdToolCheck.sh to check and clean Pcd Inconsistencies.

Gyan Session on MDM

2010-07-08T09:45:00.001-07:00

The primary function of MDM includes:
Master Data Consolidation
- cleansing and de-duplication
- Data normalization including categorization and taxonomy mgt
- New interactive consolidation capabilities

T-Code to upload data in MDM through ECC MDMGX
There is a Ready folder that acts as a source for data staging

There are three important modules:

CI - MDS
App Server - Import Server - for input to MDM
App Server - Syndicate Server - for sending out data from MDM

The analogy for CI and App is only for shutting down and startup.

Operation Mode Simulation Errors

2010-07-07T07:01:00.000-07:00

Sometimes the Operation Mode switching is not consistent. The number of Work processes shown in the RZ04 doesn't match with the actual work processes. Please follow the same to correct it :

Goto RZ03 -) Control -) Switch Operation Mode -) Simulation
If it is giving errors then you need to fix the same

Goto RZ04 -) Double click on any operation Mode -) Goto Settings -) Based on current status -) Existing Instances -) Set

now check the above step of RZ03 it should be green now and now you may actually switch operation modes in RZ03 Control tab and the WPs should match now.

Time Table TCode SM63

IDoc monitoring and manual Parallel Processing

2010-07-03T18:53:00.000-07:00

We can monitor IDocs using T-code WE05
In current status put 64 (IDocs ready to be transferred to an application)
There you may see the IDocs with large segments that are stuck, make a note of their numbers
Go to SA38 and execute the program RBDAPP01
Give the IDoc number only and click on Program -) execute in background and select immediate
You may run many jobs parallely for the same when the job finishes it means the IDoc is processed.

Database Shutdown Process - Oracle

2010-07-03T18:31:00.000-07:00

1. Connect to O/S (UNIX) using ora(SID)
2. Connect database #sqlplus "/as sysdba"
3. Check database name and database open mode
SQL) select name, open_mode from v$database;
4. Check database backup status using following command
SQL) select * from v$backup;
If status in not active then you may shutdown database using command
SQL) shutdown immediate
If status is active state then first cancel backup using command
SQL) alter database end backup;
after successful execution of this command database can be shutdown using command
SQL ) shutdown immediate;

5. Check any backint process in O/S level using command
$ps -ef grep backint grep ora(SID)
6. If there exists any process kill using following command
#kill -9 (PID)

Register a program locally with rfcexec

2010-06-30T16:15:00.000-07:00

Earlier when we tested the RFC with external Ferrari (FAX) server it failed but when we registered the same RFC locally on central ZE1 server the RFC started working the command we used was as follows:

rfcexec -aZE1.100.ferrari -gR3-ZE1 -xsapgw01 &

here rfcexec is a program to register rfc

ZE1.100.ferrari is the name of RFC connection

R3-ZE1 is the hostname where we are registering the RFC program

sapgw01 is the name of the gateway

& the program is running in background

Send Mail through UNIX HP-UX

2010-06-30T16:10:00.000-07:00

For sending mail through HP-UX please use the following command

#uuencode (filename) (filename) | mailx -s "subject" (email ID)

eg:

#uuencode FBISacc1 FBISacc1 | mailx -s "Filesend" manaskv@in.ibm.com

Additionally we can zip and unzip files in HP-UX with below commands:

#zip (zipfilename) (original filename)

#uzip (zipfilename)

Netstat to find out if the port is open or closed

2010-06-12T17:00:00.000-07:00

You may use the below command to find if the port is open or closed on a UNIX system:
-) netstat -a grep PID
if the porcess says CLOSE_WAIT, it means that the port is blocked.

Shared memory error in java

2010-06-04T09:19:00.000-07:00

If Java engine doesn't start and there is shared memory error and the java logs says that ORA-28000 Account is locked, then check by command desc dba_users and fire query
-) select username, account_status from dba_users;

to find out the status for sapsr3db user; If it is locked then unlock the same with command;
-) Alter user sapsr3db account unlock; ( Here sapsr3db is for Java alternatively sapsr3 will be for ABAP)
After the same gets unlocked there is a SAP Note 951167- ORA-28000; the account is locked you can prevent the same from unlocking again;
To check FAILED_LOGIN_ATTEMPTS profile ;

Select limit from dba_profiles where profile='DEFAULT' and resource_name ='FAILED_LOGIN_ATTEMPTS';

If the limit is not set to unlimited, you may set the same with the following command;
Alter profile DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
:)

tail command to follow the log file continuous upgrade

2010-04-26T02:26:00.000-07:00

tail -f (name of log file)
( The tail -f command can be used to monitor the growth of a file being written by another process)

How to check configuration AIX including machine make

2010-04-23T04:18:00.000-07:00

#prtconf more

What to monitor on Java System - nutshell

2010-04-20T03:17:00.000-07:00

You may quickly monitor the java system by :
1) Accessing the URL
2) System Info - All processes are running
3) Default trace and application trace for Server0 and Dispatcher
4) JCMON
5) sappfparcheck for all java profiles

Standalone TREX Installation

2010-04-15T03:01:00.000-07:00

If you are using a standalone TREX installation then configure the RFC with the central instance of ABAP not with the application server ( the same can happen if you have installed TREX on sam application server)

Other thing to keep in mind is that the https:// service should be running and if you install 32-bit TREX on a 64-bit system then there is a work around to do the same.

CSS T-Code to log on to customer system

2010-03-30T21:14:00.001-07:00

STFK

New way of Installing Oracle along with OPatches

2010-03-30T20:34:00.000-07:00

During installation of NWDI the ./sapinst stopped at the dialogue box where it says to install Oracle, we followed the following steps to install oracle:
1) Go to /oracle/JDI directory and deleted the 102_64 folder
2) copied already installed Oracle in the same instance CD2
/oracle/JDI # cp -pr /oracle/CD2/102_64 .
3) Changed the owner from oracd2:dba to orajdi:dba with following command
chown -R orajdi:dba 102_64
4) Go to the path /oracle/JDI/102_64/network/admin and delete all the files there as the installer will create new files as per the JDI Instance.
5) Click on OK to continue ./sapinst

Checking Usage Types from OS level

2010-03-29T15:08:00.000-07:00

There are two ways to check the Usage Types i.e. what all components are installed on the Java engine.
Go to the url http://hostname:port/utl/UsageTypesInfo
If for any reason you are not able to log on to the Java engine then we may also check the same from OS level
Go to path /usr/sap/SID/config, and open the file usagetypes.properties, the first line USAGE= in this file will tell you what all usage types are installed
Example : USAGE=BI-Java\:EPC\:EP

Gateway service restart on AIX

2010-02-09T05:59:00.000-08:00

Due to heavy load generated by TDMS_RFCs the gateway service on PRD CI hanged due to that there were many spool errors.
Solution
1. Logged on to CI
2. Found gateway service
ps -ef grep gw
found the process named gwrd (this is gateway service on AIX)
3. Killed the process with command
kill -2 PID of gateway service
4. ps -ef grep gw
again
it will show new gwrd process running.
(Actually dispatcher automatically restarts the gateway once it is killed)

BTCTRNS1 adn BTCTRNS2

2010-02-02T06:29:00.000-08:00

We can use the following reports for de-scheduling and releasing the jobs before and after some activity. For more info follow the below link :
https://forums.sdn.sap.com/message.jspa?messageID=3999326

Microsoft Exchange Relaying feature

2009-10-14T03:36:00.000-07:00

While configuring SAP Connect with Microsoft Exchange server, SAP could send the mails to internal email addresses but couldn't send to email addresses out of domain. This is because of Exchange relay feature (quoting)
http://technet.microsoft.com/en-us/library/dd277329.aspx
"To allow specified IP addresses—internal or external—to relay, check the "Hosts and clients with these IP addresses" checkbox, then use the Add, Edit, and Remove buttons to build the list of IP addresses from which you want to accept relay traffic. Remember that this checkbox controls relaying when you have selected the radio dial for "Reroute incoming SMTP ..." in the Routing tab. You should normally check this box; doing so will prevent relaying. If you leave it unchecked, your server is open for relay."

But the confusion remained from normal IP address 192.168.1.x we can send mail to outofdomain email addresses but why not from SAP servers (because they are on 192.168.213.x IP range ) :-)

If the administrator wants he may allow the same (192.168.213.x) as well to relay to outofdomain email addresses.

2009-10-12T23:54:00.000-07:00

We were getting (Value is obsolete) in Operating System MTE in RZ20. We followed the below link :
http://help.sap.com/saphelp_nw04/helpdata/EN/28/58b3d95bcea54d81e76b2ec122c564/content.htm
You can also reset the method status by selecting the corresponding MTE, choosing Display Details (), and, on the following screen, choosing Edit ® Method Status ® Reset ® Select Data Collection Method and it resolved the same.

5 steps to configure HADR on db2

2009-10-12T04:53:00.000-07:00

Here is all the setup required for HADR on one slide. Note the steps are quite simple.
Backup database on primary
Restore database on secondary
Set config parms (which are all pretty straight forward, hostname, port to listen on, remote instance name)
Start standby
Start primary
That’s it!

SAP may remain up during offline database backup

2009-10-08T03:37:00.000-07:00

Within an SAP environment, the SAP system may remain up and running during an offline backup to preserve the buffers of the SAP application servers. All SAP work processes are disconnected from the database and remain in a reconnect state during the offline backup. After the backup has been finished, the work processes reconnect to the database using the reconnect feature of the SAP Database Support Layer (DBSL). - DB2 UDB for SAP Guide

Learnings from Remote Client Copy

2009-09-29T04:20:00.000-07:00

1. Take offline backup just before the activity and switch off the archive logs otherwise, they will pile up and fill up the filesystem.
2. Execute the Test run before actual activity but it may not give practical results, in our scenario test run gave 2 hours but actually it took 12 hours for the copy to complete.
3. Lock users both in Target System and Source System, otherwise inconsistencies specially in number ranges may occur.
4. Take offline backup after Copy and don't forget to switch on archive logs before releasing the sytem for use.

SAPCPIC user don't lock only change the password

2009-09-26T03:02:00.000-07:00

SAPCPIC has the default password as (ADMIN), if you don't change the same your Early Watch Alert report will show red under User Authorizations. Follow SAP note 29276 to change the password only, don't lock the same.
Run report RSUSR003 to know what users are with standard passwords.

SAP Note 19574 Regarding Number Range in Client Copy

2009-09-26T02:56:00.000-07:00

Amazing SAP Note clears concept of Number ranges during client copy:

St02 Call Statistics Hit Ratio

2009-09-24T22:14:00.000-07:00

Yesterday we did a test run of client copy from PRD to DEV client. It took 2 hours during peak load. Today I checked the buffer it is showing hit ration 51% in call statistics the
"Select" is showing only 4-5% hit ration in both PRD and DEV instance.

The above is more or less in both PRD and DEV servers, then I read one blog and it said :
"Transport activity triggers flushing of SAP buffer. Hence it is always advisable to do transport in the least loaded segment of a day." -

http://soumen.wordpress.com/performance-tuning-of-sap-another-experiance/5-st02-another-magic-transaction-for-sap-tuners-ii/

After above scenario, we should take care even test run should be scheduled after peak hours. Any other suggestions on tuning are welcome.

SAP MC utility allows you to start / stop sap from browser

2009-09-15T04:46:00.000-07:00

From Netweaver Release 7.0 onwards, you may start and stop SAP intance from browser itself using the port http://hostname:5$$13 where $$ is the instance number. Amazing utility, even for UNIX also you can do the same. For more information, follow the below link:
http://help.sap.com/saphelp_nwpi711/helpdata/en/48/217444c3a34e6fe10000000a42189c/content.htm

Spool Request deleted immediately after printing

2009-09-14T05:21:00.000-07:00

In the given scenario when we need to preserve the spool request even after printing, (in our scenario the spool is to be converted to pdf using zsmart program), we need to make sure that the "Delete after output " option in User profile (SU01) -> Defaults tab is unchecked, other wise it may delete the request immediately.
Follow below links for further information :
http://sap.ittoolbox.com/groups/technical-functional/sap-basis/spool-request-gets-deleted-automatically-2065750

How to check process and memory status in AIX

2009-09-11T23:01:00.000-07:00

During monitoring we check the processes in SAP SM50 but if the SAP system is running for a long time, ST06 may show the RAM is reducing even though the system load is less. This results in less availability of RAM for other processes.

We need to trace the process that is consuming considerable amount of RAM. In AIX us the following command :
ps aux more
General view can be optained by command :
topas
Vitual memory state can be known by :
vmstat 01
For more information follow the below threads:
http://www.unix.com/aix/91057-process-consuming-most-memory.html
http://unix.ittoolbox.com/groups/technical-functional/ibm-aix-l/command-to-find-top-5-memory-consuming-process-2742917

Config Tool Usage

2009-09-10T05:23:00.001-07:00

You can only use the Config Tool to change parameters if all
instances of a SAP NetWeaver AS Java are stopped.

How to know who imported the Transport Request

2009-09-10T00:49:00.000-07:00

From the STMS, go to Import history Goto -> import history. Then in personal settings of import history (Extras -> Personal Settings) , uncheck the "Hide Expert Fuctions" . This will bring you more options in menu. Then in Edit tab, you will be able to see "Display more" which will show the user who imported the request in "user" column.

For details follow the below link :

https://forums.sdn.sap.com/message.jspa?messageID=6606054

EP key pair certificate expires after 2 years of installation

2009-09-08T23:53:00.000-07:00

When EP is installed it comes with the initial certificate for 2 years. You need to generate a new certificate so there is “Seamless SSO in spite of certification expiration “. Please follow the blog by Karsten Geiseler on SDN.
http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417400)ID0877570550DB01449507420568747014End?blog=/pub/wlg/4417

You may also follow the pdf
http://www.scribd.com/doc/6558598/Seamless-SSO-in-Spite-of-Certificate-Expiration

How to create certificate for your local system and get it certified from CA
http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417800)ID1328630650DB00590205151273352352End?blog=/pub/wlg/15747

Developers must not work on PRD system.

2009-09-08T05:14:00.000-07:00

Referring SAP Documentation

"Also, taking into consideration security factors (and perhaps performance aspects, if the developers have to debug programs), developers must not work on production system."

DB2 License Issue

2009-09-07T04:59:00.000-07:00

In DB2 , the SAP OEM license has to be applied after 90 days. If you don't apply then the database won't start. The procedure is different from Oracle as you need to log into the DB2 CLP to apply the license. Please find below the procedure:

1. Login as db2sol
2.Go to Start -> All Programs ->IBM DB2 -> SAPDB2SOL -> Command Line Tools -> Command Window
3. Now apply license here as per SAP Note 816773.Even with db2cmd we were not getting the actual license status.
Actually we raised OSS and logged it on SDN as well. For the same we also opened WTS connection. For more information, please refer the below SDN link:
https://forums.sdn.sap.com/thread.jspa?messageID=8124383&#8124383

Total number of SAP transaction per day

2009-09-05T03:41:00.000-07:00

There was a requirement from customer, if there is any way we can find out what is the total number of SAP transactions in any module in SAP. I raised the OSS, pl find below the reply:
Question :
"Is it possible to get the number of transacions done in SAP Finance per day?
We want to know how many transactions relating to FI are done in a day. "

Answer:
"There is no standard program that could record the transactions done during a day in any module."
-SAP Active Global Support