廣告

2025 年 4 月
 123456
78910111213
14151617181920
21222324252627
282930  

彙整

瑞星-對岸的免費防毒軟體(Windows Server可用喔)

http://www.rising.com.cn/

對於經費有限的公司,有興趣的可試試看。

VMware Tools 更新失敗時,發生Error:1714錯誤,找不到原始安裝msi檔案,無法解除安裝舊的vmtools

資料參考:http://ishm.idv.tw/?p=179

遇到此問題,利用以下方式可強制移除舊有安裝:

1.至vmware點選 VM > Guest > Install/Upgrade VMware Tools。
2.進入guest os,不要自動執行安裝程式。
3.點 開始 > 執行,輸入 cmd,叫出命令提示字元。
4.變更到CD-ROM所在的磁碟,如「d:」,這時dir應該看得到vmtools的安裝程式。
5.輸入 setup.exe /c 或 setup64.exe /c,會進入強制移除vmtools安裝資訊的畫面,點確定即移除舊有安裝資訊。
6.這時再點選 VM > Guest > Install/Upgrade VMware Tools。
7.進入guest os,選擇自動安裝即可安裝最新的VMware Tools。

WSUS 3.0 SP2 安裝後無法同步 Object moved

之前的WSUS 3.0 SP1 Server忽然掛點,索性重新安裝個新的環境,但就在一切都安裝順利要做第一次精靈同步時,出現

WebException: 要求失敗,錯誤訊息為:

<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="%2fmicrosoftupdate%2fv6%2ferrorinformation.aspx%3ferror%3d15">here</a>.</h2>
</body></html>
–.
於 System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   於 System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   於 Microsoft.UpdateServices.ServerSyncWebServices.ServerSync.ServerSyncProxy.GetAuthConfig()
   於 Microsoft.UpdateServices.ServerSync.ServerSyncLib.InternetGetServerAuthConfig(ServerSyncProxy proxy, WebServiceCommunicationHelper webServiceHelper)
   於 Microsoft.UpdateServices.ServerSync.ServerSyncLib.Authenticate(AuthorizationManager authorizationManager, Boolean checkExpiration, ServerSyncProxy proxy, Cookie cookie, WebServiceCommunicationHelper webServiceHelper)
   於 Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.SyncConfigUpdatesFromUSS()
   於 Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ExecuteSyncProtocol(Boolean allowRedirect)

解決方法很簡單,只要再下載安裝修正更新檔即可解決:

http://support.microsoft.com/kb/2734608/en-us

X86   http://www.microsoft.com/en-us/download/details.aspx?id=30748

X64   http://www.microsoft.com/zh-tw/download/details.aspx?id=30747

高鐵雙翼商務美套房出租 (竹北市復興二路)

高鐵雙翼商務美套房出租 (竹北市復興二路)

http://www.hbhousing.com.tw/detail/?sn=DR06771

美女製作之布朗尼蛋糕-超好吃-開始訂購-350一個運費150滿10個免運費

美女製作之布朗尼蛋糕-超好吃-開始訂購-350一個運費150滿10個免運費

有 “心型” 造型可供情人節蛋糕使用,需要的請註名要 “心型” 的,謝謝。

http://www.facebook.com/media/set/?set=a.563314500346861.131322.100000049487967&type=1&l=bdf35dd834

若有需要請 MAIL至 tm.sale@infinity.idv.tw ,謝謝。

一米陽光,兩米月光,遠在香港的 JOYCE 梁家晞,希望妳幸福快樂^__^

一米陽光,兩米月光,遠在香港的 JOYCE 梁家晞,希望妳幸福快樂,你的老友 Roger 一直都在這沒離開過喔^__^

SQL Server 自動判別索引是否需要重建T-SQL與重建索引方式

參考網址:http://blog.miniasp.com/post/2009/01/18/Let-SQL-Server-Tell-You-Which-Indexes-to-Rebuild-or-Reorganize.aspx

自動查詢與建議索引重建之T-SQL語法:

SELECT ‘ALTER INDEX [‘ + ix.name + ‘] ON [‘ + s.name + ‘].[‘ + t.name + ‘] ‘ +

CASE

WHEN ps.avg_fragmentation_in_percent > 15

THEN ‘REBUILD’

ELSE ‘REORGANIZE’

END +

CASE

WHEN pc.partition_count > 1

THEN ‘ PARTITION = ‘ + CAST(ps.partition_number AS nvarchar(MAX))

ELSE ”

END,

avg_fragmentation_in_percent

FROM sys.indexes AS ix

INNER JOIN sys.tables t

ON t.object_id = ix.object_id

INNER JOIN sys.schemas s

ON t.schema_id = s.schema_id

INNER JOIN

(SELECT object_id ,

index_id ,

avg_fragmentation_in_percent,

partition_number

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL)

) ps

ON t.object_id = ps.object_id

AND ix.index_id = ps.index_id

INNER JOIN

(SELECT object_id,

index_id ,

COUNT(DISTINCT partition_number) AS partition_count

FROM sys.partitions

GROUP BY object_id,

index_id

) pc

ON t.object_id = pc.object_id

AND ix.index_id = pc.index_id

WHERE ps.avg_fragmentation_in_percent > 10

AND ix.name IS NOT NULL

查詢方式:

執行 SQL Server Management Studio Express 選文字方式呈現查詢

clip_image002

查詢後建議 索引重建的列表與碎片狀況(此為沒有文字模式呈現查詢結果 不好通通複製)

clip_image003

文字模式查詢出來後用 alt + 滑鼠 可做區塊選取模式

clip_image005

把剪下的指令另開查詢就可以開始重建了。

clip_image007

ESXi Patche檔案升級方式

ESXi Patche檔案升級方式

ESXi 5.1安裝版為 799733,Patch 為838463,且為個ZIP檔。

一、官網抓Patch檔

clip_image002

clip_image004

clip_image005

clip_image007

二、將檔案放到要升級的 ESXi Server儲存槽上

clip_image009

三、ssh連入要升級的ESXi Server內,下指令升級

~ # esxcli software vib install -d /vmfs/volumes/CS-VM-ESX-Server-Backup/ESXi510-201210001-838463.zip

====================

四、升級完成

Installation Result

Message: The update completed successfully, but the system needs to be rebooted for the changes to be effective.

Reboot Required: true

VIBs Installed: VMware_bootbank_esx-base_5.1.0-0.5.838463

VIBs Removed: VMware_bootbank_esx-base_5.1.0-0.0.799733

VIBs Skipped: VMware_bootbank_ata-pata-amd_0.3.10-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-atiixp_0.4.6-4vmw.510.0.0.799733, VMware_boot bank_ata-pata-cmd64x_0.2.5-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-hpt3x2n_0.3.4-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-pdc2027x_1. 0-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-serverworks_0.4.3-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-sil680_0.4.8-3vmw.510.0.0.799733 , VMware_bootbank_ata-pata-via_0.3.3-2vmw.510.0.0.799733, VMware_bootbank_block-cciss_3.6.14-10vmw.510.0.0.799733, VMware_bootbank_ehci-ehci-hcd _1.0-3vmw.510.0.0.799733, VMware_bootbank_esx-dvfilter-generic-fastpath_5.1.0-0.0.799733, VMware_bootbank_esx-tboot_5.1.0-0.0.799733, VMware_boo tbank_esx-xlibs_5.1.0-0.0.799733, VMware_bootbank_esx-xserver_5.1.0-0.0.799733, VMware_bootbank_ima-qla4xxx_2.01.31-1vmw.510.0.0.799733, VMware_ bootbank_ipmi-ipmi-devintf_39.1-4vmw.510.0.0.799733, VMware_bootbank_ipmi-ipmi-msghandler_39.1-4vmw.510.0.0.799733, VMware_bootbank_ipmi-ipmi-si -drv_39.1-4vmw.510.0.0.799733, VMware_bootbank_misc-cnic-register_1.1-1vmw.510.0.0.799733, VMware_bootbank_misc-drivers_5.1.0-0.0.799733, VMware _bootbank_net-be2net_4.1.255.11-1vmw.510.0.0.799733, VMware_bootbank_net-bnx2_2.0.15g.v50.11-7vmw.510.0.0.799733, VMware_bootbank_net-bnx2x_1.61 .15.v50.3-1vmw.510.0.0.799733, VMware_bootbank_net-cnic_1.10.2j.v50.7-3vmw.510.0.0.799733, VMware_bootbank_net-e1000_8.0.3.1-2vmw.510.0.0.799733 , VMware_bootbank_net-e1000e_1.1.2-3vmw.510.0.0.799733, VMware_bootbank_net-enic_1.4.2.15a-1vmw.510.0.0.799733, VMware_bootbank_net-forcedeth_0. 61-2vmw.510.0.0.799733, VMware_bootbank_net-igb_2.1.11.1-3vmw.510.0.0.799733, VMware_bootbank_net-ixgbe_3.7.13.6iov-10vmw.510.0.0.799733, VMware _bootbank_net-nx-nic_4.0.558-3vmw.510.0.0.799733, VMware_bootbank_net-r8168_8.013.00-3vmw.510.0.0.799733, VMware_bootbank_net-r8169_6.011.00-2vm w.510.0.0.799733, VMware_bootbank_net-s2io_2.1.4.13427-3vmw.510.0.0.799733, VMware_bootbank_net-sky2_1.20-2vmw.510.0.0.799733, VMware_bootbank_n et-tg3_3.110h.v50.4-4vmw.510.0.0.799733, VMware_bootbank_net-vmxnet3_1.1.3.0-3vmw.510.0.0.799733, VMware_bootbank_ohci-usb-ohci_1.0-3vmw.510.0.0 .799733, VMware_bootbank_sata-ahci_3.0-13vmw.510.0.0.799733, VMware_bootbank_sata-ata-piix_2.12-6vmw.510.0.0.799733, VMware_bootbank_sata-sata-n v_3.5-4vmw.510.0.0.799733, VMware_bootbank_sata-sata-promise_2.12-3vmw.510.0.0.799733, VMware_bootbank_sata-sata-sil24_1.1-1vmw.510.0.0.799733, VMware_bootbank_sata-sata-sil_2.3-4vmw.510.0.0.799733, VMware_bootbank_sata-sata-svw_2.3-3vmw.510.0.0.799733, VMware_bootbank_scsi-aacraid_1.1.5 .1-9vmw.510.0.0.799733, VMware_bootbank_scsi-adp94xx_1.0.8.12-6vmw.510.0.0.799733, VMware_bootbank_scsi-aic79xx_3.1-5vmw.510.0.0.799733, VMware_ bootbank_scsi-bnx2i_1.9.1d.v50.1-5vmw.510.0.0.799733, VMware_bootbank_scsi-fnic_1.5.0.3-1vmw.510.0.0.799733, VMware_bootbank_scsi-hpsa_5.0.0-21v mw.510.0.0.799733, VMware_bootbank_scsi-ips_7.12.05-4vmw.510.0.0.799733, VMware_bootbank_scsi-lpfc820_8.2.3.1-127vmw.510.0.0.799733, VMware_boot bank_scsi-megaraid-mbox_2.20.5.1-6vmw.510.0.0.799733, VMware_bootbank_scsi-megaraid-sas_5.34-4vmw.510.0.0.799733, VMware_bootbank_scsi-megaraid2 _2.00.4-9vmw.510.0.0.799733, VMware_bootbank_scsi-mpt2sas_10.00.00.00-5vmw.510.0.0.799733, VMware_bootbank_scsi-mptsas_4.23.01.00-6vmw.510.0.0.7 99733, VMware_bootbank_scsi-mptspi_4.23.01.00-6vmw.510.0.0.799733, VMware_bootbank_scsi-qla2xxx_902.k1.1-9vmw.510.0.0.799733, VMware_bootbank_sc si-qla4xxx_5.01.03.2-4vmw.510.0.0.799733, VMware_bootbank_scsi-rste_2.0.2.0088-1vmw.510.0.0.799733, VMware_bootbank_uhci-usb-uhci_1.0-3vmw.510.0 .0.799733, VMware_locker_tools-light_5.1.0-0.0.799733

五、重新開機

版本更新了

clip_image010

但是…….靜態的iSCSI連線不見了@@ 不知道是不是把動態拿掉的關係,要再測試。 測試過了,動態iSCSI拿掉,重開機就得重設連線與Paths…..真鳥………….不過之前設定的 rc.local.d/local.sh 開機自動執行的資料沒被更新蓋掉,可正常運作。

LocalDisk第一次要手動Mount,之後重開機就會自動掛載。

NFS掛載磁碟完全不受影響。

clip_image012

clip_image013

vShere出現Configuration Issues System logs on host XXX are stored on non-persistent storage訊息

http://blog.xuite.net/itwiz/learning/63538884

Configuration Issues : System logs on host XXX are stored on non-persistent storage.

clip_image002

Because of I installed ESXi on USB Storage. So I got the warning message.

How to Fix it ?

1. Create a Directory , named ".locker" in One of datastore.
2. Config the Dir path in Configuration / Software / Advanced Settings / ScratchConfig / ScratchConfig.ConfiguredScratchLocation
    Example: /vmfs/volumes/office-esx1_hdd1/.locker 
clip_image004

3. Reboot ESXi Host.

Reference : http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1033696