SUM 19 PL6 error in phase PREP_INPUT/DBQUERY_PRE

[former_member233188]

Dear gurus,

we are upgrading a system to EHP8. Environment is Windows 2012 R2/Oracle12. In phase

PREP_INPUT/DBQUERY_PRE SUM asks for the system password. Although we provide the correct password, it states that it is wrong. We have reset the password to manager temporarily.

User account is system is open and not locked, we have no problems connecting to the db at all besides the sum problem:

SAPup> Starting subprocess in phase 'DBQUERY_PRE' at 20170511142531
*CENV: BR_ISP=1
ENV: DBMS_TYPE=ora
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
*DBENV: ORACLE_HOME=T:\Upgrade\SUM\abap\tmp
*DBENV: ORACLE_SID=BD0
ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
ENV: PATH=T:\Upgrade\SUM\abap\exe;E:\oracle\BD0\12102\bin;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\OmniBack\bin\;E:\usr\sap\BD0\DVEBMGS00\exe;E:\usr\sap\BD0\SYS\exe\uc\NTAMD64;E:\sapdb\clients\MAXDB\bin;E:\sapdb\clients\MAXDB\pgm;E:\sapdb\programs\bin
ENV: RSEC_SSFS_DATAPATH=\\server\sapmnt\BD0\SYS\global\security\rsecssfs\data
ENV: RSEC_SSFS_KEYPATH=\\server\sapmnt\BD0\SYS\global\security\rsecssfs\key
*CENV: SAPCHECK=T:\Upgrade\SUM\abap\tmp
*CENV: SAPDATA_HOME=T:\Upgrade\SUM\abap\tmp
ENV: SAPSYSTEMNAME=BD0
*DBENV: dbs_ora_schema=SAPSR3
ENV: dbs_ora_tnsname=BD0
ENV: rsdb_ssfs_connect=1
*DBENV: (auth_shadow_upgrade)
PWD: T:\Upgrade\SUM\abap\tmp

EXECUTING T:\Upgrade\SUM\abap\exe\brconnect.EXE -u -c -f dbstate -RDB
BR0801I BRCONNECT 7.40 (17)
BR0280I BRCONNECT time stamp: 2017-05-11 14:25:31
BR0262I Enter database user name[/password]:
BR0280I BRCONNECT time stamp: 2017-05-11 14:25:31
BR0301E SQL error -1 at location db_connect-3, SQL statement:
'CONNECT SYSTEM/*******@BD0'
Error while trying to retrieve text for error ORA-00001
BR0310E Connect to database instance BD0 failed

the interesting thing is that in the phase before the kernel extraction the check was fine:

SAPup> Starting subprocess in phase 'PROFREAD' at 20170511140951
*CENV: BR_ISP=1
ENV: DBMS_TYPE=ora
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
ENV: ORACLE_HOME=E:\oracle\BD0\12102
ENV: ORACLE_SID=BD0
ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
ENV: PATH=E:\usr\sap\BD0\DVEBMGS00\exe;E:\oracle\BD0\12102\bin;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\OmniBack\bin\;E:\usr\sap\BD0\SYS\exe\uc\NTAMD64;E:\sapdb\clients\MAXDB\bin;E:\sapdb\clients\MAXDB\pgm;E:\sapdb\programs\bin
ENV: RSEC_SSFS_DATAPATH=\\server\sapmnt\BD0\SYS\global\security\rsecssfs\data
ENV: RSEC_SSFS_KEYPATH=\\server\sapmnt\BD0\SYS\global\security\rsecssfs\key
*CENV: SAPCHECK=T:\Upgrade\SUM\abap\tmp
*CENV: SAPDATA_HOME=T:\Upgrade\SUM\abap\tmp
ENV: SAPSYSTEMNAME=BD0
ENV: dbs_ora_schema=SAPSR3
ENV: dbs_ora_tnsname=BD0
ENV: rsdb_ssfs_connect=1
*DBENV: (auth_shadow_upgrade)
PWD: T:\Upgrade\SUM\abap\tmp

EXECUTING E:\usr\sap\BD0\DVEBMGS00\exe\brconnect.EXE -u -c -f dbstate -RDB
BR0801I BRCONNECT 7.40 (29)
BR0280I BRCONNECT time stamp: 2017-05-11 14:09:51
BR0262I Enter database user name[/password]:

BR0280I BRCONNECT time stamp: 2017-05-11 14:09:51
BR0342I Database instance BD0 is started and open

BR0280I BRCONNECT time stamp: 2017-05-11 14:09:51
BR0802I BRCONNECT completed successfully

Maybe someone has the same issue?

Kind Regards,

Michael

[JamesZ]

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

The same issue is mentioned in sap kba 3096638.

So put E:\oracle\BD0\12102\bin to the last position in PATH environment, by doing this, it ensure the client libs are loaded from SAP directories.

Please don't copy any lib to other location, chaning environment variables instead.

[Estarr]

I resolved it by copying the oracle client files into /usr/sap/SID/SUM/abap/exe.

[former_member723192]

de que ruta copiaste el clente de oracle?

[Former Member]

Hi Michael,

we are also facing the same issue, could you please share the solution for this?

Regards,

Kartiki

[Former Member]

Is this fixed?

[hc_farma]

I've solved it , copyng the whole kernel from /usr/sap/SID/DV..../exe to the kernel located in /usr/sap/SID/SUM/abap/exe , This last kernel doesn´t have the oracle client. , so copying the original kernel solved the issue

[arnd_kullik]

The SAP note mentioned above will be corrected and will contain this solution

[arnd_kullik]

Dear Michael,

in my case the solution was setting the <sid>adm environment variable TNS_ADMIN to F:\usr\sap\TE3\SYS\profile\oracle.

Many thanks to Mr. Teichert from SAP Support.

Kind regards,

Arnd

[former_member233188]

Dear Arnd,

thank you for the info. I didn't check the previous versions of that note. The bad thing is that I have an incident open for 2 days on high priority. I haven't received an answer yet.

The part you are talking about is that:

-----------------------< D056915 JAN/26/17 >--------------------------

Windows only: Error in phase DBQUERY_PRE on ORACLE-systems
During the validation of the SYSTEM password, an error might occur due to a missing oracle instant client in directory SUM\abap\exe.

In this case, check the environment variable PATH and make sure that it points first to the Oracle instant client that is located in directory DIR_CT_RUN (example D:\usr\sap\SID\SYS\exe\uc\NTAMD64) and only afterwards to DIR_PUT\exe. This error will be fixed with SUM SP20.

-----------------------< D056915 JAN/09/17 >--------------------------

correct?

I will take a look at that this evening. I already tried to copy the oracle client in the sum/abap/exe directory, but no luck.

Kind Regards,

Michael

[arnd_kullik]

Dear Michael,

yes, I have :-(.

This issue is described in upgrade note 2328526 in section "Windows only: Error in phase DBQUERY_PRE on Oracle-system".

Unfortunately I don't understand the solution described by SAP concerning the PATH variable.

Does someone know what to do ?

Kind regards,

Arnd