Unsupported content

 

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Changing multiple databases

To change connection string parameters (such as host name, port, or instance name) in multiple databases (reports data warehouse, portal, and ETL repositories) at one time, use the postinstallation reconfiguration wizard available in the

    MultiExcerpt named 'Product_Name' was not found
The multiexcerpt named 'Product_Name' was not found. Please check the page name and MultiExcerpt name used in the MultiExcerpt Include macro. Console. 

Note

If you want to change the database schema, then restore the backup copies of the portal database and reports data warehouse and use the restored databases while using the postinstallation reconfiguration wizard.

To change the reports data warehouse, portal content store, and ETL databases

  1. Launch the 
      MultiExcerpt named 'Product_Name' was not found
    The multiexcerpt named 'Product_Name' was not found. Please check the page name and MultiExcerpt name used in the MultiExcerpt Include macro. Console, as described in 
    Accessing the console.
  2. Click Configuration > Database Details.
  3. In the Database Details section, click Reconfigure.
  4. Provide information on the Database Prerequisites tab (see (Oracle) Database Prerequisites tab or (SQL Server) Database Prerequisites tab). 
    • If you have already set up the database, select the check box and skip to step 6. 
    • If you have not created the users and tablespaces (for Oracle) or databases and users (for SQL Server), click the Download Database Scripts button to download the script and go to step 5. 
  5. Set up the database:
    • If you are using Oracle, create users and tablespaces by using the script and start the configuration process again. For instructions for creating users and tablespaces, see Setting up the Oracle database
    • If you are using SQL Server, create users and databases by using the script and start the configuration process again. For instructions for creating users and databases, see Setting up the SQL Server database.
  6. Click Next.
  7. Provide information on the ETL Master Repository tab, and click Next.
  8. Provide information on the Warehouse Database tab, and click Next.

    Note

    Enter details of the restored reports data warehouse.

     

  9. Provide information on the ETL Work Repository tab, and click Next.
  10. Provide information on the Portal Database tab, and click Next.

    Note

    Enter details of the restored portal database.

     

  11. Click Finish.
    The Last Task Details page lists the tasks that are run during the reconfiguration process and their status.
Was this page helpful? Yes No Submitting... Thank you

Comments