Description:
i youse the mysql migration toolkit for the first time, so there`s the possibility for mistakes in my preparation.
My invorenment:
MySQL migration toolkit version 1.1.12 with windows2000 professional SP4 and patches.
The mysql database running on the same machine is version 5.0.45-community-nt.
The oracle Database (oracle 8.x or 9.x) is on a remote machine.
The network access is via isdn (DFÜ).
JRE (JAVA): Version JAVA(TM)6 update 4 paralel J2SE Runtime environment 5.0 Update 9
Java oracle Driver: ojbc14
(I testet 2 oracle jdbc drivers :
1. ojdbc14.jar for oracle 10 ==> Migartion appends with: invalid username/password
2. ojdbc14.jar for oracle 9 ==> Migration appends with the error message descriptet.)
Question: is there another ojdbc?.jar available suitable for oracle 7/8 ????
The migration toolkit accepts only a file with the name ojdbc14.jar !
Theres`s no service name given, but the expression of the Instanz.
So in the migration tool the connection entered is:
Source database: Oracle Database Server
Driver: Oracle Thin JDBC Driver using SID
SID: XYZ (expression of instance correct ???)
Hostname: <<IP 111.222.333.444>>
port-number: 1526 (instead of 1521 default)
username: <<name of the oracle account with administrative rights>>
Password: <<password>>
The connection to mysql om the local PC could be established as tested.
During connection the following error message occures:
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Oracle Thin JDBC Driver using SID
Opening connection ...
Connection jdbc:oracle:thin:<<user>>/<<passwd>>@111.222.333.44:1526:<<instanz>>
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringOracle.getSchemata :ORA-01010: invalid OCI operation
Details:
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:243)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:304)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:361)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringOracle.getSchemata(ReverseEngineeringOracle.java:43)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)
I tested is with another JAVA-environment, but also theres's the same error.
How to repeat:
please repeat on E-mail:
goetz-berger@versanet.de
Suggested fix:
develop a workaround or a jdbc-driver-suit for old oracle 7/8 database servers.
this would be very important in case of a lot of companies migrating fom an old oracle-platform to mysql !
