Question:
Hello Basis People,
I got following problem during installation of R/3 46C & Oracle 9i with
46D_EXT(32Bit) kernel according to note.578004. I copied 46C kernel
on local disk and put 3 SAR files over there and then started installation.
Problem occurred at phase DBR3START_NT_ORA ( progress 94% ).
I could find some similar problems in this site, but solution for any
problem was checking Oracle or environment variables. In my case,
connecting to Oracle by R3trans -d is OK and environment variables are
also OK.
! SAP support gave up to solve this issue. His advice was to reccomend
re-install. !
Would you advice ?
Gamella
INFO 2007-03-20 16:31:13
Setting Password for the Database User
INFO 2007-03-20 16:31:13
Ensuring ABAP Dictionary Consistency
<<< CENTRDB.log >>>
INFO 2007-03-20 16:31:13
Updating MNLS Tables
INFO 2007-03-20 16:31:13
Starting up the SAP System
INFO 2007-03-20 16:31:13 DBR3START_NT_ORA SyCoprocessCreate:931
Creating coprocess E:\usr\sap\MIK\sys\exe\run\startsap.exe ...
INFO 2007-03-20 16:33:13 DBR3START_NT_ORA ExecuteDo:0
RC code form SyCoprocessWait = -1 .
ERROR 2007-03-20 16:33:13 DBR3START_NT_ORA ExecuteCheck:0
Exit code from E:\usr\sap\MIK\sys\exe\run\startsap.exe: -1.
ERROR 2007-03-20 16:33:13 DBR3START_NT_ORA InternalInstallationDo:0
Phase failed.
ERROR 2007-03-20 16:33:13 DBR3START_NT_ORA InstallationDo:0
Phase failed.
ERROR 2007-03-20 16:33:13 InstController Action:0
Step DBR3START_NT_ORA could not be performed.
ERROR 2007-03-20 16:33:14 Main :0
Installation failed.
ERROR 2007-03-20 16:33:14 Main :0
Installation aborted.
<<< startMIK >>>
running E:\usr\sap\MIK\sys\exe\run\sapstart.exe name=MIK nr=20 SAPDIAHOST=tkontsap -wait
Start service SAPMIK_20 on machine \\tkontsap
OpenService of SAPMIK_20 failed. Error#: 1060
CreateNamedPipe for \\tkontsap\pipe\SAPMIK_20 Failed, Extended Error #2
Start service SAPMIK_20 on machine \\tkontsap
OpenService of SAPMIK_20 failed. Error#: 1060
Start (StartSAPService) failed.
sapparam(1c): No Profile used.
<<< sapstartcon >>>
CreateNamedPipe for \\tkontsap\pipe\SAPMIK_20 Failed, Extended Error #2
Start service SAPMIK_20 on machine \\tkontsap
OpenService of SAPMIK_20 failed. Error#: 1060
Start (StartSAPService) failed.
<<< R3trans -d --- trans.log >>>
4 ETW000 r3trans version 6.05 (release 46D - 28.03.01 - 11:30:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -d
4 ETW000 date&time : 20.03.2007 - 16:29:56
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [developertrace,0] Tue Mar 20 16:29:57 2007 0.000000
4 ETW000 [developertrace,0] db_con_init called 0.000000
4 ETW000 [developertrace,0] create_con (con_name=R/3) 0.000000
4 ETW000 [developertrace,0] Loading DB library 'dboraslib.dll' ...
4 ETW000 0.000000
4 ETW000 [developertrace,0] load shared library (dboraslib.dll), hdl 0
4 ETW000 48445 0.048445
4 ETW000 [developertrace,0] Library 'dboraslib.dll' loaded
4 ETW000 29 0.048474
4 ETW000 [developertrace,0] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 32 0.048506
4 ETW000 [developertrace,0] Version of 'dboraslib.dll' is '46D.00'
4 ETW000 61 0.048567
4 ETW000 [developertrace,0] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 30 0.048597
4 ETW000 [developertrace,0] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 43 0.048640
4 ETW000 [developertrace,0] New connection 0 created 43 0.048683
4 ETW000 [developertrace,0] db_con_connect (con_name=R/3) 33 0.048716
4 ETW000 [developertrace,0] find_con found the following connection for reuse:
4 ETW000 27 0.048743
4 ETW000 [developertrace,0] Got ORACLE_HOME=e:\oracle\MIK\925 from environment
4 ETW000 453 0.049196
4 ETW000 [developertrace,0] -->oci_initialize 29 0.049225
4 ETW000 [developertrace,0] Got ORACLE_SID=MIK from environment
4 ETW000 165 0.049390
4 ETW000 [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
4 ETW000 33 0.049423
4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPR3's password
4 ETW000 27 0.049450
4 ETW000 [developertrace,0] Connecting as /@MIK on connection 0 ...
4 ETW000 26 0.049476
4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='MIK')
4 ETW000 38 0.049514
4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 1017
4 ETW000 63334 0.112848
4 ETW000 [dboci.c ,0] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 57 0.112905
4 ETW000 [developertrace,0] Try to connect with default password
4 ETW000 45 0.112950
4 ETW000 [developertrace,0] Connecting as SAPR3/<pwd>@MIK on connection 0 ...
4 ETW000 48 0.112998
4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='MIK')
4 ETW000 47 0.113045
4 ETW000 [developertrace,0] Now I'm connected to ORACLE 48145 0.161190
4 ETW000 [developertrace,0] Database instance mik is running on TKONTSAP with ORACLE version 9.2.0.7.0 since 20070320
4 ETW000 27059 0.188249
4 ETW000 [developertrace,0] Connection 0 opened 2229 0.190478
4 ETW000 [developertrace,0] NTAB: Structure of NTAB on DB is VERS_A
4 ETW000 7045 0.197523
4 ETW000 [developertrace,0] NTAB: standalone processing 65 0.197588
4 ETW000 [developertrace,0] NTAB: read profile 17 0.197605
4 ETW000 [developertrace,0] NTAB: rsdb/ntab/entrycount 150
4 ETW000 26 0.197631
4 ETW000 [developertrace,0] NTAB: rsdb/ntab/ftabsize 200 16 0.197647
4 ETW000 [developertrace,0] NTAB: rsdb/ntab/irbdsize 100 17 0.197664
4 ETW000 [developertrace,0] NTAB: rsdb/ntab/sntabsize 100 17 0.197681
4 ETW000 [developertrace,0] NTAB: maxcnt 150 20 0.197701
4 ETW000 [developertrace,0] NTAB: adm_initial 4080 16 0.197717
4 ETW000 [developertrace,0] NTAB: hfactor 1009 17 0.197734
4 ETW000 [developertrace,0] NTAB: mem_protocol_size 104 17 0.197751
4 ETW000 [developertrace,0] NTAB: FTAB: total 51200, adm_size 14920, data_size 204800
4 ETW000 29 0.197780
4 ETW000 [developertrace,0] NTAB: IREC: total 12800, adm_size 14920, data_size 102400
4 ETW000 27 0.197807
4 ETW000 [developertrace,0] NTAB: STAB: total 25600, adm_size 14920, data_size 102400
4 ETW000 28 0.197835
4 ETW000 [developertrace,0] NTAB: TTAB: total 150, adm_size 7784, data_size 21000
4 ETW000 27 0.197862
4 ETW000 [developertrace,0] NTAB: FTAB: adm_adr 18cc780, adm_len 14920, dat_adr 18d01c8, dat_len 204800
4 ETW000 1414 0.199276
4 ETW000 [developertrace,0] NTAB: IREC: adm_adr 19021d0, adm_len 14920, dat_adr 1905c18, dat_len 102400
4 ETW000 31 0.199307
4 ETW000 [developertrace,0] NTAB: STAB: adm_adr 191ec20, adm_len 14920, dat_adr 1922668, dat_len 102400
4 ETW000 31 0.199338
4 ETW000 [developertrace,0] NTAB: TTAB: adm_adr 193b670, adm_len 7784, dat_adr 193d4d8, dat_len 21000
4 ETW000 30 0.199368
4 ETW000 [developertrace,0] NTAB: mem_protocol 193b670, mp_p 193b670, proc_id 0
4 ETW000 35 0.199403
4 ETW000 [developertrace,0] NTAB: FTAB: hh_p 18cc780, ha_list 18cc7ac, hi_list 18cd770, buffer 18d01c8
4 ETW000 78 0.199481
4 ETW000 [developertrace,0] NTAB: IREC: hh_p 19021d0, ha_list 19021fc, hi_list 19031c0, buffer 1905c18
4 ETW000 30 0.199511
4 ETW000 [developertrace,0] NTAB: STAB: hh_p 191ec20, ha_list 191ec4c, hi_list 191fc10, buffer 1922668
4 ETW000 31 0.199542
4 ETW000 [developertrace,0] NTAB: TTAB: hh_p 193b6d8, ha_list 193b704, hi_list 193c6c8, buffer 193d4d8
4 ETW000 30 0.199572
4 ETW000 [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 0
4 ETW000 58 0.199630
4 ETW000 [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 1
4 ETW000 69 0.199699
4 ETW000 [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 2
4 ETW000 74 0.199773
4 ETW000 [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 3
4 ETW000 62 0.199835
4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'MIK' --- SYSTEM = 'SAP'.
4 ETW000 trace to file pointer closed
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000
4 ETW000 ================== STEP 1 =====================
4 ETW000 date&time : 20.03.2007 - 16:29:57
4 ETW000 function : CONNECT
4 ETW000 buffersync : YES
4 ETW000 clients : default
4 ETW000 l.s.m. : VECTOR
4 ETW000 commit : 100000
4 ETW000 table cache : dynamic
4 ETW000
4 ETW000 [developertrace,0] Disconnecting from ALL connections:
4 ETW000 194 0.000194
4 ETW000 [developertrace,0] Disconnecting from connection 0 ...
4 ETW000 34 0.000228
4 ETW000 [developertrace,0] Now I'm disconnected from ORACLE
4 ETW000 3361 0.003589
4 ETW000 [developertrace,0] Disconnected from connection 0
4 ETW000 49 0.003638
4 ETW000 [developertrace,0] statistics db_con_commit (com_total=0, com_forced=0, com_tx=0)
4 ETW000 43 0.003681
4 ETW000 [developertrace,0] statistics db_con_rollback (roll_total=0, roll_forced=0, roll_tx=0)
4 ETW000 41 0.003722
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0000).
4 ETW000 date&time: 20.03.2007 - 16:29:57
Answer:
in my case, service SAP<SID>_nr. ( SAPMIK_20 ) does not exist.
I'm not sure this service should be created before this phase or it
is created at this phase.