Re: Importing from Oracle into MySQL
Hi, seems I have a similar problem with the tool at this stage.
Well, it says Network Adapter could not establish the connection, but if I connect to the Oracle database via sql*plus it works all fine.
Fabian
Details given:
Connecting to source database and retrieve schemata names.
Opening connection ...
Connection jdbc:oracle:thin:xxxxxxxxxxxxxxxxxxxxxxxxxx
Initializing JDBC driver ...
Driver class oracle.jdbc.OracleDriver
The list of schema names could not be retrieved (error: 0).
E/A-Exception: The Network Adapter could not establish the connection
Details:
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringOracle.getSchemata(Unknown Source)
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)
Subject
Views
Written By
Posted
9562
March 23, 2005 11:15AM
4592
March 23, 2005 10:01PM
11414
March 28, 2005 09:17PM
4790
March 30, 2005 04:47PM
Re: Importing from Oracle into MySQL
6164
April 25, 2005 08:35AM
4138
May 28, 2007 03:22AM
4088
May 31, 2007 12:20PM
3963
December 08, 2008 06:11PM
4241
February 03, 2007 01:36AM
4154
January 22, 2007 12:48AM
5145
March 30, 2005 06:13PM
3274
April 12, 2009 07:59AM
4377
February 03, 2007 01:33AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.