RE: How to export/import/migrate Report Definitions from 10g Grid to 11g

From: Shanmugam, Satheesh B <satheesh.b.shanmugam_at_jpmchase.com>
Date: Fri, 24 Feb 2012 14:35:01 +0000
Message-ID: <2BCCB1F834945545A57388A869B75CA4013851_at_SPTCMX003.exchad.jpmchase.net>

I have not done between 10g to 11g. Below steps done between two 11g grids. If the emcli of 10g has export_report option, then you should be able to import to 11g as the output file is in xml.

In source:

./emcli setup -url=https://source_hostname:7799/em -username=sysman

./emcli export_report -title="Database Size" -owner="SYSMAN" -output_file="db_size.xml"

Report "Database Size", owned by "SYSMAN", has been exported from the repository. Exported reports may not contain all information from original report. Repository specific information such as targets, administrator access, and schedules are not exported. Imported reports should be edited after import to supply all necessary report parameters.

In Target:

./emcli setup -url=https://target_hostname:7799/em -username=sysman

./emcli import_report -files="db_size.xml"

File "db_size.xml" has been imported into the repository. Imported reports should be edited after import to supply all necessary report parameters.

Regards,
Satheesh Shanmugam

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tony Adolph Sent: Tuesday, February 14, 2012 1:45 AM To: Oracle Discussion List; oracle-l-bounce_at_freelists.org Cc: Rahul.Dixit_at_2degreesmobile.co.nz
Subject: How to export/import/migrate Report Definitions from 10g Grid to 11g

Hi Folks,
Does anyone know how to export/import/migrate Report Definitions from 10g Grid to 11g?

I have built a new Grid on a new server with a new repository database. The existing 10g Grid, server and database are to be decommissioned.

I'd like to copy the old users to the new grid and all of the report definitions.

This must be a common ask, but I can't find any documentation on either the user migration or report definition migration.

Any help would be appreciated.

Thanks
Tony

--
http://www.freelists.org/webpage/oracle-l


This communication is for informational purposes only. It is not
intended as an offer or solicitation for the purchase or sale of
any financial instrument or as an official confirmation of any
transaction. All market prices, data and other information are not
warranted as to completeness or accuracy and are subject to change
without notice. Any comments or statements made herein do not
necessarily reflect those of JPMorgan Chase & Co., its subsidiaries
and affiliates.

This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and any
attachments are believed to be free of any virus or other defect
that might affect any computer system into which it is received and
opened, it is the responsibility of the recipient to ensure that it
is virus free and no responsibility is accepted by JPMorgan Chase &
Co., its subsidiaries and affiliates, as applicable, for any loss
or damage arising in any way from its use. If you received this
transmission in error, please immediately contact the sender and
destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.

Please refer to http://www.jpmorgan.com/pages/disclosures for
disclosures relating to European legal entities.
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 24 2012 - 08:35:01 CST