Skip to Content
0

SUM 19 PL6 error in phase PREP_INPUT/DBQUERY_PRE

May 11, 2017 at 01:26 PM

460

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Arnd Kullik-Lindner May 11, 2017 at 04:45 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Michael Henninger May 12, 2017 at 02:16 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Arnd Kullik-Lindner May 17, 2017 at 01:33 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Arnd Kullik-Lindner May 17, 2017 at 01:35 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 19, 2017 at 03:23 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 06, 2017 at 10:46 AM
0

Hi Michael,

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

Regards,

Kartiki

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Is this fixed?

0