cancel
Showing results for 
Search instead for 
Did you mean: 

SAP System start fails after changing Schema Password

Former Member
0 Kudos

Hi Experts,

We are performing Unicode Conversion/migration and for which we are taking the export of the system. It is throwing an error saying Schema password should be more than 5 characters.

Our password is SAP. When we try to change this password from brtools, it is getting changed successfully and it is updating the table "OPS$<SID>ADM.SAPUSER" also.

But the system fails to start. R3trans -d throws return code 12. Our system is accepting only the default password "SAP" not anything else.

We are on Windows/Oracle 11.2

Please let me know how to change this password.

Regards,

Surendra

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi All,

Thanks for your replies.

My issue is resolved. It was a problem with the user OPS$<domain_name>\<SID>ADM. This user is missing in our system.

1.I created this user as per the notes 400241 and 50088.

2. Dropped the existing SAPUSER table and recreated it with the above user as owner

3. Gave necessary previleges to OPS$<domain_name>\<SID>ADM and OPS$<domain_name>\SAPSERVICE<SID> users

Now the system is up and running

Thanks,

Surendra

Answers (3)

Answers (3)

Former Member
0 Kudos

try this command with ora<sid>  user:

brconnect -c -u / -f chpass -o <SAPSCHEMA> -p sap

Former Member
0 Kudos

try updating the brtools.

after using brtools to change schema password, login via sqlplus with SAP<SID> user and new password to verify it.

Regards, Henry

former_member215961
Contributor
0 Kudos

Hi,

Brtools become an usesfull tool and you can change it at instance management seccion.

Let me know if you find it.

Cheers