Skip to Content

SUM 19 PL6 error in phase PREP_INPUT/DBQUERY_PRE

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • May 11, 2017 at 04:45 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 12, 2017 at 02:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 17, 2017 at 01:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 17, 2017 at 01:35 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2017 at 03:23 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2017 at 10:46 AM

    Hi Michael,

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

    Regards,

    Kartiki

    Add comment
    10|10000 characters needed characters exceeded