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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Mark,

Where can i add argument "SAPINST_SET_STEPSTATE=true".

Thanks.

kishore

[Former Member · Accepted solution]

Hello Kishore,

As Mark had said but add the argument.

So you would restart sapinst as follows:

./sapinst SAPINST_SET_STEPSTATE=true

KR,

Amerjit

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi Kishore,

When you ran brconnect earlier (for the password), it was in /usr/sap/W22/SYS/exe/run (which is normally a symbolic link), so it must exist somewhere. Can you run following commands:

ls -l /usr/sap/W22/SYS/exe

find /sapmnt/W22 -name brconnect

If necessary we can always patch control.xml to adapt the brconnect path, but obviously we first need to know where it is exactly.

Regards,

Mark

[Former Member · Accepted solution]

Hi Mark,

The problem has been solved by past the brconnect file in /usr/sap/W22/exe/uc/linuxx86_64.

but i got onemore error install instance basics of ASCS01 phase.

The error is

INFO 2015-12-07 10:14:56.437

Node sapcontrol_W22_ASCS01.log already exists.

INFO 2015-12-07 10:14:56.491

Output of /usr/sap/W22/SYS/exe/uc/linuxx86_64/sapcontrol -nr 01 -host will2can -function GetProcessList is written to the logfile sapcontrol_W22_ASCS01.log.

WARNING 2015-12-07 10:14:56.505

Execution of the command "/usr/sap/W22/SYS/exe/uc/linuxx86_64/sapcontrol -nr 01 -host will2can -function GetProcessList" finished with return code 255. Output:

Could not open the ICU common library.

   The following files must be in the path described by

   the environment variable "LD_LIBRARY_PATH":

   libicuuc.so.34, libicudata.so.34, libicui18n.so.34 [nlsui0_mt.c 1548] pid = 9802

LD_LIBRARY_PATH is currently set to /sapmnt/W22/exe/uc/linuxx86_64  [nlsui0_mt.c 1551] pid = 9802

WARNING 2015-12-07 10:15:01.514

Connect to message server (will2can/3901) failed: MSENILAYER.

WARNING 2015-12-07 10:15:06.523

Connect to message server (will2can/3901) failed: MSENILAYER.

ERROR 2015-12-07 10:15:06.538

CJS-30087  Instance W22/ASCS01 [PARTIAL] did not stop after 2:00 minutes. Giving up.

ERROR 2015-12-07 10:15:07.695

FCO-00011  The step stopInstance with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CI_Instance|ind|ind|ind|ind|ci|0|NW_Instance|ind|ind|ind|ind|scsInstance|0|stopInstance was executed with status ERROR ( Last error reported by the step: Instance W22/ASCS01 [PARTIAL] did not stop after 2:00 minutes. Giving up.).

INFO 2015-12-07 10:15:08.71

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

INFO 2015-12-07 10:15:11.292

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

INFO 2015-12-07 10:15:11.294

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

Thanks,

kishore

[Former Member · Accepted solution]

Hi Kishore,

The three libraries mentioned in the error:

libicuuc.so.34, libicudata.so.34, libicui18n.so.34

Are they present in /sapmnt/W22/exe/uc/linuxx86_64? Anywhere else (e.g. below /usr/sap/W22)?

With this following on the missing brconnect error I have a definite impression that there is something wrong with the kernel setup.

Regards,

Mark

[Former Member · Accepted solution]

Hi Mark,

These three libraries

libicuuc.so.34, libicudata.so.34, libicui18n.so.34

are present in /sapmnt/W22/exe/ .

Those files are not available in /sapmnt/W22/exe/uc/linuxx86_64. Anywhere else (e.g. below /usr/sap/W22).

Then what should i do now?should i have to install from new installation?

Thanks,

Kishore.

[Former Member · Accepted solution]

Hi Mark,

I past those three files from /sapmnt/W22/exe/ to /sapmnt/W22/exe/uc/linuxx86_64.

It worked.The installation has been complated.

Thanks for such as given wonderful response,you have done a good job Mark.

but i have a doubt Mark,previously i installed sap but it did not ask that type of missing files in "/sapmnt/W22/exe/uc/linuxx86_64" and it is empty file actually.

why it is asked now.

Thanks,

Kishore.

[Former Member · Accepted solution]

Hi Kishore,

Sorry, I was offline the last few days. It is difficult to reconstruct the situation from the beginning but I suspect that somewhere along the way kernel files got moved or extracted in the wrong place, although I have also know cases where SAPINST itself got the location wrong.

Are there any files left directly in /sapmnt/W22/exe? The correct installation would have the central kernel directory /sapmnt/W22/exe/uc/linuxx86_64 and local (instance-specific) kernel directory /usr/sap/W22/DVEBMGSxx/exe. The latter is filled automatically at system startup (via the sapcpe program) after initial installation or after every kernel upgrade.

Regards,

Mark

[Former Member]

Hi

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.

[Former Member]

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.

[Reagan]

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

[former_member182657]

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,

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Amerjit,

I got same problem.

[Former Member]

Hello Kishore,

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

KR,

Amerjit

[Former Member]

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

[Former Member]

Hello Kishore,

Did you try these steps ?

A.

[Former Member]

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.

[Former Member]

Hello Kishore,

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

KR,

Amerjit

[Former Member]

Hi Amerjit,

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

Thanks,

Kishore.

[Former Member]

Hi Amerjit,

There is no file available in that path:usr/sap/SID/SYS/exe/uc/linuxx86_64/

but brconnect.log file availabe in path:temp/sapinst_instdir but it is empty.

Thanks,

Kishore.

[Former Member]

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