Skip to Content
0
Former Member
Jun 29, 2017 at 01:21 PM

DB Connect Error in PREP_INPUT/DBQUERY_PRE with SUM

1367 Views Last edit Jun 29, 2017 at 01:23 PM 2 rev

Hi Gurus,

we just want to install some AddOn's in our DEV System.
But SUM always stuck at PREP_INPUT/DBQUERY_PRE with following issue:

SAPup> Starting subprocess with PID 20054054 in phase 'DBQUERY_PRE' at 20170629150809
  *CENV: BR_ISP=1
    ENV: DIR_LIBRARY=/usr/sap/E11/SUM/abap/exe
    ENV: JAVA_HOME=/usr/java14_64
    ENV: LIBPATH=/usr/sap/E11/SUM/abap/exe:/usr/lib:/lib:/usr/sap/E11/SYS/exe/run:/usr/sap/E11/SYS/exe/nuc/rs6000_64:/oracle/client/12x/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.WE8DEC
    ENV: ORACLE_BASE=/oracle
 *DBENV: ORACLE_HOME=/usr/sap/E11/SUM/abap/tmp
 *DBENV: ORACLE_SID=E11
    ENV: PATH=/usr/sap/E11/SUM/abap/exe:/oracle/E11/121/bin:/usr/java14_64/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java8/jre/bin:/usr/java8/bin:/usr/sap/E11/SYS/exe/nuc/rs6000_64:/usr/sap/E11/SYS/exe/run:/home/e11adm:.
    ENV: RSEC_SSFS_DATAPATH=/usr/sap/E11/SYS/global/security/rsecssfs/data
    ENV: RSEC_SSFS_KEYPATH=/usr/sap/E11/SYS/global/security/rsecssfs/key
  *CENV: SAPCHECK=/usr/sap/E11/SUM/abap/tmp
  *CENV: SAPDATA_HOME=/usr/sap/E11/SUM/abap/tmp
    ENV: SAPSYSTEMNAME=E11
    ENV: dbms_type=ORA
 *DBENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=E11
    ENV: rsdb_ssfs_connect=1
 *DBENV: (auth_shadow_upgrade)
    PWD: /usr/sap/E11/SUM/abap/tmp


EXECUTING /usr/sap/E11/SUM/abap/exe/brconnect -u -c -f dbstate -RDB
BR0801I BRCONNECT 7.40 (29)
BR0280I BRCONNECT time stamp: 2017-06-29 15:08:09
BR0262I Enter database user name[/password]:
BR0280I BRCONNECT time stamp: 2017-06-29 15:08:09
BR0301E SQL error -12541 at location db_connect-3, SQL statement:
'CONNECT SYSTEM/*******@E11'
ORA-12541: TNS:no listener
BR0310E Connect to database instance E11 failed


BR0280I BRCONNECT time stamp: 2017-06-29 15:08:09
BR0804I BRCONNECT terminated with errors
SAPup> Process with PID 20054054 terminated with status 3 at 20170629150809!


Test with sid user is successful

e11adm> /usr/sap/E11/SUM/abap/exe/brconnect -u -c -f dbstate -RDB
BR0801I BRCONNECT 7.40 (29)
BR0280I BRCONNECT time stamp: 2017-06-29 15:13:43
BR0262I Enter database user name[/password]:
SYSTEM
BR0263I Enter password for database user 'SYSTEM' (max. 30 ASCII chars):




BR0280I BRCONNECT time stamp: 2017-06-29 15:13:48
BR0342I Database instance E11 is started and open


BR0280I BRCONNECT time stamp: 2017-06-29 15:13:48
BR0802I BRCONNECT completed successfully

R3trans is successful

e11adm> R3trans -x
This is R3trans version 6.26 (release 749 - 14.02.17 - 20:17:01).
non-unicode version
R3trans finished (0000).

e11adm> R3trans -d
This is R3trans version 6.26 (release 749 - 14.02.17 - 20:17:01).
non-unicode version
R3trans finished (0000).

We updated the kernel to newer one, but the issue is still there

Software Update Manager 1.0 SP19 (PL0)
Software Logistics Protocol 1.2.0
Software Logistics UI Client 2.8.8

We don't have any idea anymore.
Anyone a suggestion?