軟體升級失敗後,從備份封存中還原 CA Performance Center 資料庫。 如果在升級 CA Performance Center 軟體時發生錯誤,您必須還原資料庫並更新架構。
附註:除非發生失敗,否則升級之後不需要還原資料庫。 採取「失敗安裝後清除」中所描述的清除步驟後再次嘗試升級。 接著採取這個程序中的步驟。
請依循下列步驟:
/etc/init.d/caperfcenter_eventmanager stop /etc/init.d/caperfcenter_devicemanager stop /etc/init.d/caperfcenter_sso stop /etc/init.d/caperfcenter_console stop
這些服務便已停止。
cd /$backupDir
tar zxvf netqosportal.tgz tar zxvf em.tgz
mysql netqosportal -e ‘source $backupDir/netqosportal.sql’
mysql em -e ‘source $backupDir/em.sql'
cd /opt/CA/PerformanceCenter/Tools/bin
mysql -P3306 -D netqosportal -u root
mysql> select InstallDate, version, dbschemaversion from revision_info order by InstallDate asc;
結果將列出軟體與資料庫結構描述的安裝日期以及版本。
如果資料庫版本與目前的產品版本不符,請採取下一組的升級步驟。
./npcshell.sh upgradedb
/opt/CA/jre/bin/java -jar /opt/CA/PerformanceCenter/SQL/seedlu/bin/seedlu.jar -resfile "/opt/CA/PerformanceCenter/SQL/messages_en_US.properties" -ctrlfile "/opt/CA/PerformanceCenter/SQL/control.sdlctrl" -connection "jdbc:mysql://localhost:3306/netqosportal?useUnicode=true&characterEncoding=UTF-8" -user netqos -pwd netqos -lang en-US
/opt/CA/jre/bin/java -jar /opt/CA/PerformanceCenter/SQL/seedlu/bin/seedlu.jar -resfile "/opt/CA/PerformanceCenter/SQL/messages_zh_CN.properties" -ctrlfile "/opt/CA/PerformanceCenter/SQL/control.sdlctrl" -connection "jdbc:mysql://localhost:3306/netqosportal?useUnicode=true&characterEncoding=UTF-8" -user netqos -pwd netqos -lang zh-CN
/opt/CA/jre/bin/java -jar /opt/CA/PerformanceCenter/SQL/seedlu/bin/seedlu.jar -resfile "/opt/CA/PerformanceCenter/SQL/messages_zh_TW.properties" -ctrlfile "/opt/CA/PerformanceCenter/SQL/control.sdlctrl" -connection "jdbc:mysql://localhost:3306/netqosportal?useUnicode=true&characterEncoding=UTF-8" -user netqos -pwd netqos -lang zh-TW
/opt/CA/jre/bin/java -jar /opt/CA/PerformanceCenter/SQL/seedlu/bin/seedlu.jar -resfile "/opt/CA/PerformanceCenter/SQL/messages_fr_FR.properties" -ctrlfile "/opt/CA/PerformanceCenter/SQL/control.sdlctrl" -connection "jdbc:mysql://localhost:3306/netqosportal?useUnicode=true&characterEncoding=UTF-8" -user netqos -pwd netqos -lang fr-FR
/opt/CA/jre/bin/java -jar /opt/CA/PerformanceCenter/SQL/seedlu/bin/seedlu.jar -resfile "/opt/CA/PerformanceCenter/SQL/messages_ja_JP.properties" -ctrlfile "/opt/CA/PerformanceCenter/SQL/control.sdlctrl" -connection "jdbc:mysql://localhost:3306/netqosportal?useUnicode=true&characterEncoding=UTF-8" -user netqos -pwd netqos -lang ja-JP
CA Infrastructure Management 管理頁面:
./npcshell.sh dbmigrate -package com.ca.im.plugin.pc -path ../../SQL/plugins/pc/
事件相關檢視:
./npcshell.sh dbmigrate -package com.ca.im.plugin.em -path ../../SQL/plugins/eventmanager/
Data Aggregator 管理頁面與檢視:
./npcshell.sh dbmigrate -package com.ca.im.plugin.da -path ../../SQL/plugins/polaris/
mysql -P3306 -D netqosportal -u root
mysql> select InstallDate, version, dbschemaversion from revision_info order by InstallDate asc;
/etc/init.d/caperfcenter_eventmanager start /etc/init.d/caperfcenter_devicemanager start /etc/init.d/caperfcenter_sso start /etc/init.d/caperfcenter_console start
rm netqosportal.sql
rm em.sql
Copyright © 2014 CA Technologies.
All rights reserved.
|
|