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 รุ่นก่อนๆ ส่วนเราคนใช้คงต้องฉลาดขึ้นกว่าเดิม สะแล้ว