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

Report message to a moderator

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

Report message to a moderator

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=

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Re: Cacheloader Exception [message #220426 is a reply to message #220418] Tue, 20 February 2007 12:17 Go to previous message
joy_division
Messages: 4963
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:34:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.