SEPM 內嵌資料庫自動關閉的解法(內嵌資料庫瘦身法)

內嵌資料庫時常啟動後,會不定時關閉造成異常發生。試了很多方法最後用資料庫瘦身法,重新整頓內嵌資料庫可以解決資料庫不正常關閉的問題。

Solution:內嵌資料庫瘦身
The Dbunload tool is provided with Symantec Endpoint Protection 11.0.2 (Maintenance Release 2). To obtain Maintenance Release 2, read the document Accessing Maintenance Release 2 for Symantec Endpoint Protection 11.

Note: The problem that causes the embedded database to grow overly large is solved in Maintenance Release 2, but migrating to Maintenance Release 2 does not shrink the database automatically. To shrink the database, you must use the Dbunload tool.

To use the Dbunload tool

Stop the following services:
Symantec Endpoint Protection Manager
Symantec Embedded Database

Make a backup copy of the following file:

\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db

Start the service Symantec Embedded Database.
Click Start > Run, type CMD, click OK, and then type the following two lines at the prompt:

cd \Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32

dbunload -c “uid=dba;pwd=password_set_during_install" -ar

It takes about 10 minutes for the database file to shrink.

Note:
“password_set_during_install" is the password you supplied while installing Symantec Endpoint Protection Manager initially.

Restart the service Symantec Embedded Database.
Start the service Symantec Endpoint Protection Manager.

最後記得重開機..

之後會發現一切正常且資料庫有縮小

做這動作需要足夠的暫存空間供它使用

如果你本身的空間不足不夠它用…是不會成功的

廣告

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

您的留言將使用 WordPress.com 帳號。 登出 / 變更 )

Twitter picture

您的留言將使用 Twitter 帳號。 登出 / 變更 )

Facebook照片

您的留言將使用 Facebook 帳號。 登出 / 變更 )

Google+ photo

您的留言將使用 Google+ 帳號。 登出 / 變更 )

連結到 %s