Page History

...

Using CLI, you can move the PMDB to another server.NOTE    When

Limitations

...

• You can only move the PMDB. No agents are involved.

...

• You can only move to the same DBMS type (for example, Oracle to Oracle and SQL Server to SQL Server).
  However, you can move to another DBMS version.

  ...

  • • For an SQL Server based database, you must use the same authentication mode (SQL authentication or Windows OS Authentication), and the new database should have the same collation.

  ...

  • • For an Oracle database, you must use the same charset.

  For guidelines regarding export and import, see Examples for exporting and importing an SQL Server or Oracle based PMDB on page 142.

  Procedure

  To move the PMDB1.    Stop

  1. Stop all agents, including Precise Listeners and the Precise FocalPoint.

  ...

  1. Manually export the PMDB, and import it to the new DBMS. For an Oracle PMDB, export the PMDB tablespaces metadata also.

  ...

  1. Start the Precise FocalPoint.

  ...

  1. Run the CLI command on the main Precise FocalPoint server. The command updates the Precise registry with the related information.
     Windows    infra\bin\psin_cli.bat
                       -i3-user <user_name>
                       {-i3-encrypted-password <encrypted_password> | -i3-clear-password <clear_password>}
                       -action move-pw-db
                       -parameter <parameter_name>=<parameter_value>
     UNIX  

  ...

  1.         ./infra/bin/psin_cli.sh
                       -i3-user <user_name>
                       {-i3-encrypted-password <encrypted_password> | -i3-clear-password <clear_password>}
                       -action move-pw-db
                       -parameter <parameter_name>=<parameter_value>

  Info

  ...

  You need to specify only the parameters that were changed. For the list of parameters, see Installing the Precise  Framework on page 9.

  For example:

  For SQL Server in
  Windows:

            infra\bin\psin_cli.bat
            -i3-user admin -i3-clear-password admin
            -action move-pw-db -parameter dbms-instance=NEW_DATABASE1
            -parameter dbms-dba-user=sa
            -parameter dbms-dba-clear-password=sa
  For Oracle in
  UNIX:
            ./infra/bin/psin_cli.sh
            -i3-user admin -i3-clear-password admin
            -action move-pw-db -parameter dbms-
            server=new_poolhp6 -parameter dbms-instance=NEW_ORCL dbms-dba-user=SYSTEM dbms-dba-clear- password=MANAGER
  
  Table 13-4    Elements 4 Elements for Moving the PMDB to another serverElement    Description

  Element	Description
  i3-

  ...

  user	See Authenticate to CLI Utility on page 8.
  i3-encrypted-

  ...

  password

  See Authenticate to CLI Utility on page 8.

  ...

  action

  Always move-pw-db Mandatory: Yes

  ...

  parameter

  The changed parameters. For more information about Performance Management DBMS related parameters, see Installing the Precise Framework on page 9. Values: parameters in format name=value Mandatory: Yes

  Verification

  After moving the PMDB to another server, perform the following verifications in the new installation:•    Check

  • Check the agent’s status in Adminpoint

  ...

  • Check that the Performance Warehouse processes are running and that data is loaded

  ...

  • Check that data is displayed in the various products

  Examples for exporting and importing an SQL Server or Oracle based PMDB

  The following section provides examples of the export and import procedures for SQL Server and Oracle based PMDBs.

  Exporting and importing an SQL Server based PMDB

  To export an SQL Server based PMDB1.    Open

  1. Open the Microsoft SQL Server Management Studio.

  ...

  1. Right-click on the Performance Warehouse database.

  ...

  1. Select the Tasks > Back Up … option.

  ...

  1. Configure the backup file and click OK.

  ...

  1. Wait for confirmation of a successful export.

  To import an SQL Server based PMDB1.    Copy

  1. Copy the created backup file to the new server.

  ...

  1. Open the Microsoft SQL Server Management Studio on the new server.

  ...

  1. Right-click on Databases.

  ...

  1. Select Restore Database….

  ...

  1. In the "to database?" field, enter the previous database name.

  ...

  1. In the "from device" field, click on the ... (browse) button, and select the backup meda file.

  ...

  1. Select Add.

  ...

  1. Select the backup file.

  ...

  1. Click OK.

  ...

  1. Select the most recent backup.

  ...

  1. Click OK on the restore confirmation message.

  Exporting and importing an Oracle based PMDB

  When using Oracle as the PMDB repository, you can use the export and import utilities to move data. For more information, see http://wiki.oracle.com/page/Oracle+export+and+import+.NOTE    These

  Info
  These utilities are available under the <ORACLE_HOME>/bin folder.

  
  To export an Oracle based PMDB1.    Open

  1. Open a command line.

  ...

  1. Execute "exp" with the tablespaces’ parameter.

  ...

  1. Follow the instructions in the script (you can use most of default values).

  ...

  1. For "user to be exported", enter the PMDB user, for example: PRECISE_PMDB
     If error 942 occurs while using the export utility, execute the following as system user:
@c:\oracle\ora92\rdbms\admin\catexp.sql

  To import an Oracle based PMDB1.    Copy

  1. Copy the exported data to the new database.

  ...

  1. Open a command line in the new database.

  ...

  1. Execute the "imp‟ command and follow the script instructions.

   

  Precise. Performance intelligence from click to storage. Learn more > >

  ...