SAP NW 7.40 installation with Oracle 11.2

[divyanshu_srivastava3]

Hi

I am installing SAP NW ABAP 7.4 with Oracle 11.2 on Linux SuSE.

The installation has passed the initial stages and right now stuck on 'Perform Oracle post-load activities' step (Phase 22 of 36).

Actually, I mistakenly chose the master password with '@' in it. Now brconnect is failing in this step with an error code 5 with the below logs:

""

BRCONNECT 7.40

BRCONNECT timestamp xx.xxx..xx

Changing password for database user SAPSR3 ...

Invalid character '@' in database password

Changing password for user SAPSR3 failed.

""

I have also tried changing the password for SAPSR3 user using BRTOOLS and successfully done that. I can connect to the database with the user SAPSR3 and the new password which I gave. But somehow when I retry on the SWPM screen, it again gives me the same error as mentioned above.

Has anyone seen this issue before? Can someone give some resolution for this urgently...

Regards

SAPINST_DEV.txt.zip

[former_member185239 · Accepted solution]

Hi Divyanshu

The error is simple, but you have to run the sapinst once again.

The master password you have entered is containing @.

Now SAPINST is trying to change the default password of SAPSR3 to master password and database is not allowing it.

Show in that case , you need to check the password policy of oracle.

or

start the sapinst as a new installation and give the master password without @.

Sorry didn't get the error at that time.

With Regards

Ashutosh Chaturvedi

[former_member185239 · Accepted solution]

Hi Divyanshu,

Run the below sql command

ALTER PROFILE SAPUPROF LIMIT PASSWORD_VERIFY_FUNCTION NULL

Then try to change the password of the user

sqlplus /nolog

connect /as sysdba

alter user SAPSR3 identified by welcome@

if it alter the password , then retry the sapinst.

Also checked the below sapnote

1522952 - Password Complexity Verification Function

1519872 - SAP Database User Profile SAPUPROF

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi All,

We have solved the issue by editing the control.xml file in the installation directory:

change the parameter ad.password to some password without @ or any preferably special character.

Please reward me point if it helps you guys

[divyanshu_srivastava3]

Thanks all, I have re-installed it.

[janos_mucsi-besze]

Hi Divyanshu,

The passwords (along with other things) are maintained in keydb.xml file. You have to search for the corresponding entry and overwrite the already encrypted password. But take care of the consistency please. Make sure you copied the original keydb.xml beforehand to have a bakcup of it.

Regards,

János