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.
Opening it will bring up the window shown below.
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.
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.