Difference: DataManagementDBMigration (1 vs. 7)

Revision 72008-05-14 - LanaAbadie

Line: 1 to 1
 
META TOPICPARENT name="DataManagementTop"
Show Children Hide Children
<!--/twistyPlugin twikiMakeVisibleInline-->

<!--/twistyPlugin-->
Data Management
Main
Talks
Components
FTS
LFC
DPM
lcg_util/GFAL
Medical
Last Page Update
LanaAbadie
2008-05-14

<!--
DataManagementDBMigration's Children
 
-->
Line: 8 to 8
 So the application creates the oracle schema using the LFC/DPM table schema script (which should map the LFC MySQL, i.e. same version).

Prerequisites:

  • Linux OS
Changed:
<
<
  • mysqlclient
>
>
  • mysqlclient (mysql-devel needed)
 
  • sqlplus
  • sqlloader
Changed:
<
<
  • OCI (oracle instant client)
>
>
  • OCI (oracle instant client devel version, basic not enough)
 
  • the sql script which creates and drops the Oracle schema (should match the MySQL schema)
  • The LFC service should be stopped
Line: 40 to 40
 

Remark

The application does not drop the MySQL DB even if the application is successful.

Added:
>
>
The pwd of DBs are removed from the config_file.data
 
Added:
>
>

FAQ

1. How do i fill these two variables create_ora_schema_path and drop_ora_schema_path? create_ora_schema_path=/home/oracle/Migration-LFC-MySQL-Oracle-v2/Cns_oracle_tbl.sql; drop_ora_schema_path=/home/oracle/Migration-LFC-MySQL-Oracle-v2/Cns_oracle_drop.sql; 2. Is there any log file? Yes, have look at output/MigrateLFC_logfile.log 3. I can't find the include files for oracle be sure you have installed oracle-instantclient-devel (the basic one is not sufficient if you need to compile the application). 4. make doesn't work Be sure you have done make clean and edited properly the makefile (ORA_INSTANTINCL, ORA_LIBS, MYSQL_LIBS and MYSQL_HOME). If still doesn't work, send me an email.
 -- LanaAbadie - 07 May 2007

META FILEATTACHMENT attachment="MySQLOracleMigration.tar" attr="" comment="source files" date="1207037747" name="MySQLOracleMigration.tar" path="MySQLOracleMigration.tar" size="491520" stream="MySQLOracleMigration.tar" user="Main.LanaAbadie" version="1"

Revision 62008-04-01 - LanaAbadie

Line: 1 to 1
 
META TOPICPARENT name="DataManagementTop"
Show Children Hide Children
<!--/twistyPlugin twikiMakeVisibleInline-->

<!--/twistyPlugin-->
Data Management
Main
Talks
Components
FTS
LFC
DPM
lcg_util/GFAL
Medical
Last Page Update
LanaAbadie
2008-05-14

<!--
DataManagementDBMigration's Children
 
-->
Line: 43 to 43
  -- LanaAbadie - 07 May 2007
Changed:
<
<
META FILEATTACHMENT attachment="MySQLOracleMigration.tar" attr="" comment="source code to migrate a MySQL DB to an Oracle DB" date="1201183987" name="MySQLOracleMigration.tar" path="MySQLOracleMigration.tar" size="133120" stream="MySQLOracleMigration.tar" user="Main.LanaAbadie" version="1"
>
>
META FILEATTACHMENT attachment="MySQLOracleMigration.tar" attr="" comment="source files" date="1207037747" name="MySQLOracleMigration.tar" path="MySQLOracleMigration.tar" size="491520" stream="MySQLOracleMigration.tar" user="Main.LanaAbadie" version="1"

Revision 52008-01-24 - LanaAbadie

Line: 1 to 1
 
META TOPICPARENT name="DataManagementTop"
Show Children Hide Children
<!--/twistyPlugin twikiMakeVisibleInline-->

<!--/twistyPlugin-->
Data Management
Main
Talks
Components
FTS
LFC
DPM
lcg_util/GFAL
Medical
Last Page Update
LanaAbadie
2008-05-14

<!--
DataManagementDBMigration's Children
 
-->
Line: 19 to 19
 
  • create a new directory
  • download the tar file (available at the bottom of the page)
Changed:
<
<
  • unzip the tar (tar xzvf).Omit the complaints. It is composed of 3 files (readme, config_file.data and MigrateLFC)
>
>
  • unzip the tar (tar xzvf).Omit the complaints. It is composed of :
    • src directory with all the sources
    • incl directory with the header
    • readme file (similar to the wiki page)
    • output directory (config_file.data to be filled in and the application MigrateLFC will be here)
    • Makefile (must be edited to put the correct location of the oracle and mysql lib)
 
  • fill in the config_file with the proper information. Each entry must be terminated by ; (a semi column)
  • Add to the LD_LIBRARY_PATH, the path to liboci.so and to libmyslqclient.so
  • chmod +x MigrateLFC
Line: 38 to 43
  -- LanaAbadie - 07 May 2007
Changed:
<
<
META FILEATTACHMENT attachment="MigrationMySQLOracle.tgz" attr="" comment="Application to migrate a table schema from MySQL to Oracle" date="1178526293" name="MigrationMySQLOracle.tgz" path="MigrationMySQLOracle.tgz" size="116682" stream="MigrationMySQLOracle.tgz" user="Main.LanaAbadie" version="1"
>
>
META FILEATTACHMENT attachment="MySQLOracleMigration.tar" attr="" comment="source code to migrate a MySQL DB to an Oracle DB" date="1201183987" name="MySQLOracleMigration.tar" path="MySQLOracleMigration.tar" size="133120" stream="MySQLOracleMigration.tar" user="Main.LanaAbadie" version="1"

Revision 42007-08-29 - GavinMcCance

Line: 1 to 1
 
META TOPICPARENT name="DataManagementTop"
Added:
>
>
Show Children Hide Children
<!--/twistyPlugin twikiMakeVisibleInline-->

<!--/twistyPlugin-->
Data Management
Main
Talks
Components
FTS
LFC
DPM
lcg_util/GFAL
Medical
Last Page Update
LanaAbadie
2008-05-14

<!--
DataManagementDBMigration's Children
 
-->
 

Objectives:

Your LFC/DPM MySQL DB is growing fast and the performance of your DB is decreasing. One solution is to migrate to Oracle. An C-application has been written to permit the site admin to perform this operation.

Revision 32007-06-14 - LanaAbadie

Line: 1 to 1
 
META TOPICPARENT name="DataManagementTop"

Objectives:

Your LFC/DPM MySQL DB is growing fast and the performance of your DB is decreasing. One solution is to migrate to Oracle.
Line: 17 to 17
 
  • create a new directory
  • download the tar file (available at the bottom of the page)
Changed:
<
<
  • unzip the tar. It is composed of 3 files (readme, config_file.data and MigrateLFC)
>
>
  • unzip the tar (tar xzvf).Omit the complaints. It is composed of 3 files (readme, config_file.data and MigrateLFC)
 
  • fill in the config_file with the proper information. Each entry must be terminated by ; (a semi column)
  • Add to the LD_LIBRARY_PATH, the path to liboci.so and to libmyslqclient.so
  • chmod +x MigrateLFC

Revision 22007-06-14 - SophieLemaitre

Line: 1 to 1
 
META TOPICPARENT name="DataManagementTop"

Objectives:

Your LFC/DPM MySQL DB is growing fast and the performance of your DB is decreasing. One solution is to migrate to Oracle.
Line: 15 to 15
 

Installation

Changed:
<
<
- create a new directory - download the tar file (available at the bottom of the page) - unzip the tar. It is composed of 3 files (readme, config_file.data and MigrateLFC) - fill in the config_file with the proper information. Each entry must be terminated by ; (a semi column) - Add to the LD_LIBRARY_PATH, the path to liboci.so and to libmyslqclient.so - chmod +x MigrateLFC - launch the application ./MigrateLFC
>
>
  • create a new directory
  • download the tar file (available at the bottom of the page)
  • unzip the tar. It is composed of 3 files (readme, config_file.data and MigrateLFC)
  • fill in the config_file with the proper information. Each entry must be terminated by ; (a semi column)
  • Add to the LD_LIBRARY_PATH, the path to liboci.so and to libmyslqclient.so
  • chmod +x MigrateLFC
  • launch the application ./MigrateLFC
  if one error occurs, the policy is to drop the Oracle schema and DB and goes to the initial state.

Revision 12007-05-07 - LanaAbadie

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="DataManagementTop"

Objectives:

Your LFC/DPM MySQL DB is growing fast and the performance of your DB is decreasing. One solution is to migrate to Oracle. An C-application has been written to permit the site admin to perform this operation. So the application creates the oracle schema using the LFC/DPM table schema script (which should map the LFC MySQL, i.e. same version).

Prerequisites:

  • Linux OS
  • mysqlclient
  • sqlplus
  • sqlloader
  • OCI (oracle instant client)
  • the sql script which creates and drops the Oracle schema (should match the MySQL schema)
  • The LFC service should be stopped

Installation

- create a new directory - download the tar file (available at the bottom of the page) - unzip the tar. It is composed of 3 files (readme, config_file.data and MigrateLFC) - fill in the config_file with the proper information. Each entry must be terminated by ; (a semi column) - Add to the LD_LIBRARY_PATH, the path to liboci.so and to libmyslqclient.so - chmod +x MigrateLFC - launch the application ./MigrateLFC

if one error occurs, the policy is to drop the Oracle schema and DB and goes to the initial state.

Files

The application generates log files which give information about loading data. There is also a log file for the application (MigrateLFC_logfile.log). If the migration has been successful, all the log files can be deleted. This operation has to be done manually.

Remark

The application does not drop the MySQL DB even if the application is successful.

-- LanaAbadie - 07 May 2007

META FILEATTACHMENT attachment="MigrationMySQLOracle.tgz" attr="" comment="Application to migrate a table schema from MySQL to Oracle" date="1178526293" name="MigrationMySQLOracle.tgz" path="MigrationMySQLOracle.tgz" size="116682" stream="MigrationMySQLOracle.tgz" user="Main.LanaAbadie" version="1"
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback