Posts

Showing posts from 2013

SAP: Alternate way to approve downloads in Download Basket

As refer to here: http://scn.sap.com/thread/2121038 Method 1: There's a trick to approve packaged without calling MOPZ. Go to SE37 -> /TMWFLOW/MO_UI_BASKET_AUTHORIZ -> Process -> SAP-OSS -> Execute. OR SE38 and program /TMWFLOW/RMOBASKETAPPROVAL Method 2: An alternative to approve the download basket without Maintenance Optimizer is to create a support message under component SV-SMG-MAI-APR. //alak

Installing .Net Framework in Windows Server 2012

As per the topic, Micorosft has a dedicated page for this here : http://technet.microsoft.com/en-us/library/hh831809.aspx#BKMK_dotnetcmdlet But basically this works for me. 1. share the DVD drive 2. Open elevated powershell 3. PS C:\Windows\system32> DISM /Online /Enable-Feature /FeatureName:NetFx3 /All /LimitAccess /Source:\\1.100.7.40\win\Sources\SxS\ //alak

Enable/Disable Archive Log Mode Oracle 10g/11g

A very very very good and clear explanation from here :  http://www.oracledistilled.com/oracle-database/backup-and-recovery/enabledisable-archive-log-mode-10g11g/ To Disable: sqlplus / as sysdba shutdown immediate startup mount alter database noarchivelog; alter database open ; archive log list; To Enable: sqlplus / as sysdba archive log list show parameter recovery_file_dest alter system set log_archive_dest_1= 'LOCATION=/path/orcl/arch' scope = both; shutdown immediate startup mount alter database archivelog; alter database open ; archive log list //alak

How to Lock or Unlock a client In SAP

SAP unlock or Lock client Method 1: - go SE37 - SSCR_LOCK_CLIENT - or SSCR_UNLOCK_CLIENT  Method 2: Locking/unlocking the entire system, an admin can use the following commands: 1. tp locksys pf= 2. tp unlocksys pf= ripped off  http://www.saptechies.com/how-to-lock-or-unlock-a-client-in-sap/ //alak

SAP - Suspend/De-schedule all the scheduled jobs

For a purpose of system copy, we would need to stop/suspend or de-scheduled all scheduled jobs for export R3LOAD purpose. One quick way to do mass changes on all scheduled jobs is running below: - tcode SE38 - Program:  BTCTRNS1 - Execute This will make all jobs to status "Rescheduled due to Upgrade" After done the R3LOAD export, simply do the followings to restore: - tcode SE38 - Program:  BTCTRNS2 - Execute that's it! //alak

saplicense.exe -R3Setup SID XXXXXX TRACE=2' exits with error code -2. For details see log file(s) saplicense.log, dev_slic.).

Situation: - A R3load based system copy. - Source SID = ECP - Target SID = ECC - During Database instance installation, hit error while creating temp license. - snippets in sapinst_dev.log file: saplicense.exe -R3Setup ECC XXXXXX TRACE=2' exits with error code -2. For details see log file(s) saplicense.log, dev_slic.). - snipets from dev_slic file: -->oci_get_errmsg (con=0, rc=959)    OCIErrorGet -> SQL error code: 959    ORA-00959: tablespace 'PSAPECP' does not exist                                                                                exec_immediate() -> orc=959, 99=DBSL_ERR_DB    DbSlExecute() -> 99=DBSL_ERR_DB *** ERROR => DBSL statement where error happend:    CREATE TABLE MLICHECK (SYSTE...

Determine whether your SAP is MDMP, Non-Unicode or Unicode

Image
As per  http://scn.sap.com/thread/246990 Hi Sam, Run report RSCPINST and select /Current NLS config button/. It will show you current NLS settings, and on very top of it display: 1. Non-unicode system - meand single CP or blended CP inst; 2. MDMP installation - it's an MDMP box 3. Unicode inst - guess what  Checked it on MDMP, Unicode & BCP systems here rel 4.7 ent ABAP. Thanks. //alak

Oracle: View all available Schema

Ripped from: http://www.dba-oracle.com/t_display_all_schemas.htm select distinct    owner from    dba_segments where    owner not in ( 'SYSTEM',  ' XDB', 'SYS',  ' TSMSYS',  ' MDSYS',  ' EXFSYS',  ' WMSYS',  ' ORDSYS',  ' OUTLN',  ' DBSNMP');

SAPRouter

Link to SAP Service Market Place SAPRouter guides how tos downloads.. etc.. https://websmp109.sap-ag.de/saprouter-sncadd