BR1628E Invalid character '@' in database password During Installation Phase

[sandeep_kumar60]

HI all

Iam installing Net weaver 7.4 SR2 on Windows Server2013R2 machine with orcale database.

My master password consist of @ symbol,

I was stuck in the Middle of installation of  Perform oracle Post load Step.

During this step installation is throwing an error , i checked br connect.log file , the log file is as below

BR0801I BRCONNECT 7.40 (11)

BR0280I BRCONNECT time stamp: 2014-10-15 19:42:47

BR0828I Changing password for database user SAPSR3 ...

BR1628E Invalid character '@' in database password

BR0832E Changing password for user SAPSR3 failed

BR0280I BRCONNECT time stamp: 2014-10-15 19:42:47

BR0804I BRCONNECT terminated with errors

i stoped and closed the sapinst and other sap process.

I tried to change the password using Sql plus and brtools by using the below commands

sql> alter user SAPSR3 identified by sap;

user alterd.

c:\Users\sapadmin>brconnect -u / -c -f chpass -o SAPSR3 -p sap

BR0801I BRCONNECT 7.40 (11)

BR0280I BRCONNECT time stamp: 2014-10-15 19:41:00

BR0828I Changing password for database user SAPSR3 ...

BR0280I BRCONNECT time stamp: 2014-10-15 19:41:00

BR0829I Password changed successfully in database for user SAPSR3

BR0830I Password changed successfully in table SAPSR3.SAPUSER for user SAPSR3

BR0280I BRCONNECT time stamp: 2014-10-15 19:41:00

BR0802I BRCONNECT completed successfully

C:\Users\sapadmin>brconnect -u / -c -f chpass -o SAPSR3 -p sap

BR0801I BRCONNECT 7.40 (11)

BR0280I BRCONNECT time stamp: 2014-10-15 19:41:00

BR0828I Changing password for database user SAPSR3 ...

BR0280I BRCONNECT time stamp: 2014-10-15 19:41:00

BR0829I Password changed successfully in database for user SAPSR3

BR0830I Password changed successfully in table SAPSR3.SAPUSER for user SAPSR3.

I restarted the Installation , but the same error persists,

can any one guide how to get rid of this Special character issue , requesting your guidance in resolving the above error.

Regards

Sandeep

[Former Member · Accepted solution]

Hi sandeep,

i know this post is on the past. but i successfully solved this problem by editing control.xml file

search // get ABAP user informations comment,

then add variable that i marked by read square ( i prefer to backup your control.xml before doing this)

and inserted with string password

save the file and then stop the installation.

started again with the same installation then choose continue with old configuration

i hope this work also to you guys

NB : work with 70SWPM10SP06

Best Regards,

Rony Jusuf

[Former Member · Accepted solution]

Thanks roni josuf

it's working for me and saved lot of time.

[Former Member · Accepted solution]

Hi Rony,

I know, its late reply.. but your solution helped me to resolve my issue.

Thanks.

[musharaffkhan · Accepted solution]

Thank you Rony Jusuf

It resolved my issue.

Great effort.

[Former Member · Accepted solution]

Hi ! Jusuf

I am facing the same issue and tried with change in conrtol.xml file

as  ad.password = "xxxx@xxxx" my old password and even ad.password = "xxxxx" new password without special characters

but getting same error in log

Please let me know if any other way to work

regards

Santosh

[Former Member · Accepted solution]

Hi Santosh,

Did you resolve it? I confroned the same situation as yours. After modifying control.xml, I restart installation with old option. But getting same error in new generated log.

I had changed pwd for database user SYS,SYSTEM and SAPSR3. Any suggestion will be highly appreciated!

[former_member140160 · Accepted solution]

Dear Rony Jusuf,

Thanks a lot editing control.xml file is working for me also

Thanks

Shehab ElDin Ahmed

[daniel_blata · Accepted solution]

Thank you, saved alot of time.

[Former Member]

Hi

In my case (EHP7 for ERP7 ABAP R2) there were 4 different control.xml files below xml7xx , ..dss ,..hdb, and ..sbc folders.

I have modified all of them. Also I have modified password of user SAPSR3 , sys and system inside oracle. Finally I modified the passowrd of brconnect -u / -c -f chpass -o SAPSR3 -p pass

then I run the sapinst again. unfortunatly it once again hang in post-load activities. I don't have any error but just nothing happen in sapinst (waiting 4 hours).

Do you think I'm wrong in any step?

Regard,

[Former Member]

Hi Hamid,

When you restarted the installation, how did you do this?

If you continue from the last step it will keep the existing parameters.

It would be better to restart the installation completely, after starting sapinst you will be prompted to run a new or continue from previous. If you want to enter new parameters you should start again with new.

[jawedsib]

Thanks roni josuf

great effort

[janos_mucsi-besze]

Hi Sandeep,

Besides CONTROL.XML modification, there is no other solution, then to restart the whole installation with SWPM. Password maintained in CONTROL.XML contains the special (@) character. This has to be removed and changed to the password in DB to be able to proceed further.

Regards,

János

[Former Member]

Hi,

Uninstallation will work. and start a new installation. Also refer the installation doc for more details on password and other pre-requisites

Br,

Nikhil

[divyanshu_srivastava3]

You have to re-start a installation.

This issue was addressed before also by many others.

No support for '@'.. I, my self was a victim of this

Regards,

[sandeep_kumar60]

HI Austosh and srivastav

To Start the Installation from scratch, how can i delete the files and registry created by oracle and SAP Installation during this process.

As the installation is in complete , i think i cant use the option of Uninstall SAP Instance from the SAP INST.

So how to clean up my system to reinstall SAP with out any Operating systems , or registry permission etc etc errors.

Regards

Sandeep

[former_member186066]

Hi Sandeep,

You can use the Uninstall option.

Once the uninstallation finishes, perform the below:

1. Delete the folders under usr

2. Delete the SAP system related system variables(if any).

3. Delete SAP related services from command prompt.

Regards,

Ankit

[sandeep_kumar60]

HI Ankit

Thanks for the reply,i am aware with  the uninstall option of SAPINST.

But my concern is my installation is not yet complete , so does the uninstall option works out ?

Regards

Sandeep

[former_member186066]

Yes, it will work.

[former_member185239]

Hi Sandeep,

Oracle 11g does not support the special character @.

So you are getting the error. So you need to change the password whithout using @ special character.

You need to start the installation from scratch as you have given the @ in  master password.

With Regards

Ashutosh Chaturvedi