on 11-10-2013 10:38 PM
Hello,
I´m doing a system copy/migration between to servers using the export/import method! I already did the export in source server/system (Windows 2012/MS SQL Server 2012) and now I´m doing the secound part of this process in target server where I´m doing the installation / system copy of source system in Windows Server 2008 (R2) with Oracle 11.2.0.2, but now I´m facing an error during the phase Start instance (phase 25 of 38), I´m using the SWPM tool.
I checked some log files like dev_disp and dev_w0:
- dev_disp:
...
DpAddSocketInfo: add info for nihdl 353 (pos/type/idx=44/4/0)
***LOG Q0K=> DpMsAttach, mscon ( WINTESTORA) [dpMessageSer 1513]
NiMyHostName: hostname = 'WINTESTORA'
NiHLGetNodeAddr: found hostname 'WINTESTORA' in cache
NiIGetNodeAddr: hostname 'WINTESTORA' = addr 169.254.46.3
*** WARNING => DpMsAttach: parameter 'rdisp/tolerate_loopback_addr' is set (cf. SAP note 1054467 for details) [dpMessageSer 1617]
NiIWrite: hdl 353 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIModState: change state to STARTING
NiIWrite: hdl 353 sent data (wrt=134,pac=1,MESG_IO)
...
- dev_w0:
...
M ThrRegisterSem: init SEM_CCMS_AS_MONI_KEY o.k.
M calling db_connect ...
B *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library
[dbcon.c 5902]
M ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 008192) [thDatabase.c 75]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c 2151]
M
M Info for wp 0
M
M pid = 2788
...
Regarding this warning: "*** WARNING => DpMsAttach: parameter 'rdisp/tolerate_loopback_addr' is set (cf. SAP note 1054467 for details)" it result because I faced a similar error before ( *** DP_FATAL_ERROR => DpMsAttach: local hostname 'xxx' is resolved to loopback address (cf. SAP Note 1054467 for details) *** DISPATCHER EMERGENCY SHUTDOWN ***) and what I did was set the parameter rdisp/tolerate_loopback_addr = yes and I also configured the loopback adpter for Windows Server 2008 (http://social.technet.microsoft.com/Forums/windowsserver/en-US/df1dbf9f-58fa-4ac1-b019-8f86863371b7/...) because I don´t have an IP configured in this server, is not connected to the internet!
Can you help me please?
Kind regards,
samid raif
HI,
Dispatcher is getting shutdown....
Regarding this warning: "*** WARNING => DpMsAttach: parameter 'rdisp/tolerate_loopback_addr' is set (cf. SAP note 1054467 for details)" it result because I faced a similar error before ( *** DP_FATAL_ERROR => DpMsAttach: local hostname 'xxx' is resolved to loopback address (cf. SAP Note 1054467 for details) *** DISPATCHER EMERGENCY SHUTDOWN ***) and what I did was set the parameter rdisp/tolerate_loopback_addr = yes and I also configured the loopback adpter for Windows Server 2008
Which user you have used to login to the system?it should be <sid>adm.
You can just reboot the server and check.
BR,
Prabhakar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I´m doing this copy in windows server 2008 (R2) logged with the other user different of <sid>adm because, first of all in the system copy guide it is mentioned that is not recommended to do this activity with <sid>adm and second because I hadn´t the <sid>adm user because this is a new server, where I´m installing this new system using a export database from the source server!
So... this SO user only have set the ORACLE_HOME environment variable and the TEMP and TMP! In the system variables, I see the PATH has the following entries:
C:\oracle\ORA\11202\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\
Any tips?
regards
samid raif
Have you for the entry dbms_type = ora in the default profile, check this note
556232 - Environment settings for R/3/Oracle on Windows
regards
kartik
Hello,
I set the parameter dbms_type = ora in the defaut profile. I start again the SWPM tool but it stopped again with the same error in the same phase! So, unfortunately that´s not the solution!
C:\usr\sap\ORA\SYS\exe\uc\NTAMD64>r3trans -d
This is r3trans version 6.24 (release 740 - 19.03.13 - 20:13:03 ).
unicode enabled version
sizeof(Selection_t) = 272
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
r3trans finished (0012).
- I open the trans.log file:
4 ETW000 r3trans version 6.24 (release 740 - 19.03.13 - 20:13:03 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 11.11.2013 - 13:10:24
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 Nov 11 13:10:24 2013 8070 0.008070
4 ETW000 [ dev trc,00000] db_con_init called 53 0.008123
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 611 0.008734
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 115 0.008849
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 19 0.008868
4 ETW000 [ D:/depot,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library
4 ETW000 614 0.009482
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
- I also ran the command disp+work -version to check the version of disp+work:
C:\usr\sap\ORA\SYS\exe\uc\NTAMD64>disp+work -version
--------------------
disp+work information
--------------------
kernel release 740
kernel make variant 740_REL
compiled on NT 6.0 6002 x86 MS VC++ 16.00 for NTAMD64
compiled for 64 BIT
compilation mode UNICODE
compile time Apr 11 2013 00:47:22
update level 0
patch number 12
source id 0.012
---------------------
supported environment
---------------------
database (SAP, table SVERS) 700
710
701
702
703
711
720
730
731
732
738
740
operating system
Windows NT 5.1
Windows NT 5.2
Windows NT 6.0
Windows NT 6.1
Windows NT 6.2
Any tips!? Can you help me please?!
Thank you,
samid raif
Hello Abhimanyu,
I did that, I set the dbms_type as environment system variable then I reboot the server. I started again the SWPM tool but once again the same error is show me in the same phase!
I check the dev_w0 log and I run again the r3trans -d:
- dev_w0:
...
B read_con_info_ssfs(): DBSL supports extended connect protocol
B ==> connect info for default DB will be read from ssfs
B *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Record with key "DB_CONNECT/DEFAULT_DB_USER" not found in secure storage <-- Data file "C:\usr\sap\ORA\SYS\global\security\rsecssfs\data\SSFS_ORA.DAT" does not exist or cannot be opened for read (this is not an error per se: a non-existing data file is a valid situation and treated equally as one without entries)
[dbcon.c 5435]
B *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS
[dbcon.c 4507]
M ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 75]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c 2151]
M
M Info for wp 0
M
M pid = 1884
...
- r3trans -d:
4 ETW000 r3trans version 6.24 (release 740 - 19.03.13 - 20:13:03 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 11.11.2013 - 14:30:55
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 Nov 11 14:30:55 2013 9143 0.009143
4 ETW000 [ dev trc,00000] db_con_init called 27 0.009170
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 572 0.009742
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 33 0.009775
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 15 0.009790
4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ... 42 0.009832
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, count 1, addr 000007FEF21D0000
4 ETW000 20410 0.030242
4 ETW000 [ dev trc,00000] using "C:\usr\sap\ORA\SYS\exe\uc\NTAMD64\dboraslib.dll" 18 0.030260
4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded 20 0.030280
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dboraslib.dll 23 0.030303
4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "740.09", patchlevel (0.11) 11104 0.041407
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dboraslib.dll 404 0.041811
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dboraslib.dll 8721 0.050532
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 172 0.050704
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 23 0.050727
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 21 0.050748
4 ETW000 [ dev trc,00000] New connection 0 created 16 0.050764
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 49 0.050813
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 24 0.050837
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 19 0.050856
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 27 0.050883
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 16 0.050899
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 38 0.050937
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='740')
4 ETW000 6176 0.057113
4 ETW000 [ D:/depot,00000] *** ERROR => Cannot connect: dbs/ora/tnsname in profile missing. 1735 0.058848
4 ETW000 [ dev trc,00000] DbSlConnect(con=-1) -> orc=0, 18=DBSL_ERR_CONNECT 568 0.059416
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 590 0.060006
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 29 0.060035
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 22 0.060057
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 26 0.060083
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 36 0.060119
4 ETW000 [ dev trc,00000] -> 'OCI_11201_SHARE, ' 22 0.060141
2EETW169 no connect possible: "DBMS = ORACLE --- TWO_TASK = ''"
Can you help me please?
Thank you
samid raif
Hello Prabhakar,
I tried other thing... I stopped the SWPM tool and I changed to the SO user <sid>adm and with the <sid>adm I tried to start the SAP system through the SAPMMC but the system show me an error in disp+work (stopped).
I checked the log files dev_w0 and dev_disp:
- In dev_w0 I see the following error and warning:
...
***LOG Q0K=> DpMsAttach, mscon ( WINTESTORA) [dpMessageSer 1513]
NiMyHostName: hostname = 'WINTESTORA'
NiHLGetNodeAddr: found hostname 'WINTESTORA' in cache
NiIGetNodeAddr: hostname 'WINTESTORA' = addr 169.254.46.3
*** WARNING => DpMsAttach: parameter 'rdisp/tolerate_loopback_addr' is set (cf. SAP note 1054467 for details) [dpMessageSer 1617]
NiIWrite: hdl 353 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIModState: change state to STARTING
NiIWrite: hdl 353 sent data (wrt=134,pac=1,MESG_IO)
MsINiWrite: sent 134 bytes
MsISnd2: send msg (ms hdr/msg 110/24 bytes) to name MSG_SERVER, type 0, key -
...
M ThrRegisterSem: init SEM_RTM_KEY o.k.
***LOG Q0K=> DpMsAttach, mscon ( WINTESTORA) [dpMessageSer 1513]
NiMyHostName: hostname = 'WINTESTORA'
NiHLGetNodeAddr: found hostname 'WINTESTORA' in cache
NiIGetNodeAddr: hostname 'WINTESTORA' = addr 169.254.46.3
*** WARNING => DpMsAttach: parameter 'rdisp/tolerate_loopback_addr' is set (cf. SAP note 1054467 for details) [dpMessageSer 1617]
NiIWrite: hdl 353 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIModState: change state to STARTING
NiIWrite: hdl 353 sent data (wrt=134,pac=1,MESG_IO)
MsINiWrite: sent 134 bytes
MsISnd2: send msg (ms hdr/msg 110/24 bytes) to name MSG_SERVER, type 0, key -
M severity = 0
- In dev_disp log file I only see the following warning:
...
***LOG Q0K=> DpMsAttach, mscon ( WINTESTORA) [dpMessageSer 1513]
NiMyHostName: hostname = 'WINTESTORA'
NiHLGetNodeAddr: found hostname 'WINTESTORA' in cache
NiIGetNodeAddr: hostname 'WINTESTORA' = addr 169.254.46.3
*** WARNING => DpMsAttach: parameter 'rdisp/tolerate_loopback_addr' is set (cf. SAP note 1054467 for details) [dpMessageSer 1617]
NiIWrite: hdl 353 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIModState: change state to STARTING
NiIWrite: hdl 353 sent data (wrt=134,pac=1,MESG_IO)
MsINiWrite: sent 134 bytes
MsISnd2: send msg (ms hdr/msg 110/24 bytes) to name MSG_SERVER, type 0, key -
- I ran r3trans -d and the output is this:
C:\>r3trans -d
This is r3trans version 6.24 (release 740 - 19.03.13 - 20:13:03 ).
unicode enabled version
sizeof(Selection_t) = 272
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'ORA'"
r3trans finished (0012).
- The file trans.log show me this:
4 ETW000 r3trans version 6.24 (release 740 - 19.03.13 - 20:13:03 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 11.11.2013 - 15:27:04
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 Nov 11 15:27:04 2013 82 0.000082
4 ETW000 [ dev trc,00000] db_con_init called 31 0.000113
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 59 0.000172
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 28 0.000200
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 15 0.000215
4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ... 44 0.000259
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, count 1, addr 000007FEF4300000
4 ETW000 455 0.000714
4 ETW000 [ dev trc,00000] using "C:\usr\sap\ORA\SYS\exe\uc\NTAMD64\dboraslib.dll" 17 0.000731
4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded 20 0.000751
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dboraslib.dll 20 0.000771
4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "740.09", patchlevel (0.11) 70 0.000841
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dboraslib.dll 23 0.000864
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dboraslib.dll 45 0.000909
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 161 0.001070
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 22 0.001092
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 21 0.001113
4 ETW000 [ dev trc,00000] New connection 0 created 16 0.001129
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 48 0.001177
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 24 0.001201
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 18 0.001219
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 27 0.001246
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 16 0.001262
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 39 0.001301
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 72 0.001373
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0
4 ETW000 43 0.001416
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol 28 0.001444
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): profile parameter auth/shadow_upgrade is not set ==> connect info for shadow upgrade will not be read with an extra upgrade key set
4 ETW000 44 0.001488
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2
4 ETW000 25 0.001513
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 874]
4 ETW000 60 0.001573
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 4448]
4 ETW000 38088 0.039661
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\WINTESTORA\sapmnt\ORA\SYS\global\security\rsecssfs\data\SSFS_ORA.DAT" opened for read [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 2563]
4 ETW000 429 0.040090
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\WINTESTORA\sapmnt\ORA\SYS\global\security\rsecssfs\key\SSFS_ORA.KEY" not found, using default key [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 1426]
4 ETW000 255 0.040345
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 942]
4 ETW000 453 0.040798
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 31 0.040829
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 19 0.040848
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2
4 ETW000 26 0.040874
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 874]
4 ETW000 36 0.040910
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 4448]
4 ETW000 89 0.040999
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\WINTESTORA\sapmnt\ORA\SYS\global\security\rsecssfs\data\SSFS_ORA.DAT" opened for read [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 2563]
4 ETW000 348 0.041347
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\WINTESTORA\sapmnt\ORA\SYS\global\security\rsecssfs\key\SSFS_ORA.KEY" not found, using default key [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 1426]
4 ETW000 212 0.041559
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 942]
4 ETW000 373 0.041932
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 30 0.041962
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 18 0.041980
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2
4 ETW000 26 0.042006
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 874]
4 ETW000 35 0.042041
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 4448]
4 ETW000 87 0.042128
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\WINTESTORA\sapmnt\ORA\SYS\global\security\rsecssfs\data\SSFS_ORA.DAT" opened for read [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 2563]
4 ETW000 335 0.042463
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\WINTESTORA\sapmnt\ORA\SYS\global\security\rsecssfs\key\SSFS_ORA.KEY" not found, using default key [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 1426]
4 ETW000 202 0.042665
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\WINTESTORA\sapmnt\ORA\SYS\global\security\rsecssfs\data\SSFS_ORA.DAT" exists, but does not contain the requested entry [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 2587]
4 ETW000 139 0.042804
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 2590]
4 ETW000 46 0.042850
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 <-- Data file "\\WINTESTORA\sapmnt\ORA\SYS\global\security\rsecssfs\data\SSFS_ORA.DAT" exists, but does not contain the requested entry) [D:/depot/bas/740_REL/src/krn/rsec/rsecssfs.c 942]
4 ETW000 183 0.043033
4 ETW000 [ dev trc,00000] read_ssfs_record(): not found is accepted, RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage <-- Data file "\\WINTESTORA\sapmnt\ORA\SYS\global\security\rsecssfs\data\SSFS_ORA.DAT" exists, but does not contain the requested entry
4 ETW000 47 0.043080
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 18 0.043098
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=0, type=0, env='[default env]', usr='SAPSR3', kernel dbsl='740')
4 ETW000 202 0.043300
4 ETW000 [ dev trc,00000] DIR_CLIENT_ORAHOME is not set as profile nor env. parameter. 258 0.043558
4 ETW000 Assuming using instant client with unspecified location.
4 ETW000 [ dev trc,00000] Register application info. 73 0.043631
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.2.0, (dbsl 740 220313, UNICODE[2]) 9356 0.052987
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available. 41 0.053028
4 ETW000 [ dev trc,00000] Default connection: tnsname ='ORA' 22 0.053050
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 36 0.053086
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 19938 0.073024
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=03C1F858) 61 0.073085
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=03C208D8) 36 0.073121
4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 81 0.073202
4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 26 0.073228
4 ETW000 [ dev trc,00000] char=55005400460031003600 22 0.073250
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 31 0.073281
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 23 0.073304
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@ORA on connection 0 (nls 0) ... (dbsl 740 220313, UNICODE[2])
4 ETW000 52 0.073356
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=03C20788) 31 0.073387
4 ETW000 [ dev trc,00000] Allocating server context handle 23 0.073410
4 ETW000 [ dev trc,00000] Attaching to database server ORA (con=0, svchp=03C20788, srvhp=03C21010)
4 ETW000 56 0.073466
4 ETW000 [ dev trc,00000] Assigning server context 03C21010 to service context 03C20788 14943 0.088409
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=03C2FC40) 84 0.088493
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp=03C2FC40 29 0.088522
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=03C2FC40 34 0.088556
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=03C20788, srv=03C21010, usr=03C2FC40)
4 ETW000 147 0.088703
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 3091 0.091794
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034: 114 0.091908
4 ETW000 [ dev trc,00000] ORA-01034: ORACLE not available 31 0.091939
4 ETW000 ORA-27101: shared memory realm does not exist
4 ETW000 [ dev trc,00000] server_detach(con=0,stale=1,srvhp=03C21010) 96 0.092035
4 ETW000 [ dev trc,00000] Server handle (con=0,svchp=03C20788,srvhp=03C21010) detached 633 0.092668
4 ETW000 [ dev trc,00000] Free server handle srvhp=03C21010 of con=0 44 0.092712
4 ETW000 [ D:/depot,00000] *** ERROR => CONNECT failed with sql error '1034' 77 0.092789
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1034 29 0.092818
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1034) 45 0.092863
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1034 111 0.092974
4 ETW000 [ dev trc,00000] ORA-01034: ORACLE not available 29 0.093003
4 ETW000 ORA-27101: shared memory realm does not exist
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 36 0.093039
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1034 performing CON 46 0.093085
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01034: ORACLE not available 27 0.093112
4 ETW000 ORA-27101: shared memory realm does not exist
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 37 0.093149
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 23 0.093172
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 22 0.093194
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 28 0.093222
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 25 0.093247
4 ETW000 [ dev trc,00000] -> 'OCI_11201_SHARE, 11.2.0.2.0' 21 0.093268
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'ORA'"
So... this is logged with <sid>adm (oraadm) user even so the system can start! But as I said before I must continue the installation/system copy with Software Provisioning Manager (SWPM) with the other SO user as recomended by SAP!
Can you help me please, how to solve this problem!?
Kind regards,
samid raif
Can you please also check this SAP Note.
1921560 - <sid>adm environment variable is not read when SAP starting
best regards
ashish
Hi,
So it seems that oracle database is not up, then please try to startup
database once again and attach to this message the whole oracle alert
log.
Error 1034 in the logs is followed by
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Please make sure, the database is installed correctly.
Possible reasons for above mentioned errors are listed in note
491174- "Composite SAP note for ORA-01034"
Regards,
Aidan
Hi,
Have you tried the steps that were told to you .
Try the below steps.
Shut down SAP processes again .
Re-initiated the .profile and environment variables
If required you can restart the windows to clean memory segment.
Restart the application manually.
Another thing is the oracle running.
4 ETW000 [ dev trc,00000] ORA-01034: ORACLE not available 31 0.091939
4 ETW000 ORA-27101: shared memory realm does not exist
4 ETW000 [ dev trc,00000] server_detach(con=0,stale=1,srvhp=03C21010) 96 0.092035
4 ETW000 [ dev trc,00000] Server handle (con=0,svchp=03C20788,srvhp=03C21010) detached 633 0.092668
As you are using SSFS please cehck the below note if oracle is up and running.
1860519 - SAP fails to connect to the database
1622837 - Secure connection of AS ABAP to Oracle via SSFS
SAP Note #1639578 explains the new SSFS system and provides the steps necessary to configure this on your system. Once this is setup and the required secure files with the credentials are on place this should help you past this error:
-> Pay attention that the environment variable rsdb_ssfs_connect = 1 should be entered in lower case
-> R3trans -d should work by then and SSF should be picked up
You need to restart SAP system after adding the rsdb/ssfs_connect = 1 entry to the profile, in order to be taken into account.
Once that is done, R3trans will pickup on that profile parameter and will use the SSFS method.
Thanks
RishI abrol
Hello ashish,
The problem is solved!
I followed the advice of ashish vikas and I read the note 1921560 (<sid> adm environment variable is not read When starting SAP)
In fact there were no variables loaded on the regedit location HKEY_LOCAL_MACHINE\SOFTWARE\SAP\<SID>\Environment.
In the note 1921560, it is mentioned that the user SAPService<SID> (SAPServiceORA) must be added to the Administrators group of the server, and so I added the SAPServiceORA to the Windows Administrators group and then I logged as user <sid>adm and I tried via SAPMMC start the system (but it returned to give the error in the same phase) but after this I already see that environment variables had been loaded in regedit:
HKEY_LOCAL_MACHINE\SOFTWARE\SAP\<SID>\Environment
After, I logged on server with the user that I used to run the system copy (with SWPM tool) and I returned to run the SWPM tool! But again it show me the same error on the same stage!
So, I checked again the log files (dev_w0) and I realized that now the problem it is related to other cause! Now the problem was related to the Oracle Listener service that was stopped! I started it manually in services (services.msc).
I ran again the SWPM tool and now finally the error in phase Start Instance was overcome!
So, many thanks to you all that tried to help me!
Kind regards,
samid raif
Hi Samid,
For SWPM pls find the below note ...
1913755 - Error "Unsupported major.minor version 49.0" using SAPinst / Software Provisioning Manager
BR,
Prabhakar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
refer this note & links
SAP Note 153433
http://service.sap.com/instguides
http://sdn.sap.com/irj/sdn/systemcopy.
Regard
Nayeem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use this link,
http://help.sap.com/saphelp_46c/helpdata/en/3d/ad5bc24ebc11d182bf0000e829fbfe/fra
If r3trans is running correct,try updating the kernel.
BR,
Prabhakar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For the following error: ERROR => Invalid profile parameter dbms/type
Please check your environment variables according to the note #556232.
Regards,
Aidan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you set dbms/type = ora in the default profile. Please also check the env variables of SID adm.
What is the output of R3trans-d. is the database up and running.
can you manually start the system.
Try the below steps.
Shut down SAP processes again .
Re-initiated the .profile and environment variables
If required you can restart the windows to clean memory segment.
Restart the application manually.
Then go with system copy resume.
Thanks
Rishi Abrol
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.