Author Topic: Move Oracle Database from Host1 to Host2 in GVP 8.1.4  (Read 2387 times)

Offline mumtazalam2k

  • Jr. Member
  • **
  • Posts: 55
  • Karma: 0
Move Oracle Database from Host1 to Host2 in GVP 8.1.4
« on: May 12, 2013, 02:28:25 PM »
Hi,

I have a GVP 8.1.4 deployment with SIP, RM, Framework+Management Layer and MCP/CCP installed on separate hosts.
i.e.
SIP - host1
RM - host2
Framework + Management Layer - host3
MCP/CCP - host4
Oracle Database - host3

The Oracle Database Server is installed on one of the hosts (host3) shared with Framework.
I need to move the database server to another host say host5.

I need to know what changes are required in the configuration objects of GVP 8.1.

I assume that the config database and log database schema will be recreated in the new Oracle database server on host5.

Thanks
M.

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7458
  • Karma: 56330
Re: Move Oracle Database from Host1 to Host2 in GVP 8.1.4
« Reply #1 on: May 13, 2013, 12:18:46 AM »
Search on the forum. This question was asked a few days ago.

Offline bublepaw

  • Sr. Member
  • ****
  • Posts: 283
  • Karma: 10
Re: Move Oracle Database from Host1 to Host2 in GVP 8.1.4
« Reply #2 on: May 13, 2013, 06:08:20 AM »
In addition I would check if GVP is using reporting database because it would mean You need to migrate one more database.

Offline mumtazalam2k

  • Jr. Member
  • **
  • Posts: 55
  • Karma: 0
Re: Move Oracle Database from Host1 to Host2 in GVP 8.1.4
« Reply #3 on: May 13, 2013, 03:45:23 PM »
Hi,

I did a search for my queries on earlier posts.
They are more on Oracle Express Migration or DataMart Migration.

My requirement is that I would like to move the Oracle Database (already installed with my current GVP) to another physical host.

Since it is a new installation, I am OK to install a fresh instance of the Oracle database.

Do I also need to migrate the current schema (log, configuration) instead of creating these schema new in my new oracle host?

Also what changes are required in my currently configured GVP application objects?

Thanks
M

Offline bublepaw

  • Sr. Member
  • ****
  • Posts: 283
  • Karma: 10
Re: Move Oracle Database from Host1 to Host2 in GVP 8.1.4
« Reply #4 on: May 13, 2013, 05:57:55 PM »
In general if You do clean database setup You have to install and configure everything from scratch so You need to migrate database from one server to another (post on migration from Oracle Express to SQL contains info how to do it). Log database can be created from scratch. If You are migrating configuration database You have to modify configuration server configuration files. For logs it is enough to modify DAP configuration. I would recommend reading with understanding "Management Framework Deployment Guide" before starting anything.

Offline fnunezsa

  • Full Member
  • ***
  • Posts: 213
  • Karma: 5
Re: Move Oracle Database from Host1 to Host2 in GVP 8.1.4
« Reply #5 on: May 17, 2013, 03:31:11 AM »
So your MOVING your RDBMS instance from on physical server to another physical server, right? It's not like migrating from MSSQL to Oracle, right? It's Oracle from host3 to Oracle on host5. This is a DBA task which can be achieved using RMAN. From the Genesys perspective, you just need to make sure that all DAPs (and configuration files) are pointing to the new host/instance. You might need to adjust your TNSNAMES.ORA file to point to the new host. 
GCP7 - CIV, DIV, CVP, CGIM
GCP8 - COV, CiWD

Offline Grand_Master

  • Jr. Member
  • **
  • Posts: 76
  • Karma: 0
Re: Move Oracle Database from Host1 to Host2 in GVP 8.1.4
« Reply #6 on: May 17, 2013, 10:02:08 AM »
What fnunezsa said.  If this will be a mirror image of your current DB, you could also configure it as your backup DB in your TNSnames.ora, configs and DAPs.  Your DBA might still have to sync some minor stats and config changes you missed prior to switchover.