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
9392
March 23, 2005 11:15AM
4438
March 23, 2005 10:01PM
11245
March 28, 2005 09:17PM
4399
March 30, 2005 04:47PM
Re: Importing from Oracle into MySQL
6032
April 25, 2005 08:35AM
4056
May 28, 2007 03:22AM
3986
May 31, 2007 12:20PM
3845
December 08, 2008 06:11PM
4132
February 03, 2007 01:36AM
4065
January 22, 2007 12:48AM
4814
March 30, 2005 06:13PM
3182
April 12, 2009 07:59AM
4290
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.