Posts

Connecting to HP 1910 J007A Switch via Console using Mac OS X Malvericks 10.9.3

Hi, Have a case to console in to HP 1910 J007A HP switch. Using ATEN UC232A (Prolific?) S232 to SUB converter and a good console cable(RJ45 to S232). Installation used as per here: http://rolande.wordpress.com/2012/10/25/getting-the-aten-usb-serial-adapter-working-with-mac-osx-lion/ After driver installation, and after loading the kernel externsion using below command: sudo kextload /System/Library/Extensions/ProlificUsbSerial.kext i open up a terminal. in my case, i use iTerm for Mac. the format for the screen syntax is as: screen and HP's BAUD is 38400 so command: screen /dev/tty.usbserial 38400 Login authentication Username:admin Password: #Apr 23 12:49:06:656 2001 HP V1910 Switch SHELL/4/LOGIN:  Trap 1.3.6.1.4.1.25506.2.2.1.1.3.0.1:admin login from Console %Apr 23 12:49:06:806 2001 HP V1910 Switch SHELL/4/LOGIN: admin login from aux0 ? User view commands:   initialize  Delete the startup configuration file and reboot system ...

Example querying from MS SQL - SAP Table USR02

SELECT TOP 10 [MANDT]       ,[BNAME]       ,[BCODE]       ,[GLTGV]       ,[GLTGB]       ,[USTYP]       ,[CLASS]       ,[LOCNT]       ,[UFLAG]       ,[ACCNT]       ,[ANAME]       ,[ERDAT]       ,[TRDAT]       ,[LTIME]       ,[OCOD1]       ,[BCDA1]       ,[CODV1]       ,[OCOD2]       ,[BCDA2]       ,[CODV2]       ,[OCOD3]       ,[BCDA3]       ,[CODV3]       ,[OCOD4]       ,[BCDA4]       ,[CODV4]       ,[OCOD5]       ,[BCDA5]       ,[CODV5]       ,[VERSN]       ,[CODVN]       ,[TZONE]     ...

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