on 10-30-2013 3:21 PM
Hi All,
I'm doing a PI 7.31 Dual Stack install on WIN2008/Oracle 11g.
The installation is failing at phase 28 of 50 ( perform Initial Java Engine Configuration)
I've traced it all the way back to an connecting to oracle issue.
R3trans -d cannot connect to DB.
Here is part of the file
4 ETW000 94 0.095055
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 58 0.095113
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@OT4 on connection 0 (nls 0) ... (dbsl 720 081211, UNICODE[2])
4 ETW000 134 0.095247
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=04E50490) 153 0.095400
4 ETW000 [ dev trc,00000] Allocating server context handle 82 0.095482
4 ETW000 [ dev trc,00000] Attaching to database server OT4 (con=0, svchp=04E50490, srvhp=04E50630)
4 ETW000 149 0.095631
4 ETW000 [ dev trc,00000] Wed Oct 30 11:00:30 2013 2424786 2.520417
4 ETW000 [ dev trc,00000] Assigning server context 04E50630 to service context 04E50490 137 2.520554
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=04E5F530) 169 2.520723
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp= 04E5F530 72 2.520795
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=04E5F530 104 2.520899
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=04E50490, srv=04E50630, usr=04E5F530)
4 ETW000 457 2.521356
4 ETW000 [ dev trc,00000] Wed Oct 30 11:00:40 2013 10079651 12.601007
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 160 12.601167
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 292 12.601459
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 137 12.601596
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 98 12.601694
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 58 12.601752
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 57 12.601809
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 211 12.602020
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 106 12.602126
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 70 12.602196
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 156 12.602352
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 68 12.602420
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'OT4'"
I can see that its trying to connect and invalid username/password.
I tried via brtools to change SAPSR3 account and BRTOOLS comes back with
BR0801I BRCONNECT 7.20 (17)
BR0280I BRCONNECT time stamp: 2013-10-30 11.14.37
BR0301E SQL error -12154 at location db_connect-2, SQL statement:
'CONNECT SAPSR3/********@OT40'
ORA-12154: TNS:could not resolve the connect identifier specified
BR0310E Connect to database instance OT4 failed
BR0280I BRCONNECT time stamp: 2013-10-30 11.14.37
BR0804I BRCONNECT terminated with errors
So I checked my Oracle instance and its up and running
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE
----------------- --------------- ------------ --- ---------- -------
LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
--------------- ---------- --- ----------------- ------------------ ---------
BLO
---
1 ot4
SD01CUDB0105
11.2.0.3.0 30-OCT-13 OPEN NO 1 STARTED
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE
----------------- --------------- ------------ --- ---------- -------
LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
--------------- ---------- --- ----------------- ------------------ ---------
BLO
---
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
NO
SQL>
So I'm not sure what do try next.
Any suggestions?
Hi Joshua Lacroix,
Pls refer the below KBA for more solution::
1576837 - ORA-01017: invalid username/password;
&
oss note 400241
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Says password succesfully changed but table SAPUSER not found!
Use the following command to create the table SAPUSER as <sid>adm:
CREATE TABLE "OPS$<sid>ADM".SAPUSER
(USERID VARCHAR2(256), PASSWD VARCHAR2(256));
INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');
Then as sidadm run
brconnect -u system/password -f chpass -o SAPSR3 -p password.
Follow this SAP note
400241 - Problems with ops$ or sapr3 connect to Oracle
Regards
RB
Using Brconnect I can connect to the DB using SAPSR3 and both my OPS$SID and OPS$Service accounts.
Here is my Trans.log
4 ETW000 r3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 31.10.2013 - 09:15:39
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Thu Oct 31 09:15:39 2013 213 0.000213
4 ETW000 [ dev trc,00000] db_con_init called 97 0.000310
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 157 0.000467
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 88 0.000555
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 69 0.000624
4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ... 123 0.000747
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 000007FEF9240000
4 ETW000 1835 0.002582
4 ETW000 [ dev trc,00000] using "H:\usr\sap\OT4\SYS\exe\uc\NTAMD64\dboraslib.dll" 58 0.002640
4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded 63 0.002703
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dboraslib.dll 58 0.002761
4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "720.00", patchlevel (0.114) 407 0.003168
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dboraslib.dll 64 0.003232
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dboraslib.dll 104 0.003336
4 ETW000 [ dev trc,00000] New connection 0 created 386 0.003722
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 151 0.003873
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 58 0.003931
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 88 0.004019
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 52 0.004071
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 116 0.004187
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 54 0.004241
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol 97 0.004338
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2
4 ETW000 119 0.004457
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 836] 132 0.004589
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3664]
4 ETW000 371 0.004960
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\SD01CUDB0105\sapmnt\OT4\SYS\global\security\rsecssfs\data\SSFS_OT4.DAT" opened for read [rsecssfs.c 2202]
4 ETW000 1891 0.006851
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\SD01CUDB0105/sapmnt/OT4/SYS/global/security/rsecssfs/key\SSFS_OT4.KEY" not found, using default key [rsecssfs.c 1246]
4 ETW000 1110 0.007961
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 897]
4 ETW000 1376 0.009337
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 102 0.009439
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 836] 71 0.009510
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3664]
4 ETW000 254 0.009764
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\SD01CUDB0105\sapmnt\OT4\SYS\global\security\rsecssfs\data\SSFS_OT4.DAT" opened for read [rsecssfs.c 2202]
4 ETW000 1587 0.011351
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\SD01CUDB0105/sapmnt/OT4/SYS/global/security/rsecssfs/key\SSFS_OT4.KEY" not found, using default key [rsecssfs.c 1246]
4 ETW000 1034 0.012385
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 897]
4 ETW000 1227 0.013612
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 103 0.013715
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 836] 71 0.013786
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3664]
4 ETW000 249 0.014035
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\SD01CUDB0105\sapmnt\OT4\SYS\global\security\rsecssfs\data\SSFS_OT4.DAT" opened for read [rsecssfs.c 2202]
4 ETW000 1583 0.015618
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\SD01CUDB0105/sapmnt/OT4/SYS/global/security/rsecssfs/key\SSFS_OT4.KEY" not found, using default key [rsecssfs.c 1246]
4 ETW000 1046 0.016664
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2224]
4 ETW000 291 0.016955
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage) [rsecssfs.c 897]
4 ETW000 816 0.017771
4 ETW000 [ dev trc,00000] read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage
4 ETW000 119 0.017890
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 58 0.017948
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=0, type=0, env='[default env]', userid='SAPSR3')
4 ETW000 493 0.018441
4 ETW000 [ dev trc,00000] DIR_CLIENT_ORAHOME is not set as profile nor env. parameter. 551 0.018992
4 ETW000 Assuming using instant client with unspecified location.
4 ETW000 [ dev trc,00000] Register application info. 215 0.019207
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, (dbsl 720 081211, UNICODE[2]) 30098 0.049305
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available. 107 0.049412
4 ETW000 [ dev trc,00000] Default connection: tnsname ='OT4' 61 0.049473
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 139 0.049612
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 39147 0.088759
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=04E493E8) 174 0.088933
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=04E4A678) 113 0.089046
4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 233 0.089279
4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 74 0.089353
4 ETW000 [ dev trc,00000] char=55005400460031003600 63 0.089416
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 97 0.089513
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 57 0.089570
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@OT4 on connection 0 (nls 0) ... (dbsl 720 081211, UNICODE[2])
4 ETW000 143 0.089713
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=04E50490) 99 0.089812
4 ETW000 [ dev trc,00000] Allocating server context handle 69 0.089881
4 ETW000 [ dev trc,00000] Attaching to database server OT4 (con=0, svchp=04E50490, srvhp=04E50630)
4 ETW000 141 0.090022
4 ETW000 [ dev trc,00000] Thu Oct 31 09:15:42 2013 2414968 2.504990
4 ETW000 [ dev trc,00000] Assigning server context 04E50630 to service context 04E50490 142 2.505132
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=04E5F530) 179 2.505311
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp= 04E5F530 74 2.505385
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=04E5F530 109 2.505494
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=04E50490, srv=04E50630, usr=04E5F530)
4 ETW000 449 2.505943
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 23971 2.529914
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 341 2.530255
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 116 2.530371
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 94 2.530465
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 59 2.530524
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 56 2.530580
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 224 2.530804
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 103 2.530907
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 70 2.530977
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 154 2.531131
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 67 2.531198
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'OT4'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Morning,
I got the same issue when doing a fresh install on NW73. Seems it turns on the new password auth feature
You need to do the following and then rerun the failed section. Mine failed when it was trying to insert a new license TEMP key and it couldnt connect to the DB. I ran the following scripts to set the password in the new area and it worked
See if you have the following env variables set
RSEC_SSFS_DATAPATH=/usr/sap/PID/SYS/global/security/rsecssfs/data
RSEC_SSFS_KEYPATH=/usr/sap/PID/SYS/global/security/rsecssfs/key
rsdb_ssfs_connect=1
The last one is key as a value of 1 sets te RSDB_SSFS feature on.
If so substitue <SID> with your SID and XXXXX with your password for SAPSR3 on UNIX and it should work. For Windows you will need to put a drive letter in the command and replace path as needed
rsecssfx pf=/usr/sap/<SID>/SYS/profile/DEFAULT.PFL put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain
rsecssfx pf=/usr/sap/<SID>/SYS/profile/DEFAULT.PFL put DB_CONNECT/DEFAULT_DB_PASSWORD XXXXXXXX
Hope this helps as it solved my install issue in the exact same place
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm picking this back up this morning.
My issue now is the password in the secure store for my java db user is different than the password in the DB. So im using the brconnect string to change it. I can change it in abap for secure store but not java.
I will try what Reagan says and get SAP JVM and then run my command again.
got a little farther
BR0801I BRCONNECT 7.20 (34)
BR0280I BRCONNECT time stamp: 2013-11-12 14.00.20
BR0828I Changing password for database user SAPSR3DB ...
BR0280I BRCONNECT time stamp: 2013-11-12 14.00.21
BR0829I Password changed successfully in database for user SAPSR3DB
BR0280I BRCONNECT time stamp: 2013-11-12 14.00.21
BR1525I Setting password for database user SAPSR3DB in secure storage H:\usr\sap
\OT4\SYS\global\security\data\SecStore.properties ...
BR0278E Command output of 'H:\usr\sap\OT4\SYS\exe\uc\NTAMD64\brtools.exe -f prin
tpwd -U H:\usr\sap\OT4\SYS\global\security\data\.java.pwf | c:\sapjvm_6\bin\java
.exe -DSAPSYSTEMNAME=OT4 -classpath H:\usr\sap\OT4\SYS\global\sltools\sharedlib\
sap.com~tc~bl~offline_launcher~impl.jar com.sap.engine.offline.OfflineToolStart
com.sap.inst.secstore.AdjustSecureStoreFS H:\usr\sap\OT4\SYS\global\sltools\shar
edlib;H:\usr\sap\OT4\SYS\global\security\lib\tools -sidSource OT4 -sidTarget OT4
-sec H:\usr\sap\OT4\SYS\global\security\data\SecStore.properties -key H:\usr\sa
p\OT4\SYS\global\security\data\SecStore.key -dbUser SAPSR3DB -useStdin -nomask':
INFO: Loading tool launcher...
INFO: [OS: Windows Server 2008] [VM vendor: SAP AG] [VM version: 1.6.0_07] [V
M type: SAP Java Server VM]
INFO: Main class to start: "com.sap.inst.secstore.AdjustSecureStoreFS"
INFO: Loading 40 JAR files: [H:\usr\sap\OT4\SYS\global\sltools\sharedlib\chec
kKeyPhrase.jar, H:\usr\sap\OT4\SYS\global\sltools\sharedlib\jdbc.jar, H:\usr\sap
\OT4\SYS\global\sltools\sharedlib\jperflib.jar, H:\usr\sap\OT4\SYS\global\sltool
s\sharedlib\jsizecheck.jar, H:\usr\sap\OT4\SYS\global\sltools\sharedlib\miglib.j
ar, H:\usr\sap\OT4\SYS\global\sltools\sharedlib\sap.com~sl.inst.sysidentity.jar,
H:\usr\sap\OT4\SYS\global\sltools\sharedlib\sap.com~sl.ut.infoprovider_lib.jar,
H:\usr\sap\OT4\SYS\global\sltools\sharedlib\sap.com~sl.ut.manager.offline.jar,
H:\usr\sap\OT4\SYS\global\sltools\sharedlib\sap.com~sl~ctc~import.jar, H:\usr\sa
p\OT4\SYS\global\sltools\sharedlib\sap.com~tc~antlr.jar, H:\usr\sap\OT4\SYS\glob
al\sltools\sharedlib\sap.com~tc~bl~config~impl.jar, H:\usr\sap\OT4\SYS\global\sl
tools\sharedlib\sap.com~tc~bl~iqlib~impl.jar, H:\usr\sap\OT4\SYS\global\sltools\
sharedlib\sap.com~tc~bl~jdsr~jdsr.jar, H:\usr\sap\OT4\SYS\global\sltools\sharedl
ib\sap.com~tc~bl~offline_launcher~impl.jar, H:\usr\sap\OT4\SYS\global\sltools\sh
aredlib\sap.com~tc~bl~opensql~implStandalone.jar, H:\usr\sap\OT4\SYS\global\slto
ols\sharedlib\sap.com~tc~bl~sl~utility.jar, H:\usr\sap\OT4\SYS\global\sltools\sh
aredlib\sap.com~tc~cim~objmgr_lib.jar, H:\usr\sap\OT4\SYS\global\sltools\sharedl
ib\sap.com~tc~cim~service_lib.jar, H:\usr\sap\OT4\SYS\global\sltools\sharedlib\s
ap.com~tc~dd~db~dictionarydatabase~implDictionaryDatabase.jar, H:\usr\sap\OT4\SY
S\global\sltools\sharedlib\sap.com~tc~dd~db~friendtools.jar, H:\usr\sap\OT4\SYS\
global\sltools\sharedlib\sap.com~tc~exception.jar, H:\usr\sap\OT4\SYS\global\slt
ools\sharedlib\sap.com~tc~je~configtool.jar, H:\usr\sap\OT4\SYS\global\sltools\s
haredlib\sap.com~tc~je~offlineconfiguration~impl.jar, H:\usr\sap\OT4\SYS\global\
sltools\sharedlib\sap.com~tc~logging~java~impl.jar, H:\usr\sap\OT4\SYS\global\sl
tools\sharedlib\sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, H:\usr\sap\OT4\SYS\g
lobal\sltools\sharedlib\sap.com~tc~sdt~cvl~impl.jar, H:\usr\sap\OT4\SYS\global\s
ltools\sharedlib\sap.com~tc~sec~secstorefs~java~core.jar, H:\usr\sap\OT4\SYS\glo
bal\sltools\sharedlib\sap.com~tc~sld~sldclient_lib.jar, H:\usr\sap\OT4\SYS\globa
l\sltools\sharedlib\sap.com~tc~sld~sldstdapi_lib.jar, H:\usr\sap\OT4\SYS\global\
sltools\sharedlib\sdt_jcopy_common.jar, H:\usr\sap\OT4\SYS\global\sltools\shared
lib\sdt_jcopy_jload.jar, H:\usr\sap\OT4\SYS\global\sltools\sharedlib\sdt_jcopy_j
migmon.jar, H:\usr\sap\OT4\SYS\global\sltools\sharedlib\sdt_jcopy_jmigtime.jar,
H:\usr\sap\OT4\SYS\global\sltools\sharedlib\sdt_jcopy_jpkgctl.jar, H:\usr\sap\OT
4\SYS\global\sltools\sharedlib\systemHistory.jar, H:\usr\sap\OT4\SYS\global\secu
rity\lib\tools\iaik_jce.jar, H:\usr\sap\OT4\SYS\global\security\lib\tools\iaik_j
sse.jar, H:\usr\sap\OT4\SYS\global\security\lib\tools\iaik_smime.jar, H:\usr\sap
\OT4\SYS\global\security\lib\tools\iaik_ssl.jar, H:\usr\sap\OT4\SYS\global\secur
ity\lib\tools\w3c_http.jar]
INFO: Start
DB user password:
SecStore properties: H:\usr\sap\OT4\SYS\global\security\data\SecStore.properties
SecStore key: H:\usr\sap\OT4\SYS\global\security\data\SecStore.key
SID source: OT4
SID target: OT4
DB user target: SAPSR3DB
DB user password: XXXXXXXX
FATAL: Main class "com.sap.inst.secstore.AdjustSecureStoreFS" cannot be starte
d:
FATAL: java.lang.ExceptionInInitializerError
at javax.crypto.Cipher.getInstance(DashoA13*..)
at javax.crypto.Cipher.getInstance(DashoA13*..)
at iaik.security.provider.IAIK.a(Unknown Source)
at iaik.security.provider.IAIK.addAsJDK14Provider(Unknown Source)
at iaik.security.provider.IAIK.addAsJDK14Provider(Unknown Source)
at com.sap.security.core.server.secstorefs.Crypt.<clinit>(Crypt.java:85)
at com.sap.security.core.server.secstorefs.SecStoreFS.<init>(SecStoreFS.
java:1381)
at com.sap.inst.secstore.AdjustSecureStoreFS.main(AdjustSecureStoreFS.ja
va:283)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:16
2)
Caused by: java.lang.SecurityException: Cannot set up certs for trusted CAs
at javax.crypto.SunJCE_b.<clinit>(DashoA13*..)
... 13 more
Caused by: java.lang.SecurityException: Cannot locate policy or framework files!
at javax.crypto.SunJCE_b.i(DashoA13*..)
at javax.crypto.SunJCE_b.g(DashoA13*..)
at javax.crypto.SunJCE_b$1.run(DashoA13*..)
at java.security.AccessController.doPrivileged(Native Method)
... 14 more
FATAL: com.sap.engine.offline.OfflineToolStart will abort now with exitcode 2
BR0280I BRCONNECT time stamp: 2013-11-12 14.00.25
BR0279E Return code from 'H:\usr\sap\OT4\SYS\exe\uc\NTAMD64\brtools.exe -f print
pwd -U H:\usr\sap\OT4\SYS\global\security\data\.java.pwf | c:\sapjvm_6\bin\java.
exe -DSAPSYSTEMNAME=OT4 -classpath H:\usr\sap\OT4\SYS\global\sltools\sharedlib\s
ap.com~tc~bl~offline_launcher~impl.jar com.sap.engine.offline.OfflineToolStart c
om.sap.inst.secstore.AdjustSecureStoreFS H:\usr\sap\OT4\SYS\global\sltools\share
dlib;H:\usr\sap\OT4\SYS\global\security\lib\tools -sidSource OT4 -sidTarget OT4
-sec H:\usr\sap\OT4\SYS\global\security\data\SecStore.properties -key H:\usr\sap
\OT4\SYS\global\security\data\SecStore.key -dbUser SAPSR3DB -useStdin -nomask':
2
BR1527E Setting password for user SAPSR3DB in secure storage H:\usr\sap\OT4\SYS\
global\security\data\SecStore.properties failed
BR0832E Changing password for user SAPSR3DB failed
BR0280I BRCONNECT time stamp: 2013-11-12 14.00.25
BR0804I BRCONNECT terminated with errors
Any Advice?
BR1527E Setting password for user SAPSR3DB in secure storage H:\usr\sap\OT4\SYS\global\security\data\SecStore.properties failed
BR0832E Changing password for user SAPSR3DB failed
If you have changed the password for the Java schema user SAPSR3DB then open the configtool and update the password for the SAPSR3DB user in the secure store.
Regards
RB
What do you think?
---------------------------------------------------
trc file: "dev_bootstrap", trc level: 1, release: "720"
---------------------------------------------------
sysno 00
sid OT4
systemid 562 (PC with Windows NT)
relno 7200
patchlevel 0
patchno 436
intno 20020600
make multithreaded, Unicode, 64 bit, optimized
profile \\SD01CUDB0105\sapmnt\OT4\SYS\profile\OT4_DVEBMGS00_SD01CUDB0105
pid 9416
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS All, egi
*
Wed Nov 13 11:35:51 2013
*
* trace logging activated, max size = 52428800 bytes, 2 versions
*
arguments :
arg[ 0] : H:\usr\sap\OT4\DVEBMGS00\exe\jstart.EXE
arg[ 1] : -appTrc
arg[ 2] : -nodeId=0
arg[ 3] : pf=\\SD01CUDB0105\sapmnt\OT4\SYS\profile\OT4_DVEBMGS00_SD01CUDB0105
arg[ 4] : -hostvm
arg[ 5] : -nodeName=bootstrap
arg[ 6] : -file=H:\usr\sap\OT4\DVEBMGS00\exe\startup.properties
arg[ 7] : -jvmFile=H:\usr\sap\OT4\DVEBMGS00\work\jstart.jvm
arg[ 8] : -traceFile=H:\usr\sap\OT4\DVEBMGS00\work\dev_bootstrap
arg[ 9] : -javaOutFile=H:\usr\sap\OT4\DVEBMGS00\work\jvm_bootstrap.out
arg[10] : -DSAPSTART=1
arg[11] : -DSAPSYSTEM=00
arg[12] : -DSAPSYSTEMNAME=OT4
arg[13] : -DSAPMYNAME=SD01CUDB0105_OT4_00
arg[14] : -DSAPPROFILE=\\SD01CUDB0105\sapmnt\OT4\SYS\profile\OT4_DVEBMGS00_SD01CUDB0105
arg[15] : -DFRFC_FALLBACK=ON
arg[16] : -DFRFC_FALLBACK_HOST=localhost
F
F Wed Nov 13 11:35:51 2013
F ********************************************************************************
F Java environment properties
F root directory : H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6
F vendor : SAP AG
F version : 1.6.0_29
F cpu : amd64
F java vm type : server
F java vm version : 6.1.037 1.6-b11
F jvm library name : jvm.dll
F library path : H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6\jre\bin\server;H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6\jre\bin
F executable path : H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6\bin
F SAP extensions : available
F ********************************************************************************
I [Thr 10064] MtxInit: 10000 0 2
M [Thr 10064] NiInit3: NI already initialized; param 'maxHandles' ignored (init=2;par=32768;cur=2048)
M [Thr 10064] CCMS: Detected Double Stack (parameter "rdisp/j2ee_start" is active)
M [Thr 10064] CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.
M [Thr 10064] CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.
M [Thr 10064] CCMS: CCMS Monitoring Initialization finished, rc=0.
F
F Wed Nov 13 11:35:51 2013
F ********************************************************************************
F SAP Java VM arguments:
F arg[ 0] = vfprintf
F arg[ 1] = abort
F arg[ 2] = exit
F arg[ 3] = -XmonGcCallback
F arg[ 4] = -XdebugStateChangeCallback
F arg[ 5] = -DSAPJStartVersion=720, patch 500, changelist 1442251, NTAMD64, optU (EXT) (Sep 16 2013, 02:43:35)
F arg[ 6] = -verbose:gc
F arg[ 7] = -XX:+HeapDumpOnOutOfMemoryError
F arg[ 8] = -DSAPSTARTUP=1
F arg[ 9] = -DSAPSYSTEM=00
F arg[10] = -DSAPSYSTEMNAME=OT4
F arg[11] = -DSAPMYNAME=SD01CUDB0105_OT4_00
F arg[12] = -DSAPDBHOST=SD01CUDB0105
F arg[13] = -DSAPINFO=OT4_00_bootstrap
F arg[14] = -Dj2ee.dbhost=SD01CUDB0105
F arg[15] = -Dsun.java.launcher=jstart
F arg[16] = -Dsun.java.command=com.sap.engine.offline.OfflineToolStart com.sap.engine.bootstrap.Bootstrap ./bootstrap -DSAPSTART=1 -DSAPSYSTEM=00 -DSAPSYSTEMNAME=OT4 -DSAPMYNAME=SD01CUDB0105_OT4_00 -DSAPPROFILE=\\\\SD01CUDB0105\\sapmnt\\OT4\\SYS\\profile\\OT4_DVEBMGS00_SD01CUDB0105 -DFRFC_FALLBACK=ON -DFRFC_FALLBACK_HOST=localhost
F arg[17] = -Djstartup.mode=JSTART
F arg[18] = -Djstartup.whoami=bootstrap
F arg[19] = -Djstartup.ownProcessId=9416
F arg[20] = -Djstartup.ownHardwareId=Z1722644468
F arg[21] = -Djstartup.debuggable=no
F arg[22] = -DLoadBalanceRestricted=no
F arg[23] = -Denv.class.path=
F arg[24] = -Dsys.global.dir=H:\usr\sap\OT4\SYS\global
F arg[25] = -Dapplication.home=H:\usr\sap\OT4\DVEBMGS00\exe
F arg[26] = -Djava.class.path=H:\usr\sap\OT4\DVEBMGS00\exe\jstart71.jar;H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6\lib\jvmx.jar;H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6\lib\jvmx_tools.jar;H:\usr\sap\OT4\DVEBMGS00\exe\jre\lib\iqlib.jar;H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6\lib\tools.jar;.\bootstrap\sap.com~tc~bl~offline_launcher~impl.jar
F arg[27] = -Djava.library.path=H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6\jre\bin\server;H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6\jre\bin;H:\usr\sap\OT4\DVEBMGS00\j2ee\os_libs;H:\usr\sap\OT4\DVEBMGS00\exe\sapjvm_6\bin;H:\usr\sap\OT4\DVEBMGS00\exe;H:\oracle\OT4\11203\bin;C:\Program Files\HP\NCU;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files\System Center Operations Manager 2007;c:\sapjvm_6\bin;H:\usr\sap\OT4\SYS\exe\uc\NTAMD64
F arg[28] = -Xmx3072m
F arg[29] = -Xss2097152
F ignore unrecognized options : no
F ********************************************************************************
F [Thr 8896] *** LOG => SfCJavaVm: Java VM started.
F ********************************************************************************
F Main method call:
F com/sap/engine/offline/OfflineToolStart.main()
F arg[ 0] = com.sap.engine.bootstrap.Bootstrap
F arg[ 1] = ./bootstrap
F arg[ 2] = -DSAPSTART=1
F arg[ 3] = -DSAPSYSTEM=00
F arg[ 4] = -DSAPSYSTEMNAME=OT4
F arg[ 5] = -DSAPMYNAME=SD01CUDB0105_OT4_00
F arg[ 6] = -DSAPPROFILE=\\SD01CUDB0105\sapmnt\OT4\SYS\profile\OT4_DVEBMGS00_SD01CUDB0105
F arg[ 7] = -DFRFC_FALLBACK=ON
F arg[ 8] = -DFRFC_FALLBACK_HOST=localhost
F ********************************************************************************
J
J Wed Nov 13 11:35:52 2013
J [GC 4032K->1186K(9984K), 0.0044557 secs]
J [GC 5218K->3154K(9984K), 0.0046435 secs]
J [GC 7186K->5507K(9984K), 0.0047799 secs]
J [Full GC 5507K->4487K(18432K), 0.0316717 secs]
J [GC 8519K->6800K(20224K), 0.0041487 secs]
F
F [Thr 8896] Wed Nov 13 11:35:53 2013
F [Thr 8896] *** LOG => State changed from 0 (Initial) to 2 (Starting framework).
F [Thr 8896] *** LOG state real time: 2.511 CPU time: 0.436 sys, 3.010 usr
F [Thr 8896] *** LOG total real time: 2.511 CPU time: 0.436 sys, 3.010 usr
F [Thr 8896]
J
J Wed Nov 13 11:35:53 2013
J [GC 12624K->8137K(22464K), 0.0043374 secs]
J [GC 16201K->9033K(25152K), 0.0029353 secs]
J
J Wed Nov 13 11:35:54 2013
J [GC 17161K->9289K(25152K), 0.0049348 secs]
J [GC 17417K->9001K(28096K), 0.0027388 secs]
J [GC 20137K->9532K(28096K), 0.0049524 secs]
J [GC 20668K->9982K(30208K), 0.0065648 secs]
F
F [Thr 8896] Wed Nov 13 11:35:55 2013
F [Thr 8896] *** LOG => State changed from 2 (Starting framework) to 5 (Stopping).
F [Thr 8896] *** LOG state real time: 2.293 CPU time: 0.140 sys, 3.447 usr
F [Thr 8896] *** LOG total real time: 4.804 CPU time: 0.577 sys, 6.458 usr
F [Thr 8896]
F
F [Thr 8176] Wed Nov 13 11:35:55 2013
F [Thr 8176] *** LOG => SfCJavaVm: exit hook is called. (rc = 558)
F
F ********************************************************************************
F *** ERROR => Java node 'Instance_bootstrap' terminated with exit code 558.
F ***
F *** Please see section 'Java program exit codes'
F *** in SAP Note 1316652 for additional information and trouble shooting advice.
F ********************************************************************************
F
F [Thr 8176] *** LOG => exiting (exitcode 558, retcode 1).
M [Thr 8176] CCMS: CCMS Monitoring Cleanup finished successfully.
*** ERROR => Java node 'Instance_bootstrap' terminated with exit code 558
The connection to the database is not working.
Have you update the password of the SAPSR3DB user in the secure store after changing it ?
If not you may open the configtool and update the password there and restart the system.
Regards
RB
RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage)
You may check this article as well
http://scn.sap.com/docs/DOC-46252
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok so its fixed.
Now here was my issue.
First off I used a department password with a @ sign that Oracle didnt like.
Thanks Adil
Hi Joshua,
Please check this note
1534597 - Using such special characters as "@" in a password
Regards
Adil
So then trying to set the passwords it where I had issues.
Because of 11g and the new secure store features.
running this command wasn't enough to reset:
brconnect -u system/password -c -f chpass -o SAPSR3 -p password
I had to be running this one:
brconnect -u system/password -c -f chpass -o SAPSR3 -p password -s abap -RDB
this also resets in the secure store in the file system.
now on top of it, my brconnect was older, it was at the version the OSS note says should work but didnt understand the -s switch so I downloaded the newest kernel and then it worked.
It got me past some, then i got an error on the DDIC test.
Had to delete SAP* from the tables, recreate it and then reset DDIC passwords.
Now its running abap reports and happy...but im expecting more errors yet.
thanks!
I get the following error when executing this command
brconnect -u system/password -c -f chpass -o SAPSR3DB -p password -s java -RDB
BR0801I BRCONNECT 7.20 (34)
BR0280I BRCONNECT time stamp: 2013-10-31 14.18.14
BR0828I Changing password for database user SAPSR3DB ...
BR0280I BRCONNECT time stamp: 2013-10-31 14.18.14
BR0829I Password changed successfully in database for user SAPSR3DB
BR0280I BRCONNECT time stamp: 2013-10-31 14.18.15
BR1525I Setting password for database user SAPSR3DB in secure storage H:\usr\sap
\OT4\SYS\global\security\data\SecStore.properties ...
BR0278E Command output of 'H:\usr\sap\OT4\SYS\exe\uc\NTAMD64\brtools.exe -f prin
tpwd -U H:\usr\sap\OT4\SYS\global\security\data\.java.pwf | H:\oracle\OT4\11203\
jdk\bin\java.exe -classpath H:\usr\sap\OT4\SYS\global\sltools\sharedlib\sap.com~
tc~bl~offline_launcher~impl.jar com.sap.engine.offline.OfflineToolStart com.sap.
inst.secstore.AdjustSecureStoreFS H:\usr\sap\OT4\SYS\global\sltools\sharedlib;H:
\usr\sap\OT4\SYS\global\security\lib\tools -sidSource OT4 -sidTarget OT4 -sec H:
\usr\sap\OT4\SYS\global\security\data\SecStore.properties -key H:\usr\sap\OT4\SY
S\global\security\data\SecStore.key -dbUser SAPSR3DB -useStdin -nomask':
INFO: Loading tool launcher...
INFO: [OS: Windows Server 2008] [VM vendor: Sun Microsystems Inc.] [VM versio
n: 1.5.0_30] [VM type: Java HotSpot(TM) 64-Bit Server VM]
FATAL: Current VM is not supported according to the specified compatibility li
st.
FATAL: com.sap.engine.offline.OfflineToolStart will abort now with exitcode 3
BR0280I BRCONNECT time stamp: 2013-10-31 14.18.15
BR0279E Return code from 'H:\usr\sap\OT4\SYS\exe\uc\NTAMD64\brtools.exe -f print
pwd -U H:\usr\sap\OT4\SYS\global\security\data\.java.pwf | H:\oracle\OT4\11203\j
dk\bin\java.exe -classpath H:\usr\sap\OT4\SYS\global\sltools\sharedlib\sap.com~t
c~bl~offline_launcher~impl.jar com.sap.engine.offline.OfflineToolStart com.sap.i
nst.secstore.AdjustSecureStoreFS H:\usr\sap\OT4\SYS\global\sltools\sharedlib;H:\
usr\sap\OT4\SYS\global\security\lib\tools -sidSource OT4 -sidTarget OT4 -sec H:\
usr\sap\OT4\SYS\global\security\data\SecStore.properties -key H:\usr\sap\OT4\SYS
\global\security\data\SecStore.key -dbUser SAPSR3DB -useStdin -nomask': 3
BR1527E Setting password for user SAPSR3DB in secure storage H:\usr\sap\OT4\SYS\
global\security\data\SecStore.properties failed
BR0832E Changing password for user SAPSR3DB failed
BR0280I BRCONNECT time stamp: 2013-10-31 14.18.15
BR0804I BRCONNECT terminated with errors
C:\Users\OT4ADM>
any ideas?
Hi Joshua,
Please check the following:
1686517 - J2EE engine startup fails due to current VM not supported error
Thanks
Adil
INFO: [OS: Windows Server 2008] [VM vendor: Sun Microsystems Inc.] [VM version: 1.5.0_30] [VM type: Java HotSpot(TM) 64-Bit Server VM]
FATAL: Current VM is not supported according to the specified compatibility list.
FATAL: com.sap.engine.offline.OfflineToolStart will abort now with exitcode 3
You should be using SAP JVM instead of the one from Sun Microsystems.
Regards
RB
Hi Joshua,
Please check this note
1534597 - Using such special characters as "@" in a password
Regards
Adil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.