Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Oracle Analytics Server Migration to Another Server (Publisher content)
Product: Oracle Analytics Server 7.6
OS: Oracle Linux 7.9
Scenario:
I am trying to duplicate a set of server data from Server A to Server B. Based on my research, the scheduler jobs used by BI Publisher are stored in the schema. To achieve this, I exported the entire RCU schema from the database on Server A and imported it into the database on Server B. Additionally, I copied the entire domain from Server A to Server B and updated the hostname and connection settings to point to the Server B database.
My expectation was that the scheduler jobs, job history, and catalog from Server A would be replicated and visible on Server B. While the catalog is visible, the scheduler jobs and job history are missing.
Is there a recommended approach to successfully migrate or duplicate the scheduler jobs from Server A to Server B?
Thanks.
Answers
-
0
-
Hi,
I have reviewed the document, but I am still unclear about certain aspects. Does it mean that after completing the database import, I need to run the mentioned approaches on the destination database?
I want to confirm if my understanding is correct, as I am concerned about potential corruption or issues. Could you please clarify this process?
Thanks.
0 -
My understanding is that you have to use the documented approach to migrate the scheduler data from a source environment (e.g. your Server A) to a target one (e.g. your Server B). I would not export/import RCU data manually.
0 -
the scheduler jobs used by BI Publisher
@Tiang , is your question mostly focused on the Publisher content migration? Or do you also have other elements of the analytics platform that you are interested in? I'm asking because if you are mostly after the "good practice" to migrate the whole Publisher content, moving this question in the Publisher category could give you better answers…
0 -
@Gianni Ceresa i focus on the publisher content migration only. Like Catalog, and Scheduler Job.
0 -
Ok, moved to the Publisher category to get the attention of the Publisher people. I do remember having seen a number of topic about Publisher upgrades and migrations, it sounds like a topic where there is still space for some "good practices" in how to perform those things.
1
