Siebel Offline Database Migration - Oracle

Posted on 2011-10-19
Last Modified: 2012-05-12
I have one machine with Siebel installed and a mobile database extracted for offline use. I need to backup the database from this machine and migrate it to a new machine with Siebel installed. The user should then be able to log into on the new machine and access their database.

I am copying the following over

C:\Program Files\Siebel\8.0\web client\LOCAL\dicdata.dat
C:\Program Files\Siebel\8.0\web client\LOCAL\sse_data.dbf
C:\Program Files\Siebel\8.0\web client\BIN\mwc_storage.cfg
c:\Program Files\Siebel\8.0\web client\LOCAL\Inbox
c:\Program Files\Siebel\8.0\web client\LOCAL\Outbox

When I log in Siebel offline on the new machine I get the following

"the user id or password that you entered is incorrect. please check the spelling and try again"

This is what I am now investigating. Thanks
Question by:bear2001k
    LVL 3

    Expert Comment

    What is the version of Siebel in use and what is the operating system of the old and new machine?

    is mwc_storage.cfg the client config file being used in both places

    Author Comment

    OS is Windows XP Tablet Edition on both machines
    mwc_storage.cfg is the client config file being used in both places
    Siebel Version 8.0
    LVL 3

    Expert Comment

    Have you confirmed the path to local db is exactly the same on all the machines? It seems unlikely this is the issue since if not found Siebel should prompt you if you want to download a local database.

    When moving my local db to another machine I have never moved anything but the dbf.

    Tablet OS could be in an issue here.

    LVL 12

    Accepted Solution

    With Siebel 8.0,  I have encountered issues with connectivity when I have not set up an ODBC source for the target database.     On previous versions,  I think this was only necessary for Tools operations but seems to be required for all connectivity now.

    The [Siebel] section of your cfg file probably contains something like:
    LocalDbODBCDataSource    = SEAW Local Db default instance

    Try setting up the ODBC source to point to your local database and test the login.  At the very least it will eliminate concerns about the database/password and you can then focus on your siebel cfg file.   At best, it may fix the problem.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows how to recover a database from a user managed backup

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now