dbisqlc.exe – Your gateway to Siebel local database.

Lot of times when working with Siebel we have to change things at database level.  Be it for testing purposes or may be for EIM etc. We use either SQL Developer or TOAD for that purpose. Use of SQL Developer and TOAD is fairly well known and well documented.

But have you ever wondered that how you can make changes to your local sse_data.dbf file.

The first question that comes to our mind is, Why do I need to change something in local database from backend? To answer that question I will put a scenario in front of you.

You need to GET a object from server which is locked by someone else. You do a GET and the copy that you get is being shown locked by that person. Now, how do you make changes to that object? This is where dbisqlc comes in the picture. It is a tool provided by siebel to login to local database.

 The solution of the problem above is to login to local database using dbisqlc and set the locked flag of that object to false. Then login to Siebel Tools and lock it again with your ID.

Dbisqlc.exe file can be found in the following path.

Siebel installation\tools\bin\dbisqlc.exe

Opening it will bring up the window shown below.

Login window to login into local database

Follow the steps given below to open the local database.

  • Supply your local user id and password IN CAPS. Yes, it doesn’t matter what you local password is you have supply it in CAPS.
  • Click on database Tab
  • Click on browse and select your dbf file which will ideally be in Siebel installation\tools\local but you can choose any dbf file that you want.
  • Database password fields

Then click on OK. If your username and password is correct for that dbf then it will open the window shown below.
Siebel Local database window

This means that you have successfully logged in to your local database.

Now I found a pretty good post at Siebel Notes which can come in pretty handy sometimes.

This SQL can help you to change the password for local user in case of need.

16 Responses to dbisqlc.exe – Your gateway to Siebel local database.

  1. Hi Neel,

    I have a doubt pertaining to this topic. Once we obtain the server object using GET and unlock it through dbisql to make further changes, then could we Check In those changes that we have made on the object.
    Please advice .

    Thanks.

  2. Hi Neel,

    I have a doubt pertaining to this topic. Once we obtain the server object using GET and unlock it through dbisql to make further changes, then could we Check In those changes that we have made on the object.
    Please advice .

    Thanks.

  3. Hena,

    you CAN’T checkin a project locked by you locally (without checkout) and even the project/Obj wont available in the checkin list.

    Cheers

  4. Hena,

    you CAN’T checkin a project locked by you locally (without checkout) and even the project/Obj wont available in the checkin list.

    Cheers

  5. I have given task of getting data from Siebel using TIBCO adapter for Siebel. When I tried to import file – 77TIBSiebelAdapterHTTPAgentBusinessService_escript.sif
    using Siebel Tools it gives me error that required field Management State Type not found. It seems that above .sif file is for Siebel 7.7x whereas I am using Siebel 8.0 where that above field newly added. Since I am just beginning to get familier with Siebel, I just want to make some changes to .sif file to add that Management State Type so that import will be successful. How can I do that?
    Where can I get sample .sif file where that management State Type field is used?

  6. I have given task of getting data from Siebel using TIBCO adapter for Siebel. When I tried to import file – 77TIBSiebelAdapterHTTPAgentBusinessService_escript.sif
    using Siebel Tools it gives me error that required field Management State Type not found. It seems that above .sif file is for Siebel 7.7x whereas I am using Siebel 8.0 where that above field newly added. Since I am just beginning to get familier with Siebel, I just want to make some changes to .sif file to add that Management State Type so that import will be successful. How can I do that?
    Where can I get sample .sif file where that management State Type field is used?

  7. Hi,

    Thanks for the post. I have an issue whenever I connect through the dbisqlc, i need to close my application otherwise it gives an error that Database already in use. Is there any parameter by which i can make it work.

    Thanks,
    BB

Leave a Reply

Contribute