README - HP Systems Insight Manager 5.3
13. Now login with PostgreSQL account to perform database operations:
su postgres
14. Change the working directory to /usr/bin:
cd /usr/bin
15. The below command is not required, since there is a new version PostgreSQL. However, HP recommends
you execute the command and be sure insight_v1_0 is not present:
/dropdb -p 5432 -h 127.0.0.1 -i -e insight_v1_0
Press Y to confirm the delete of old database.
16. Create a user mxadmin and assign super user role:
./createuser -h 127.0.0.1 -p 5432 -U postgres mxadmin
Press Y to confirm adding the new user.
17. Create a fresh database with name insight_v1_0:
./createdb -O postgres -h 127.0.0.1 -p 5432 -U postgres insight_v1_0
18. Restore the data which was backed up in step 5:
./psql -q -h 127.0.0.1 -U mxadmin -p 5432 -f /home/SaveHPSIMdb -d
insight_v1_0 Exit from the postgres user
19. Login, change user to root, and restart the HP SIM service with mxstart and be sure HP SIM service
comes up.
20. Browse to HP SIM and verify the database operations are done successfully. Compare the data with
inventory.log to verify all the data is present.
21. Upgrade to HP SIM 5.3.
-------------------------------------------------------------
Go to http://www.hp.com/go/hpsim/, and click Questions & Answers for more information on migrating
from Insight Manager 7 or Servicecontrol Manager 3.0 to HP SIM.
-------------------------------------------------------------
When upgrading your HP SIM installation on HP-UX to HP SIM 5.3, an automatic reboot is performed, and
then the actual upgrade process begins. The HP-UX upgrade process includes an automatic reboot and can
take up to two hours to complete. You can check the initconfig.log to determine if the upgrade has
completed.
-------------------------------------------------------------
HP SIM requires that Microsoft SQL Server 2005 Express Edition have the TCP/IP protocol enabled.
1. Select Start→Run and enter svrnetcn.exe.
2. In the Disabled Protocols box, select TCP/IP.
3. Click Enable.
4. Click OK.
-------------------------------------------------------------
Seeing SQL exception errors during upgrade is expected behavior.
-------------------------------------------------------------
When upgrading HP SIM and you have an Oracle database, you must install the Oracle JDBC driver, version
10.1.0.2.0 or newer. See the Oracle documentation, or visit the Oracle website at:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
For additional information. If you have an older version of the JDBC driver already installed, complete the
following:
For Windows:
1. Stop the HP SIM service.
2. Remove the ojdbc14.jar file from the install dir/lib and install
dir/jboss/server/hpsim/lib directories.
Upgrade 47