Home » RDBMS Server » Server Administration » NoBody is there for MIgration
icon5.gif  NoBody is there for MIgration [message #201014] Thu, 02 November 2006 04:26 Go to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

I am migrating MySql to Oracle use omwb. My MySql versions are 4.1.12 max and MySql 5.0.22Max. Oracle version is Oracle 9i.

I during migration process I am failing to connect to the source database, my omwb fails after giving this message.

OMWB error - Database not found: Make sure hostname, port and server are correctly specified.for the version of MySQL you wish to connect to.

And Checking the log of the OMWB log/Error.log suggests the following error to connect with the database.

LOG -
oracle.mtg.migration.MigrationInitException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver:java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

I have tried using omwb and omwb_mysql5_beta using various types of Connector J for mysql. includeing 3.1.12,3.1.14,3.1.8a,3.1.9,5.0.1 and many other. But all the drivers are unable to connect to the source database. Gone through all kind of errors available in the Oracle Forum.

Read so many problems on net but didnt got a single satisfactory answer.

Embarassed
Re: NoBody is there for MIgration [message #201517 is a reply to message #201014] Sun, 05 November 2006 08:42 Go to previous messageGo to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

Hi ,
I think that nobody is there in this forum who have used MySQL migration to oracle using OMWB.

This was my second request and I didnt get any reponse till the time.

Hoping that there is somebody who can help me on this issue.

with Regards
Amit Nanote
Re: NoBody is there for MIgration [message #201522 is a reply to message #201517] Sun, 05 November 2006 09:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
i hv no idea about mysql migration but i hope below link help you.
http://www.google.ae/search?hl=ar&q=Migration+mysql+%2B+oracle+%2Bomwb&meta=

Re: NoBody is there for MIgration [message #201586 is a reply to message #201014] Sun, 05 November 2006 23:46 Go to previous messageGo to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

hi user52
Thank you for replying....
I have tried all the forum.oracle.com's solution for the same problem. But it wouldnot working.

With Regards
Amit Nanote
Re: NoBody is there for MIgration [message #201599 is a reply to message #201586] Mon, 06 November 2006 00:44 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Are you able to call oracle support if yes. then don't waste time just call oracle support.

hope you solve ur problem very soon.
Cacheloader Exception [message #220418 is a reply to message #201014] Tue, 20 February 2007 10:50 Go to previous messageGo to next message
kumarkovela
Messages: 6
Registered: March 2005
Location: delhi, india
Junior Member

WHy I'm getting this error


## Detail 0 ## oracle.apps.jtf.cache.CacheLoaderNotFoundException at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:3236) at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:3203) at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:248) at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:974) at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:360) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:225) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:184) at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:147) at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1107) at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:971) at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:940) at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:907) at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:570) at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:1025) at oracle.apps.fnd.common.WebAppsContext.init(WebAppsContext.java:3486) at oracle.apps.fnd.common.WebAppsContext.(WebAppsContext.java:537) at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:346) at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:144) at oracle.apps.fnd.framework.CreateIcxSession.createSession(CreateIcxSession.java:80) at _test__fwktutorial._jspService(test_fwktutorial.jsp:45) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Thread.java:534) oracle.apps.jtf.cache.CacheLoaderNotFoundException at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:3236) at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:3203) at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:248) at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:974) at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:360) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:225) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:184) at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:147) at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1107) at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:971) at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:940) at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:907) at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:570) at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:1025) at oracle.apps.fnd.common.WebAppsContext.init(WebAppsContext.java:3486) at oracle.apps.fnd.common.WebAppsContext.(WebAppsContext.java:537) at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:346) at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:144) at oracle.apps.fnd.framework.CreateIcxSession.createSession(CreateIcxSession.java:80) at _test__fwktutorial._jspService(test_fwktutorial.jsp:45) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Thread.java:534
Re: Cacheloader Exception [message #220426 is a reply to message #220418] Tue, 20 February 2007 12:17 Go to previous message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Because you typed an invalid command at the SQL> prompt? Who knows.

Why did I get this error:

ORA-04044: procedure, function, package, or type is not allowed here



Previous Topic: find default user
Next Topic: varchar2 accepts spaces in Oracle 10g
Goto Forum:
  


Current Time: Fri Dec 09 10:00:12 CST 2016

Total time taken to generate the page: 0.08808 seconds