Skip to Content
0

Oracle & dispatcher not starting

Nov 17, 2016 at 09:13 AM

201

avatar image

Dear experts,

oracle not starting & sap is down kindly help

getting following error in R3tans output

C:\Users\tcpadm>R3trans -d
This is R3trans version 6.24 (release 721 - 14.10.14 - 20:14:08).
unicode enabled version
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o
ra_tnsname = 'TCP'"
R3trans finished (0012).

10 |10000 characters needed characters left characters exceeded

Dear Mohsin,

If the database is down you need to focus on bringing it up.

SAP cannot start if the database is down.

Please share more information about the database (any errors observed when trying to start it?; share the "trans.log" file that was created at the folder "C:\Users\tcpadm"; ...), so the Oracle experts can assist you.

Regards,

Isaías

1

Hi,

Go to sqlplus and start your database, start listener and then try to start SAP.

Paste the error if you get at any step mentioned above.

Regards,

Harish Karra

0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

mohsin khan Nov 17, 2016 at 11:54 AM
0

Dear Isaias,

Thanks for reply..

please find below details of trans.log file

4 ETW000 r3trans version 6.24 (release 721 - 14.10.14 - 20:14:08).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 17.11.2016 - 01:17:35
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 Nov 17 01:17:35 2016 125 0.000125
4 ETW000 [ dev trc,00000] db_con_init called 100 0.000225
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 103 0.000328
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 146 0.000474
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 21 0.000495
4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ... 46 0.000541
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 00007FFC5AE90000
4 ETW000 1404 0.001945
4 ETW000 [ dev trc,00000] using "F:\usr\sap\TCP\SYS\exe\uc\NTAMD64\dboraslib.dll" 23 0.001968
4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded 26 0.001994
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dboraslib.dll 25 0.002019
4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "721.02", patchlevel (0.331) 158 0.002177
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dboraslib.dll 27 0.002204
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dboraslib.dll 50 0.002254
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 144 0.002398
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 27 0.002425
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 25 0.002450
4 ETW000 [ dev trc,00000] New connection 0 created 19 0.002469
4 ETW000 [ dev trc,00000] 00: name=R/3, con_id=-000000001, state=DISCONNECTED, tx=NO , bc=NO , hc=NO , perm=YES, reco=NO , info=NO ,
4 ETW000 timeout=000, con_max=255, con_opt=255, occ=NO , prog= 43 0.002512
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 35 0.002547
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 27 0.002574
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 34 0.002608
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 21 0.002629
4 ETW000 [ dev trc,00000] 00: name=R/3, con_id=000000000, state=DISCONNECTED, tx=NO , bc=NO , hc=NO , perm=YES, reco=NO , info=NO ,
4 ETW000 timeout=000, con_max=255, con_opt=255, occ=NO , prog= 42 0.002671
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 22 0.002693
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 115 0.002808
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 42 0.002850
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 41 0.002891
4 ETW000 ==> Using default key set to get connect info from ssfs
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 42 0.002933
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872] 51 0.002984
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4635]
4 ETW000 107 0.003091
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\CMSAPUATSRV\sapmnt\TCP\SYS\global\security\rsecssfs\data\SSFS_TCP.DAT" opened for read [rsecssfs.c 2761]
4 ETW000 2115 0.005206
4 ETW000 [ dev trc,00000] RSecSSFs: File "\\CMSAPUATSRV\sapmnt\TCP\SYS\global\security\rsecssfs\key\SSFS_TCP.KEY" cannot be opened in mode "rb": No such file or directory (errno = 2); at this location, this is not considered an error [rsecssfs.c 1188]
4 ETW000 660 0.005866
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\CMSAPUATSRV\sapmnt\TCP\SYS\global\security\rsecssfs\key\SSFS_TCP.KEY" not found, using default key [rsecssfs.c 1635]
4 ETW000 52 0.005918
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 940]
4 ETW000 685 0.006603
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 40 0.006643
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 23 0.006666
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 31 0.006697
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872] 31 0.006728
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4635]
4 ETW000 99 0.006827
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\CMSAPUATSRV\sapmnt\TCP\SYS\global\security\rsecssfs\data\SSFS_TCP.DAT" opened for read [rsecssfs.c 2761]
4 ETW000 1263 0.008090
4 ETW000 [ dev trc,00000] RSecSSFs: File "\\CMSAPUATSRV\sapmnt\TCP\SYS\global\security\rsecssfs\key\SSFS_TCP.KEY" cannot be opened in mode "rb": No such file or directory (errno = 2); at this location, this is not considered an error [rsecssfs.c 1188]
4 ETW000 535 0.008625
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\CMSAPUATSRV\sapmnt\TCP\SYS\global\security\rsecssfs\key\SSFS_TCP.KEY" not found, using default key [rsecssfs.c 1635]
4 ETW000 122 0.008747
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 940]
4 ETW000 599 0.009346
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 40 0.009386
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 22 0.009408
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 32 0.009440
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872] 29 0.009469
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4635]
4 ETW000 98 0.009567
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\CMSAPUATSRV\sapmnt\TCP\SYS\global\security\rsecssfs\data\SSFS_TCP.DAT" opened for read [rsecssfs.c 2761]
4 ETW000 1134 0.010701
4 ETW000 [ dev trc,00000] RSecSSFs: File "\\CMSAPUATSRV\sapmnt\TCP\SYS\global\security\rsecssfs\key\SSFS_TCP.KEY" cannot be opened in mode "rb": No such file or directory (errno = 2); at this location, this is not considered an error [rsecssfs.c 1188]
4 ETW000 505 0.011206
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\CMSAPUATSRV\sapmnt\TCP\SYS\global\security\rsecssfs\key\SSFS_TCP.KEY" not found, using default key [rsecssfs.c 1635]
4 ETW000 52 0.011258
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2783]
4 ETW000 175 0.011433
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 940]
4 ETW000 282 0.011715
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
4 ETW000 45 0.011760
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 24 0.011784
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=0, type=0, env='[default env]', usr='SAPSR3', kernel dbsl='721')
4 ETW000 211 0.011995
4 ETW000 [ dev trc,00000] DIR_CLIENT_ORAHOME is not set as profile nor env. parameter. 311 0.012306
4 ETW000 [ dev trc,00000] Register application info. 100 0.012406
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.4.0, (dbsl 721 231014, UNICODE[2]) 23741 0.036147
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available. 52 0.036199
4 ETW000 [ dev trc,00000] Default connection: tnsname ='TCP' 25 0.036224
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 68 0.036292
4 ETW000 [ dev trc,00000] (-) OCIEnvCreate(mode=16384=OCI_UTF16) -> rc=0, env=03CD9080 (for default NLS hdl)
4 ETW000 65459 0.101751
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, env=03CD9080) -> err=03CE6DE8, er2=03CE7E68, bat=03CE8EE8
4 ETW000 109 0.101860
4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 111 0.101971
4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 30 0.102001
4 ETW000 [ dev trc,00000] char=55005400460031003600 27 0.102028
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 37 0.102065
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 25 0.102090
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@TCP on connection 0 (nls 0) ... (dbsl 721 231014, UNICODE[2])
4 ETW000 67 0.102157
4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0): New service handle svc=03CEAD00, rc=0 40 0.102197
4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0,svc=03CEAD00): New server hdl. srv=03CEAEA0, rc=0
4 ETW000 74 0.102271

Share
10 |10000 characters needed characters left characters exceeded
mohsin khan Nov 18, 2016 at 07:36 AM
0

Dear Harish,

while starting oracle getting following error.

SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>

Thanks

Share
10 |10000 characters needed characters left characters exceeded
Prithviraj Rajpurohit Nov 18, 2016 at 09:51 AM
0

Hi Mohsin

Please go through below thread if that helps

https://archive.sap.com/discussions/thread/3602928

and sapnote https://launchpad.support.sap.com/#/notes/1960805/E

Regards

Prithviraj

Share
10 |10000 characters needed characters left characters exceeded
Reagan Benjamin
Nov 21, 2016 at 11:27 PM
0

There is very little information to help you. If the Listener doesn't start then supply the error messages to help you. Have you made any changes to the server prior to this? If possible restart the Windows server and then start the Listener service.

Share
10 |10000 characters needed characters left characters exceeded