RE: Oracle 9i Lite - any help please?

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani
  INET: saira_somani_at_yahoo.com

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).