Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 17th, 2012  |  syntax: None  |  size: 1.75 KB  |  hits: 27  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Migration from Oracle to MySql
  2. Connecting to source database and retrieve schemata names.
  3. Initializing JDBC driver ...
  4. Driver class Oracle Thin JDBC Driver using Service
  5. Opening connection ...
  6. Connection jdbc:oracle:thin:system/**********@//127.0.0.1:1521/OracleServiceXE
  7. The list of schema names could not be retrieved (error: 0).
  8. ReverseEngineeringOracle.getSchemata :Listener refused the connection with the following error:
  9. ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
  10. The Connection descriptor used by the client was:
  11. //127.0.0.1:1521/OracleServiceXE
  12.  
  13. Details:
  14. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
  15. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:280)
  16. oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328)
  17. oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:361)
  18. oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
  19. oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  20. oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
  21. java.sql.DriverManager.getConnection(Unknown Source)
  22. java.sql.DriverManager.getConnection(Unknown Source)
  23. com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
  24. com.mysql.grt.modules.ReverseEngineeringOracle.getSchemata(ReverseEngineeringOracle.java:43)
  25. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  26. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  27. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  28. java.lang.reflect.Method.invoke(Unknown Source)
  29. com.mysql.grt.Grt.callModuleFunction(Unknown Source)
  30.        
  31. alter system set service_name = 'OracleServiceXE';
  32.        
  33. jdbc:oracle:thin:@localhost:1521:xe
create a new version of this paste RAW Paste Data