Import SAP Transport Request Using Command

1. Coppy  Transport request file to /usr/sap/trans/data  and /usr/sap/trans/cofiles
2. Add  Transport request file to Buffer  using command
    "tp addtobuffer <Transport Number> <System ID> pf=/usr/sap/trans/bin/<Transport Profile>"
3. Import to system using command
    "tp import <Transport Number> <System ID> CLIENT=<Client Number> u128       pf=/usr/sap/trans/bin/<Transport Profile>"

Example

sap01:sapadmt 28> tp addtobuffer PRDK911682 PRD pf=/usr/sap/trans/bin/TP_DOMAIN_PRD.PFL
This is tp version 380.04.07 (release 720, unicode enabled)
Warning: Parameter DBLIBPATH is no longer used.
Addtobuffer successful for PRDK911682
tp finished with return code: 0
meaning:
   Everything OK

sap01:sapadm 29> tp import PRDK911682  PRD CLIENT=900 u128 pf=/usr/sap/trans/bin/TP_DOMAIN_PRD.PFL
This is tp version 380.04.07 (release 720, unicode enabled)
Warning: Parameter DBLIBPATH is no longer used.
This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).
unicode enabled version
R3trans finished (0000).
tp finished with return code: 0
meaning:
    Everything OK
sap01:sapadm 30>

Fix ORA-28011: the account will expire soon; change your password now

Fix ORA-28011: the account will expire soon; change your password now

1. check  user profile 

SQL>select USERNAME,ACCOUNT_STATUS,PROFILE from  dba_users where USERNAME = <USERACCOUNT>;

2. view Profile setting and change expire parameter to unlimit

SQL>select * from dba_profiles where profile = <USER_PROFILE>;

SQL>alter profile <USER_PROFILE> LIMIT PASSWORD_LIFE_TIME UNLIMITED;

3. change password and commit

SQL> alter user <username> identified by <passwd>;

SQL> commit;

VMware vSphere 5.5 new features

 

VMware vSphere 5.5 introduces many new features

enhancements that further extend the core capabilities
of the vSphere platform. The core vSphere ESXi Hypervisor enhancements in vSphere 5.5 include the following:

• Hot-pluggable SSD PCIe devices
• Support for Reliable Memory Technology
• Enhancements to CPU C-states
Along with the core vSphere ESXi Hypervisor improvements, vSphere 5.5 provides the following virtual
machine–related enhancements:
• Virtual machine compatibility with VMware ESXi 5.5
• Expanded support for hardware-accelerated graphics vendor
• Graphic acceleration support for Linux guest operating systems
In addition, the following vCenter Server enhancements include:
• vCenter Single Sign-On Server security enhancements
• vSphere Web Client platform support and UI improvements
• vCenter Server Appliance configuration maximum increases
• Simplified vSphere App HA application monitoring
• vSphere DRS virtual machine–virtual machine affinity rule enhancements
• vSphere Big Data Extensions, a new feature that deploys and manages Hadoop clusters on vSphere from
within vCenter
vSphere 5.5 also includes the following storage-related enhancements:
• Support for 62TB VMDK
• MSCS updates
• vSphere 5.1 enhancements
• 16GB E2E support
• PDL AutoRemove
• vSphere Replication interoperability and multi-point-in-time snapshot retention
vSphere 5.5 also introduces the following networking-related enhancements:
• Improved LACP capabilities
• Traffic filtering
• Quality of Service tagging

How to check Memory Dimm Information in hp-ux

Use command  /opt/propplus/bin/cprop -summary -c "Memory"

-------------------------------------------------------------------------------------------

XXX@XXXX:/# /opt/propplus/bin/cprop -summary -c "Memory"

[Component]: Memory
[Table]: Memory Slots
-------------------------------------------------------
[Instance]: 1
****************************************************
                   [Hash ID]: Memory:5d4a0862x961e80ce
                    [Status]: OK
                  [Location]: This is Volatile Memory Chip of type SDRAM with following details :  Cell Slot : 06, Dimm Slot : 3a, Socket : 00.
                      [Size]: 4 GB
               [Module Type]: DIMM
               [Memory Type]: SDRAM
             [Serial Number]: 80CE031312129BFC78
               [Part Number]: M393B5270CH0-YH9

-------------------------------------------------------
[Table]: Empty Slots
-------------------------------------------------------
[Instance]: 5
****************************************************
                   [Hash ID]: Memory:da2e5f4fx2560adb5
                  [Location]: Cell Slot : 06, Dimm Slot : 01, Extender : 01
      [Location Identifiers]: Cell Slot: 06,  Slot: 01,  Extender: 01
         [Physical Position]: ff-ff-ff-6-1-1-a-74
****************************************************
[Instance]: 6
****************************************************
                   [Hash ID]: Memory:a5baaa13x6a0c0275
                  [Location]: Cell Slot : 06, Dimm Slot : 07, Extender : 01
      [Location Identifiers]: Cell Slot: 06,  Slot: 07,  Extender: 01
         [Physical Position]: ff-ff-ff-6-1-7-a-74

How to Enable Connection Mysql from Remote Server

1. Open a DOS command prompt on the server.
2. Run the following command from the mysql\bin directory:
mysql -u root --password=
3. A mysql> prompt should be displayed.
4. To create a remote user account with root privileges, run the following commands:
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';

mysql> FLUSH PRIVILEGES;
mysql> exit; 

ติดตั้ง .Net Framework 3.5 บน Windows Server 2012

เมื่อทำการติดตั้ง  .Net Framework 3.5 บน Windows Server 2012 ตอนแรกจะพบว่ามัน failed แบบนี้

วิธีแก้ให้ใส่แผ่น Disk ติดตั้งวินโดวเข้าไปในเครื่อง และเริ่มแอด Role ใหม่อีกครั้งโดยก่อนที่จะกด Install จะมีให้เลือก alternate source path

 เมื่อกดเข้ามาแล้ววินโดวจะให้ใส่ Path ในตัวอย่างนี้ CD ของผมเป็นไดร D:

 ก็ใส่ D:\sources\sxs เข้าไปและกด Install ต่อไปจะพบว่ามันผ่านแล้วครับ ^^

ส่วนสาเหตุเนื่องจาก ตอนติดตั้งวินโดวไม่ได้ Copy  Source ของ .Net เอาไว้ด้วยและมันก็ไม่ฉลาดพอที่จะถามหาแผ่น Disk เหมือน Windows รุ่นก่อนๆ ส่วนเราคนใช้คงต้องฉลาดขึ้นกว่าเดิม สะแล้ว

Whip your inbox into shape

Whip your inbox into shape

How many emails are sitting in your email inbox right now? Dozens? Hundreds? Thousands? According to a study by the Radicati Group [1], the typical corporate email user sends and receives about 105 email messages per day. Sorting all this information can be a real time suck.

แก้ปัญหา Logon Screen Windows Server 2003 เป็นสีดำ

เมื่อเกิดปัญหานี้จะพบว่าเมื่อเข้าสู่หน้า Logon คุณจะเห็นเพียงแค่ช่อง สีขาว 3 ช่อง และไม่ว่าจะพิมอะไรก็มองไม่เห็น สาเหตุเกิดจากค่าโปรไฟล ในส่วนของสี ของหน้า Logon มันเสีย โดยค่า Registry นี้จะอยู่ที่

HKEY_USERS\Default\Control Panel\Colors

วิธีแก้ง่ายๆ คือให้ไป Export ค่านี้จากเครื่องอื่นที่เป็น OS รุ่นเดียวกันมา Merg เข้าไปในเครื่องที่มีปัญหา เท่านี้ก็แก้ได้แล้ว ^^

ที่มา http://support.microsoft.com/kb/906510

How to install Microsoft Routing and Remote Access.

Open the RRAS MMC Snap-in

1 out of 1 rated this helpful - Rate this topic

Applies To: Windows Server 2008 R2

Use these procedures to open the Routing and Remote Access MMC snap-in.

Membership in the local Administrators group, or equivalent, is the minimum required to complete this procedure.

To open the RRAS MMC snap-in by using Server Manager

1. To start Server Manager, click Start, click Administrative Tools, and then click Server Manager.
2. Expand Roles, expand Network Policy and Access Services, and then click Routing and Remote Access.

To open the RRAS MMC snap-in as a standalone console

• Click Start, click Administrative Tools, and then click Routing and Remote Access.
  
  
  
  credit http://technet.microsoft.com/en-us/library/dd851494.aspx

SAP BASIS TCODE for CUA "Central User Admin"

SAP BASIS  TCODE for CUA "Central User Admin" 

scum for user distribution field selection 
scua for maintain system landscape 
scul for display and processing idoc distribution log 
scug for transfer/sync Users and company address 
suim for display the list of all users in child systems (IDoc number, roles assigned) 
bd57 for defind logical system 
bd64 for display distribution model 
bd87 for display ICOCS error 

we20 for Partner Profiles 
we21 for idoc configuration port ( transactionPorts#tRFC in IDoc Processing) 
scc4 for assign logical system 
sm59 for RFC Connection 
sm58 for tRFC-Queue (IDoc) 
pfcg for child system Text Comparison for CUA Central System 
su01 for central system maintain password,users,role,profile child system with system(logical name) 
/$cua for flush buffer cua after copy role from other client