| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 9i Lite - any help please?
Saira,
Excellent feedback. I'll forward it to Jacob Christfort and Martin Graf.
Martin, by the way, sent me a response to your posting (Jacob forwarded my message to Martin). See below.
Best regards,
Mogens
In deed, Oracle9i Lite has over 10'000 posted messages on OTN, which makes it #3 of all Oracle Products. This outstanding number of messages produces a lot of work for us, which is why you might experience slower than expected turn around for certain postings. We apologize for the delay but you can rest assured that we do everything in our power to resolve your issues.
It looks like data does not get applied to the Oracle Lite (PROCESSING) database. Client changes are sent to the Mobile Server (SENDING). The client also received data from the server (RECEIVING). It might be that replication never finishes (commits) the transaction (since it hangs), which is why MGP might not pick up the changes and apply them to the Oracle database.
COMPOSING client data
SENDING client data to the Mobile Server
RECEIVING data from the server
PROCESSING (apply) data to the client database
The PK change in one of your application table might actually be the culprit. Please follow the procedure below and let me know if you have further questions.
We recommend to use Oracle9i Lite 5.0.2 release with 5.0.2.3.0 Windows patch (the latest on Windows).
Saira Somani wrote:
>Mogens,
>
>Thank you kindly for forwarding my questions to the head honcho. I would
>be extremely pleased if he responded but not offended if he didn't.
>
>Funny enough, we are currently using Lite with Intermec 700 handhelds
>(StrongARM chipset) running Pocket PC (Windows CE) in hospitals to
>manage supply carts. Interesting business.
>
>So since I have inherited administration of this software, I not an
>expert yet, but quickly finding out where documentation and logging is
>sparse. I find that it is quite difficult to figure out where a problem
>has occurred. Take for example the MSYNC process on the client which
>synchronizes with the repository on the 8i server. Every time the client
>syncs, the client tells me it is successful, even though it isn't.
>Secondly, there is processing that is performed on synchronization - I
>know for a fact that there is data to be "processed", yet this client
>never fulfills that request to "process" the data and as a result,
>changes are not reflected in the repository.
>
>Then take migration. I wanted to upgrade from 5.0.1.X.0 to 5.0.2.X.0 -
>and I found out that I cannot even log into the administrative console.
>And that would be fine, if there was documentation that told me this is
>possible (maybe I missed that PDF, I don't know - too much information,
>too little time).
>
>And how about documentation on the tracing. Especially interpretation of
>the log/trace files - there is no guideline to explain to me what I can
>expect from the logging/tracing (again, maybe it's me for missing that
>PDF but I have searched for many months with little success).
>
>I think it is a good product with many bugs and I think it can be used
>very effectively if administered/configured optimally. I just think that
>there isn't enough expertise out there yet to assist those who have
>decided to go with this product. From an administrative standpoint, I
>find it difficult to grasp how and where errors are occurring. Even more
>difficult is trying to figure out a pattern to the errors. They are
>sporadic, inconsistent, and show no symptoms. Alerts for MGP failing are
>non-existent - don't know when it will go down and when it does, I can't
>explain why.
>
>Overall, I can see it having success in the right environment and with a
>stable release.
>
>Hope this helped but didn't offend any.
>
>Thanks again,
>Saira
>
>-----Original Message-----
>Nørgaard
>Sent: February 6, 2003 1:00 PM
>To: Multiple recipients of list ORACLE-L
>
>Saira,
>
>I've forwarded your message to the CTO of Oracle Lite, my old friend
>Jacob Christfort, whom I know from our days at the National Hospital
>Dormitory in Copenhagen, where we had lots of fun, and where many nurses
>
>lived. Those were the days, but sadly we both ended up working with IT.
>If Jacob responds (he's a rather busy guy) I'll forward the responses to
>
>the list.
>
>Can I ask you what you think of Lite in general? I don't see many sites
>using it, but it looks like a cool thing for the right purpose...
>
>Best regards,
>
>Mogens
>
>Saira Somani wrote:
>
>
>
>>Posted 2 messages in Oracle 9i Lite Forum on Metalink. No responses
>>
>>
>yet.
>
>
>>I'm looking to this list for help on either of these issues. Thanks in
>>advance for your time. Please e-mail me privately
>>(saira_somani_at_yahoo.com) if this is not the proper forum for these
>>issues. Someone out there has to be using this product :-)
>>
>>-----------------------------------------------------------------------
>>
>>
>-
>
>
>>----
>>
>>
>>RDBMS Version: 8.1.7.0.0
>>Operating System and Version: Windows 2000 Server SP3
>>Error Number (if applicable):
>>Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite
>>Product Version: 5.0.1.1
>>
>>MSYNC - records to process yet PROCESSING does not occur
>>
>>We have changed records on the client in offline mode and now want to
>>syncronize with the server. There are records to be processed - yet, in
>>MSYNC, it goes through COMPOSING, SENDING, RECEIVING but no PROCESSING.
>>As a result, our records on the server are not updated. MGP is running,
>>and when we retry, we allow for complete cycles to occur before our
>>
>>
>next
>
>
>>attempt.
>>
>>After trying about 20 times (no kidding), the PROCCESSING bar on the
>>MSYNC screen works.
>>
>>This is unacceptable and not to mention unreliable. Please help. Please
>>also see my previous message on a related issue. Perhaps you can see a
>>connection, I can't as yet.
>>
>>Thanks,
>>Saira
>>
>>-----------------------------------------------------------------------
>>
>>
>-
>
>
>>----
>>
>>
>>
>>RDBMS Version: 8.1.7.0.0
>>Operating System and Version: Windows 2000 Server SP3
>>Error Number (if applicable):
>>Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite
>>Product Version: 5.0.1.1
>>
>>MSYNC sticks on PROCESSING bar
>>
>>Recently we made a change to a table in our repository in 8i - changed
>>
>>
>a
>
>
>>primary key. After this, the application was republished in Oracle 9i
>>Lite and all client databases (Pocket PC Strong ARM) were refreshed
>>(i.e. database was removed from the client and sync'd 3 times before
>>usage).
>>
>>We have noticed that now, after the change, during the MSYNC process,
>>that status bar hangs on the PROCESSING phase of MSYNC. The only way to
>>rid this is by warm booting the PDA and trying it multiple times until
>>it is successful (which sometimes it is and sometimes isn't). However,
>>even when the PROCESSING bar has not completed until the end, the data
>>
>>
>>from the PDA is sent but this is unreliable as all the MSYNC processes
>
>
>>are not complete.
>>
>>This is inefficient. Any suggestions?
>>
>>Saira Somani
>>IT Support/Analyst
>>Hospital Logistics Inc.
>>
>>
>>
>>
>>
>
>
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: mln_at_miracleas.dk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Feb 07 2003 - 15:59:06 CST
 |
 |