Question Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity in Technology Q&A

During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Wed, 18 Nov 2015 07:02:08 GMT

Hi Export,

I am getting error while i am installing Sap Ecc6.0 Ehp 6 at the Phase of Perform ORA Postload Activity.

The error is in sapinst.log

INFO 2015-11-18 12:00:52.549

Removed file /tmp/sapinst_instdir/BS2011/ERP606/AS-ABAP/ORA/CENTRAL/ora_query3_tmporaw220_1.sql.

INFO 2015-11-18 12:00:52.551

Creating file /tmp/sapinst_instdir/BS2011/ERP606/AS-ABAP/ORA/CENTRAL/ora_query3_tmporaw220_1.sql.

INFO 2015-11-18 12:00:53.894

Creating file /tmp/sapinst_instdir/BS2011/ERP606/AS-ABAP/ORA/CENTRAL/brconnect.log.

INFO 2015-11-18 12:00:53.977

Output of /usr/sap/W22/SYS/exe/run/brconnect -u / -c -f chpass -o SAPSR3 -p XXXXXX is written to the logfile brconnect.log.

WARNING 2015-11-18 12:00:54.283

Execution of the command "/usr/sap/W22/SYS/exe/run/brconnect -u / -c -f chpass -o SAPSR3 -p XXXXXX" finished with return code 5. Output:

BR0801I BRCONNECT 7.20 (36)

BR0280I BRCONNECT time stamp: 2015-11-18 12.00.54

BR0828I Changing password for database user SAPSR3 ...

BR1628E Invalid charcter '@' in database password

BR0832E Changing password for user SAPSR3 failed

BR0280I BRCONNECT time stamp: 2015-11-18 12.00.54

BR0804I BRCONNECT terminated with errors

ERROR 2015-11-18 12:00:54.285

CJS-30023 Process call '/usr/sap/W22/SYS/exe/run/brconnect -u / -c -f chpass -o SAPSR3 -p XXXXXX' exits with error code 5. For details see log file(s) brconnect.log.

ERROR 2015-11-18 12:00:55.474

FCO-00011 The step setOraclePasswords with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_Postload|ind|ind|ind|ind|postload|0|NW_Postload_ORA|ind|ind|ind|ind|ora|0|setOraclePasswords was executed with status ERROR ( Last error reported by the step: Process call '/usr/sap/W22/SYS/exe/run/brconnect -u / -c -f chpass -o SAPSR3 -p XXXXXX' exits with error code 5. For details see log file(s) brconnect.log.).

INFO 2015-11-18 12:00:56.241

Creating file /tmp/sapinst_instdir/BS2011/ERP606/AS-ABAP/ORA/CENTRAL/__instana_tmp.xml.

INFO 2015-11-18 12:00:59.285

Removed file /tmp/sapinst_instdir/BS2011/ERP606/AS-ABAP/ORA/CENTRAL/instslana.xml.

INFO 2015-11-18 12:00:59.287

Creating file /tmp/sapinst_instdir/BS2011/ERP606/AS-ABAP/ORA/CENTRAL/instslana.xml.

INFO 2015-11-18 12:01:02.316

An error occurred and the user decided to stop. Current step "|NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_Postload|ind|ind|ind|ind|postload|0|NW_Postload_ORA|ind|ind|ind|ind|ora|0|setOraclePasswords".

INFO 2015-11-18 12:01:04.364

Working directory changed to /tmp/sapinst_instdir/BS2011/ERP606/AS-ABAP/ORA/CENTRAL.

INFO 2015-11-18 12:01:06.412

Cancelled task 0.

INFO 2015-11-18 12:01:06.460

Creating file /tmp/sapinst_instdir/.lastInstallationLocation.

I checked the BRConnect.log

The log contain Below error

BR0801I BRCONNECT 7.20 (36)

BR0280I BRCONNECT time stamp: 2015-11-18 12.00.54

BR0828I Changing password for database user SAPSR3 ...

BR1628E Invalid charcter '@' in database password

BR0832E Changing password for user SAPSR3 failed

BR0280I BRCONNECT time stamp: 2015-11-18 12.00.54

BR0804I BRCONNECT terminated with errors

My System Configuration:

OS:RHEL 6.2

DB:ORACLE 11.2

I feel Happy If anyone solve this Problem.

Thanks,

Kishore

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Wed, 18 Nov 2015 09:15:52 GMT

Hi Kishore,

I would say you need to change your schema password which does not include character "@".

For doing so refer below threads and blogs.

SAP NW 7.40 installation with Oracle 11.2 | SCN

http://service.sap.com/sap/support/notes/1522952

http://service.sap.com/sap/support/notes/1519872

Do let us know if this helped you.

Regards,

Ram

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Wed, 18 Nov 2015 12:59:13 GMT

Hi Ram,

Thanks for Reply.

I have changed the schema password by using Below Command but no use same error i am getting.

sql> alter user SAPSR3 identified by <newpwd>

replace <oldpwd>;

user altered.

Regards,

Kishore

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Thu, 19 Nov 2015 09:20:59 GMT

Hello Kishore,

That's not going to work. Here's what you're going to have to do

1. Run the brconnect command and change your password.

2. cp brconnect brconnect.ORG

3. Create a shell script called brconnect that will exit with return code 0

$ vi brconnect

#/bin/sh

exit 0

$ chmod 755 brconnect

4.Continue with SUM

5. As soon as you pass your failing phase copy the original brconnect back straight away.

$ cp brconnect.ORG brconnect

The above should get you around your problem.

KR,

Amerjit

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sat, 21 Nov 2015 06:37:00 GMT

Hi Amerjit,

I got same problem.

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sun, 22 Nov 2015 13:02:17 GMT

Hello Kishore,

Can you run me through step-by-step what you did (including paths).

KR,

Amerjit

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

former_member182657 — Mon, 23 Nov 2015 03:24:49 GMT

Hi,

For the issue


ERROR 2015-11-18 12:00:54.285
CJS-30023  Process call '/usr/sap/W22/SYS/exe/run/brconnect -u / -c -f chpass -o SAPSR3 -p XXXXXX' exits with error code 5. For details see log file(s) brconnect.log.

I suggest you to follow SAP KBA 2141078 - Perform Oracle Post_load activity fail with BR*Tools error to check again,if still issue persists then re-share the updated brconnect.log & sapinst.log files from the system ?

Regards,

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Mon, 23 Nov 2015 08:55:46 GMT

Hello Kishore,

Did you follow my steps verbatim ?

1. Run the brconnect command and change your password.

$ /usr/sap/W22/SYS/exe/run/brconnect -u / -c -f chpass -o SAPSR3 -p INIT1234

2. As w22adm

$ cd /usr/sap/W22/SYS/exe/run

$ mv brconnect brconnect.ORG

3. Create a shell script called brconnect that will exit with return code 0

$ vi /usr/sap/W22/SYS/exe/run/brconnect

#/bin/sh

exit 0

$ chmod 755 /usr/sap/W22/SYS/exe/run/brconnect

4.Continue with SUM

5. As soon as you pass your failing phase copy the original brconnect back straight away.

$ cp /usr/sap/W22/SYS/exe/run/brconnect.ORG /usr/sap/W22/SYS/exe/run/brconnect

Please follow the above steps exactly and let us know how you get on.

KR,

Amerjit

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Mon, 23 Nov 2015 19:36:45 GMT

Change SAPSR3 password using

brconnect [-u system/<system_password>] –c –f chpass –u <user_name> –p <new_password>

Where:

· <system_password> is the password of the SAPSR3 database user. You can use another user with DBA privileges.

· <user_name> is the database user for which the password should be changed (for example, SAP<SCHEMAID>).

<new_password> is the new password for the user.

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Fri, 04 Dec 2015 06:46:14 GMT

Hi,

sorry for late response.

I have changed password for schema but i got same error.

Change SAPSR3 password using

brconnect [-u system/<system_password>] –c –f chpass –u <user_name> –p <new_password>

Thnaks,

Kishore.

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Fri, 04 Dec 2015 15:25:15 GMT

Hello,

I think your problem is that SAPINST tries to repeat the BRCONNECT with the badly formatted password, so even if you set a correct password manually, it will still try to set the bad password.

I suggest you try following:

1) Stop SAPINST if still open

2) Restart SAPINST but add the argument "SAPINST_SET_STEPSTATE=true"

3) After selevcting your installation option from the menu you will see the SAPINST step editor appear. Scroll down and you should find a phase (folder icon) "Perform ORA Post load activities". Expand this and you should see a step "setOraclePasswords".

4) Select this step and choose [right mouse button] -> Skip

5) From the menu in the step editor window, choose File -> Submit and Close

SAPINST will now execute the procedure but it will skip the step where it tries changing the password.

Hope this will help you,

Mark

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Reagan — Fri, 04 Dec 2015 15:35:46 GMT

You should be able to skip this phase by modifying the keydb.xml for this phase from ERROR to OK and restart the sapinst.

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sun, 06 Dec 2015 10:50:19 GMT

Hi Mark,

Where can i add argument "SAPINST_SET_STEPSTATE=true".

Thanks.

kishore

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sun, 06 Dec 2015 11:22:34 GMT

Hello Kishore,

As Mark had said but add the argument.

So you would restart sapinst as follows:

./sapinst SAPINST_SET_STEPSTATE=true

KR,

Amerjit

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sun, 06 Dec 2015 11:22:59 GMT

Hello Kishore,

Did you try these steps ?

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sun, 06 Dec 2015 11:23:08 GMT

Hi Kishore,

It is one of the properties you pass on the SAPINST command line:

cd <sapinst_directory>

./sapinst SAPINST_SET_STEPSTATE=true <other arguments ...>

For a description of all available arguments and properties:

./sapinst -p all

Regards,

Mark

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sun, 06 Dec 2015 11:57:14 GMT

Hi Mark,

I got error while i am installing SAP No such files or directory in the below path.

/usr/sap/SID/SYS/exe/uc/linuxx86_64/brconnect.

Thanks,

kishore.

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sun, 06 Dec 2015 12:15:28 GMT

Hi Amerjit,

I tried what Mark said but got another error in the Phase of Create database Statistics.

The error is /usr/sap/SID/SYS/exe/uc/linuxx86_64/brconnect.

Thanks,

Kishore.

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sun, 06 Dec 2015 12:48:20 GMT

Hello Kishore,

Please check the brconnect file exists in the path listed in the error.

KR,

Amerjit

Re: During the installation of Sap Ecc6.0 Ehp6 at the phase of perform ora postload activity

Former Member — Sun, 06 Dec 2015 13:00:20 GMT

Hi Amerjit,

brconnect log file exist in temp directory but there is no data available in that file.

Thanks,

Kishore.