Добрый день, коллеги!

Попросили оживить недавно установленную NW 7.31 (Linux Red Hat, Oracle)
С Линуксом знаком слабо, прошу помощи более опытных коллег.

Судя по всему CI не может подключиться к Ораклу (пароль\юзер).

Через SQLPLUS SYSTEM к базе подключаюсь, пароль принимается. Startup, shutdown работают. А SAP не стартует


В trans.log вижу следующее:

4 ETW000 [ dev trc,00000] Mon Oct 28 11:49:53 2013 10006093 10.042019
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 22 10.042041
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 81 10.042122
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 19 10.042141
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 17 10.042158
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 15 10.042173
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 13 10.042186
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 55 10.042241
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 17 10.042258
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 15 10.042273
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 27 10.042300
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 13 10.042313
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'EWM'"

1639578 - SSFS as password storage for primary database connect
1622837 - Secure connection of AS ABAP to Oracle via SSFS

400241 - Problems with ops$ or sapr3 connect to Oracle
50088 - Creating OPS$ users on Windows NT/Oracle

З.ы. если хотите конкретного совета, бросьте весь trans.log

msk-sap3:oraewm 41> R3trans -d
This is R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'EWM'"
R3trans finished (0012).
msk-sap3:oraewm 42> cat 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 : 29.10.2013 - 12:06:38
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] Tue Oct 29 12:06:38 2013 52 0.000052
4 ETW000 [ dev trc,00000] db_con_init called 15 0.000067
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 18 0.000085
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 16 0.000101
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 10 0.000111
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/EWM/SYS/exe/run/dboraslib.so' ... 25 0.000136
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/EWM/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 5385 0.005521
4 ETW000 [ dev trc,00000] Library '/usr/sap/EWM/SYS/exe/run/dboraslib.so' loaded 14 0.005535
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 20 0.005555
4 ETW000 [ dev trc,00000] Version of '/usr/sap/EWM/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.114)
4 ETW000 48 0.005603
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 19 0.005622
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 30 0.005652
4 ETW000 [ dev trc,00000] New connection 0 created 22 0.005674
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 23 0.005697
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 13 0.005710
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 12 0.005722
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 8 0.005730
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 18 0.005748
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 11 0.005759
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol 12 0.005771
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 23 0.005794
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 836] 22 0.005816
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3664]
4 ETW000 12741 0.018557
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/EWM/SYS/global/security/rsecssfs/data/SSFS_EWM.DAT" cannot be opened for read [rsecssfs.c 2198]
4 ETW000 41 0.018598
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/EWM/SYS/global/security/rsecssfs/data/SSFS_EWM.DAT" cannot be opened for read) [rsecssfs.c 897]
4 ETW000 25 0.018623
4 ETW000 [ dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/EWM/SYS/global/security/rsecssfs/data/SSFS_EWM.DAT" cannot be opened for read
4 ETW000 26 0.018649
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 8 0.018657
4 ETW000 [ dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS
4 ETW000 16 0.018673
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'EWM'"
msk-sap3:oraewm 43>

msk-sap3:oraewm
R3trans -d надо выполнять под <sid>adm, отсюда ошибка:


ошибки в первом и втором посте - разные.
выкладывайте лог под сидадм-ом

[root@alp-msk-sap3 ~]# su - ewmadm
msk-sap3:ewmadm 20> cat 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 : 28.10.2013 - 11:49:43
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] Mon Oct 28 11:49:43 2013 52 0.000052
4 ETW000 [ dev trc,00000] db_con_init called 15 0.000067
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 18 0.000085
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 15 0.000100
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 11 0.000111
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/EWM/SYS/exe/run/dboraslib.so' ... 24 0.000135
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/EWM/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 5405 0.005540
4 ETW000 [ dev trc,00000] Library '/usr/sap/EWM/SYS/exe/run/dboraslib.so' loaded 14 0.005554
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 22 0.005576
4 ETW000 [ dev trc,00000] Version of '/usr/sap/EWM/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.114)
4 ETW000 42 0.005618
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 16 0.005634
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 31 0.005665
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 16 0.005681
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 14 0.005695
4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 13 0.005708
4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/EWM/SYS/exe/run/dboraslib.so
4 ETW000 12 0.005720
4 ETW000 [ dev trc,00000] New connection 0 created 15 0.005735
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 30 0.005765
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 13 0.005778
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 19 0.005797
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 8 0.005805
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 23 0.005828
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 11 0.005839
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol 12 0.005851
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 16 0.005867
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 836] 25 0.005892
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3664]
4 ETW000 11908 0.017800
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/EWM/SYS/global/security/rsecssfs/data/SSFS_EWM.DAT" opened for read [rsecssfs.c 2202]
4 ETW000 45 0.017845
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/EWM/SYS/global/security/rsecssfs/key/SSFS_EWM.KEY" not found, using default key [rsecssfs.c 1246]
4 ETW000 35 0.017880
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 897]
4 ETW000 188 0.018068
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 14 0.018082
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 836] 12 0.018094
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3664]
4 ETW000 32 0.018126
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/EWM/SYS/global/security/rsecssfs/data/SSFS_EWM.DAT" opened for read [rsecssfs.c 2202]
4 ETW000 37 0.018163
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/EWM/SYS/global/security/rsecssfs/key/SSFS_EWM.KEY" not found, using default key [rsecssfs.c 1246]
4 ETW000 22 0.018185
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 897]
4 ETW000 137 0.018322
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 13 0.018335
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 836] 12 0.018347
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3664]
4 ETW000 35 0.018382
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/EWM/SYS/global/security/rsecssfs/data/SSFS_EWM.DAT" opened for read [rsecssfs.c 2202]
4 ETW000 34 0.018416
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/EWM/SYS/global/security/rsecssfs/key/SSFS_EWM.KEY" not found, using default key [rsecssfs.c 1246]
4 ETW000 22 0.018438
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 24 0.018462
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 28 0.018490
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 14 0.018504
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 8 0.018512
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=0, type=0, env='[default env]', userid='SAPSR3')
4 ETW000 136 0.018648
4 ETW000 [ dev trc,00000] Register application info. 149 0.018797
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 720 081211, UNICODE[2])
4 ETW000 41 0.018838
4 ETW000 [ dev trc,00000] Installed Oracle client patches: 24 0.018862
4 ETW000 [ dev trc,00000] # Patch 13508485 : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT
4 ETW000 20 0.018882
4 ETW000 [ dev trc,00000] # Patch Description: Created on 3 Jan 2012, 02:50:27 hrs PST8PDT 18 0.018900
4 ETW000 [ dev trc,00000] # Patch 11742262 : Created on 7 Mar 2012, 12:22:41 hrs CET 22 0.018922
4 ETW000 [ dev trc,00000] Default connection: tnsname ='EWM' 11 0.018933
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 19 0.018952
4 ETW000 [ dev trc,00000] (-) OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 3362 0.022314
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=2f6ca98) 28 0.022342
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=2f6dd28) 18 0.022360
4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 58 0.022418
4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 18 0.022436
4 ETW000 [ dev trc,00000] char=55005400460031003600 14 0.022450
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 22 0.022472
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 11 0.022483
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@EWM on connection 0 (nls 0) ... (dbsl 720 081211, UNICODE[2])
4 ETW000 22 0.022505
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=2f6dc48) 18 0.022523
4 ETW000 [ dev trc,00000] Allocating server context handle 12 0.022535
4 ETW000 [ dev trc,00000] Attaching to database server EWM (con=0, svchp=2f6dc48, srvhp=2f70f00)
4 ETW000 34 0.022569
4 ETW000 [ dev trc,00000] Assigning server context 2f70f00 to service context 2f6dc48 13131 0.035700
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=2f9f3b0) 54 0.035754
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp= 2f9f3b0 15 0.035769
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=2f9f3b0 23 0.035792
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=2f6dc48, srv=2f70f00, usr=2f9f3b0)
4 ETW000 134 0.035926
4 ETW000 [ dev trc,00000] Mon Oct 28 11:49:53 2013 10006093 10.042019
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 22 10.042041
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 81 10.042122
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 19 10.042141
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 17 10.042158
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 15 10.042173
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 13 10.042186
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 55 10.042241
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 17 10.042258
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 15 10.042273
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 27 10.042300
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 13 10.042313
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'EWM'"
msk-sap3:ewmadm 21>

Пробегитесь по ноте
1576837 - ORA-01017: invalid username/password;

Попытался согласно ноте обновить пароль.
msk-sap3:oraewm 44> brconnect -u system/ewmpass1 -f chpass -o SAPSR3 -p ewmpass1
BR0801I BRCONNECT 7.20 (17)

BR0280I BRCONNECT time stamp: 2013-10-29 13.57.27
BR0828I Changing password for database user SAPSR3

BR0280I BRCONNECT time stamp: 2013-10-29 13.57.27
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:
c
BR0280I BRCONNECT time stamp: 2013-10-29 13.57.35
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRCONNECT time stamp: 2013-10-29 13.57.35
BR0829I Password changed successfully in database for user SAPSR3
BR0831W Table SAPUSER not found for user SAPSR3

BR0280I BRCONNECT time stamp: 2013-10-29 13.57.35
BR0803I BRCONNECT completed successfully with warnings
msk-sap3:oraewm 45>





Смущает вот это: BR0831W Table SAPUSER not found for user SAPSR3


И еще - только что глянул что Oracle стоит версии 11.2.

я так понимаю, что не помогло?

в этой ноте, есть описание относительно SAPSR3 в SAPUSER (не к этой проблеме, а впринципе)

400241 - Problems with ops$ or sapr3 connect to Oracle

Да, не помогло. Наверное будет проще переустановить систему. Она все равно пустая.

меня смущает BRCONNECT 7.20 (17) ...
согласно Corrections in BR*Tools Version 7.20 текущая версия - 34
ну и раз у вас линукс, то посмотрите ORA-01017/ORA-01031 in BR*Tools on Linux and Solaris 11
тоже весьма полезная нота

Меня больше это смущает, может сюда и копать?

Насколько я понимаю, Key file "/usr/sap/EWM/SYS/global/security/rsecssfs/key/SSFS_EWM.KEY" not found - его тут и не должно быть, т.к. используем дефолтную аутентификацию.

На соседней инсталлации, на этом же сервере, подобного ключа тоже нет, но система работает прекрасно.

на ключ можно не обращать внимания, т.к.

нужно проверить, явдляется ли владельцем /usr/sap/EWM/SYS/global/security/rsecssfs/... <sid>adm
установлен ли в профиле пользователя и в дефолтном профиле


а ещё бы я обратил внимание опять таки на brtools, а именно синхронизированы ли они в SYS и в каталоге инстанции
(ну это для тех случаев, когда базиснику в лом выполнить все инструкции по апдейту кернела, а именно
su
root# saproot.sh <SID>)

BrTools работает, через него старт и стоп БД проходит упешно, бекап черз BrTools тоже проходит успешно.
root# saproot.sh <SID> делали.

Дефолтный профиль:

[root@msk-sap3 profile]# cat DEFAULT.PFL
SAPDBHOST = msk-sap3
j2ee/dbtype = ora
j2ee/dbname = EWM
j2ee/dbhost = msk-sap3
SAPSYSTEMNAME = EWM
SAPGLOBALHOST = msk-sap3
system/type = ABAP
SAPFQDN = alpe.local
SAPLOCALHOSTFULL = $(SAPLOCALHOST).$(SAPFQDN)
rdisp/mshost = msk-sap3
rdisp/msserv = sapmsEWM
rdisp/msserv_internal = 3901
enque/process_location = REMOTESA
enque/serverhost = msk-sap3
enque/serverinst = 01
is/HTTP/show_detailed_errors = FALSE
icf/user_recheck = 1
gw/acl_mode = 1
icm/HTTP/ASJava/disable_url_session_tracking = TRUE
service/protectedwebmethods = SDEFAULT
rsec/ssfs_datapath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)data
rsec/ssfs_keypath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)key
rsdb/ssfs_connect = 1
ssf/name = SAPSECULIB
vmcj/enable = off
login/system_client = 001
rdisp/TRACE = 2
rdisp/bufrefmode = sendoff
rdisp/autoabaptime = 0
rdisp/btctime = 0
[root@msk-sap3 profile]#


Переменные среды окружения:

[root@msk-sap3 profile]# set
BASH=/bin/bash
BASHOPTS=checkwinsize:cmdhist:expand_aliases:extquote:force_fignore:hostcomplete:interactive_comments:login_shell:progcomp:promptvars:sourcepath
BASH_ALIASES=()
BASH_ARGC=()
BASH_ARGV=()
BASH_CMDS=()
BASH_LINENO=()
BASH_SOURCE=()
BASH_VERSINFO=([0]="4" [1]="1" [2]="2" [3]="1" [4]="release" [5]="x86_64-redhat-linux-gnu")
BASH_VERSION='4.1.2(1)-release'
COLORS=/etc/DIR_COLORS
COLUMNS=131
CVS_RSH=ssh
DIRSTACK=()
EUID=0
GROUPS=()
G_BROKEN_FILENAMES=1
HISTCONTROL=ignoredups
HISTFILE=/root/.bash_history
HISTFILESIZE=1000
HISTSIZE=1000
HOME=/root
HOSTNAME=msk-sap3
HOSTTYPE=x86_64
ID=0
IFS=$' \t\n'
LANG=en_US.UTF-8
LESSOPEN='|/usr/bin/lesspipe.sh %s'
LINES=40
LOGNAME=root
LS_COLORS='rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:'
MACHTYPE=x86_64-redhat-linux-gnu
MAIL=/var/spool/mail/root
MAILCHECK=60
OLDPWD=/usr/sap/EWM/SYS
OPTERR=1
OPTIND=1
OSTYPE=linux-gnu
PATH=/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
PIPESTATUS=([0]="127")
PPID=21549
PROMPT_COMMAND='printf "\033]0;%s@%s:%s\007" "${USER}" "${HOSTNAME%%.*}" "${PWD/#$HOME/~}"'
PS1='[\u@\h \W]\$ '
PS2='> '
PS4='+ '
PWD=/usr/sap/EWM/SYS/profile
QTDIR=/usr/lib64/qt-3.3
QTINC=/usr/lib64/qt-3.3/include
QTLIB=/usr/lib64/qt-3.3/lib
SELINUX_LEVEL_REQUESTED=
SELINUX_ROLE_REQUESTED=
SELINUX_USE_CURRENT_RANGE=
SHELL=/bin/bash
SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments:monitor
SHLVL=1
SSH_CLIENT='192.168.1.3 24005 22'
SSH_CONNECTION='192.168.1.3 24005 192.168.1.65 22'
SSH_TTY=/dev/pts/0
TERM=xterm
UID=0
USER=root
_=cls
colors=/etc/DIR_COLORS
[root@msk-sap3 profile]#

САП система стартует под пользователем <sid>adm
в его профиле должны быть настройки
и после того, как выполните root# saproot.sh <SID>
<sid>adm еще раз установите права для SAPSR3
потому как в этом раз brconnect учтет принадлежность самого себя группе dba