Difference: DataManagementDBMigration (6 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"
 
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