Forgot password of old Siebel DBF file sse_data.dbf

If you have an old Siebel database and you have forgotten the user id and password you can execute below set of command on that dbf to get your user id created on the dbf. Please find the steps as below.

Steps:

1)      Copy the .dbf to Tools\LOCAL

2)      Launch dbisqlc.exe from tools\bin

UserName = DBA

Password = ENTRPRISENAME

Click On Database Tab -> Select Database File as the .dbf in the Tools\LOCAL

Click on OK

3)      Once connected run below mentioned command.

grant connect to SSE_ROLE

grant connect to USERNAME identified by PASSWORD

grant connect to SIEBEL identified by PASSWORD

grant group to SSE_ROLE

grant membership in group SSE_ROLE to USERNAME

Commit

NOTE: USERNAME & PASSWORD Need to be in CAPITAL CASE

4)      Make environment specific changes in your Tools.cfg and create a local DSN to connect the .dbf file

DBCHCK utility to verify if physical schema is in sync with repository

DBCHCK verifies that the physical schema is in sync with repository

D:\sba81\siebsrvr\BIN\dbchck /u sadmin /p sadmin /s SBA81ENT_DSN /dict /all /r "Siebel Repository" /t SIEBEL /l D:\Automation\dbchck.log

The output on command prompt will be shown as below

dbchck: Logging into source "SBA81ENTMBA_DSN" as user "sadmin"...

dbchck: Connected to Oracle (table owner: SIEBEL, schema version: 45.19.0.176).

dbchck: Loading application dictionary (repository: Siebel Repository) ...

dbchck: Identified 3730 tables (0 columns) to check.

dbchck: S_ASSET checking completed: 2 checks failed.

dbchck: S_CONTACT checking completed: 3 checks failed.

dbchck: S_EVT_ACT checking completed: 7 checks failed.

dbchck: S_OPTY checking completed: 2 checks failed.

dbchck: S_ORDER checking completed: 3 checks failed.

dbchck: S_ORG_EXT checking completed: 1 check failed.

dbchck: S_PARTY_REL checking completed: 2 checks failed.

dbchck: Checking completed: 20 checks failed in 7 tables.

Output from Log File

2014-07-21 13:59:05        SQLstyle is 'Oracle'

2014-07-21 13:59:05        SARM is OFF -change param SARMLevel to enable

2014-07-21 13:59:05        SARM Client is OFF -change param SARMClientLevel to enable

2014-07-21 13:59:05        SARM is OFF -change param SARMLevel to enable

2014-07-21 13:59:05        SARM Client is OFF -change param SARMClientLevel to enable

2014-07-21 13:59:05        SARM is OFF -change param SARMLevel to enable

2014-07-21 13:59:05        SARM Client is OFF -change param SARMClientLevel to enable

2014-07-21 13:59:43        Failure: Dictionary for S_ASSET different from physical schema

2014-07-21 13:59:43        1    Physical column X_BRCL_NIMBLE_MASTER_ID not in the dictionary.

2014-07-21 13:59:43        2    Physical column X_BRCL_NIMBLE_PAO_ID not in the dictionary.

2014-07-21 14:00:28        Failure: Dictionary for S_CONTACT different from physical schema

2014-07-21 14:00:28        1    Physical column X_BRCL_NIMBLE_FCON_FAX not in the dictionary.

2014-07-21 14:00:28        2    Physical column X_BRCL_NIMBLE_SCON_EMAIL not in the dictionary.

2014-07-21 14:00:28        3    Physical column X_BRCL_NIMBLE_SCON_FAX not in the dictionary.

2014-07-21 14:01:22        Failure: Dictionary for S_EVT_ACT different from physical schema

2014-07-21 14:01:22        1    Dictionary different from physical schema for index S_EVT_ACT_F10:

2014-07-21 14:01:22                        dictionary: (TARGET_OU_ID APPT_START_DT ROW_ID)

2014-07-21 14:01:22                        physical:   (TARGET_OU_ID APPT_START_DT ROW_ID)

2014-07-21 14:01:22        2    Dictionary different from physical schema for index S_EVT_ACT_M10:

2014-07-21 14:01:22                        dictionary: (TARGET_OU_ID TEMPLATE_FLG APPT_START_DT)

2014-07-21 14:01:22                        physical:   (TARGET_OU_ID TEMPLATE_FLG APPT_START_DT)

2014-07-21 14:01:22        3    Dictionary different from physical schema for index S_EVT_ACT_M11:

2014-07-21 14:01:22                        dictionary: (EVT_STAT_CD EVT_PRIORITY_CD APPT_START_DT)

2014-07-21 14:01:22                        physical:   (EVT_STAT_CD EVT_PRIORITY_CD APPT_START_DT)

2014-07-21 14:01:22        4    Dictionary different from physical schema for index S_EVT_ACT_M2:

2014-07-21 14:01:22                        dictionary: (CREATED_BY TODO_PLAN_START_DT OWNER_PER_ID)

2014-07-21 14:01:22                        physical:   (CREATED_BY TODO_PLAN_START_DT OWNER_PER_ID)

2014-07-21 14:01:22        5    Dictionary different from physical schema for index S_EVT_ACT_M3:

2014-07-21 14:01:22                        dictionary: (TODO_DUE_DT)

2014-07-21 14:01:22                        physical:   (TODO_DUE_DT)

2014-07-21 14:01:22        6    Dictionary different from physical schema for index S_EVT_ACT_M6:

2014-07-21 14:01:22                        dictionary: (OWNER_PER_ID APPT_START_DT)

2014-07-21 14:01:22                        physical:   (OWNER_PER_ID APPT_START_DT)

2014-07-21 14:01:22        7    Dictionary different from physical schema for index S_EVT_ACT_M8:

2014-07-21 14:01:22                        dictionary: (TODO_PLAN_START_DT)

2014-07-21 14:01:22                        physical:   (TODO_PLAN_START_DT)

2014-07-21 14:02:39        Failure: Dictionary for S_OPTY different from physical schema

2014-07-21 14:02:39        1    Dictionary different from physical schema for index S_OPTY_M1:

2014-07-21 14:02:39                        dictionary: (SUM_EFFECTIVE_DT)

2014-07-21 14:02:39                        physical:   (SUM_EFFECTIVE_DT)

2014-07-21 14:02:39        2    Dictionary different from physical schema for index S_OPTY_M55:

2014-07-21 14:02:39                        dictionary: (SECURE_FLG CONSUMER_OPTY_FLG SUM_EFFECTIVE_DT)

2014-07-21 14:02:39                        physical:   (SECURE_FLG CONSUMER_OPTY_FLG SUM_EFFECTIVE_DT)

2014-07-21 14:02:50        Failure: Dictionary for S_ORDER different from physical schema

2014-07-21 14:02:50        1    Dictionary different from physical schema for index S_ORDER_M3:

2014-07-21 14:02:50                        dictionary: (ORDER_DT)

2014-07-21 14:02:50                        physical:   (ORDER_DT)

2014-07-21 14:02:50        2    Dictionary different from physical schema for index S_ORDER_M4:

2014-07-21 14:02:50                        dictionary: (ORDER_CAT_CD ORDER_DT)

2014-07-21 14:02:50                        physical:   (ORDER_CAT_CD ORDER_DT)

2014-07-21 14:02:50        3    Dictionary different from physical schema for index S_ORDER_M7:

2014-07-21 14:02:50                        dictionary: (CRDT_STATUS_CD ORDER_DT)

2014-07-21 14:02:50                        physical:   (CRDT_STATUS_CD ORDER_DT)

2014-07-21 14:02:57        Failure: Dictionary for S_ORG_EXT different from physical schema

2014-07-21 14:02:57        1    Dictionary different from physical schema for index S_ORG_EXT_F1:

2014-07-21 14:02:57                        dictionary: (LAST_UPD)

2014-07-21 14:02:57                        physical:   (LAST_UPD)

2014-07-21 14:03:08        Failure: Dictionary for S_PARTY_REL different from physical schema

2014-07-21 14:03:08        1    Dictionary different from physical schema for index S_PARTY_REL_U1:

2014-07-21 14:03:08                        dictionary: (PARTY_ID REL_TYPE_CD REL_PARTY_ID START_DT ONFLICT_ID) unique

2014-07-21 14:03:08                        physical:   (PARTY_ID REL_TYPE_CD REL_PARTY_ID START_DT ONFLICT_ID) unique

2014-07-21 14:03:08        2    Dictionary different from physical schema for index S_PARTY_REL_U2:

2014-07-21 14:03:08                        dictionary: (REL_PARTY_ID REL_TYPE_CD PARTY_ID START_DT ONFLICT_ID) unique

2014-07-21 14:03:08                        physical:   (REL_PARTY_ID REL_TYPE_CD PARTY_ID START_DT CONFLICT_ID) unique