on 06-14-2010 10:47 PM
I am adding a Linux ppc64 - Dialog Instance to the existing CI/DB on AIX. I have completed the kernal install and oracle client in Linux server. But getting following error while starting SAP application server.
Checking ST1 Database
-
Database is not available via R3trans
Database ST1 must be started on remote server
Log on to remote server and start database
WARNING[E] 2010-06-09 13:21:51.701
CJSlibModule::writeError_impl()
CJS-20022 Could not start instance 'D50' of SAP system ST1.
Below R3trans -x output
cat trans.log
4 ETW000 R3check version 6.14 (release 701 - 12.06.09 - 15:20:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 14.06.2010 - 16:09:54
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3check -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Mon Jun 14 16:09:54 2010 166 0.000166
4 ETW000 [dev trc ,00000] db_con_init called 42 0.000208
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 66 0.000274
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/ST1/SYS/exe/run/dboraslib.so' ... 67 0.000341
4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/ST1/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 25361 0.025702
4 ETW000 [dev trc ,00000] Library '/usr/sap/ST1/SYS/exe/run/dboraslib.so' loaded 42 0.025744
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 65 0.025809
4 ETW000 [dev trc ,00000] Version of '/usr/sap/ST1/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.42)
4 ETW000 107 0.025916
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 55 0.025971
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 71 0.026042
4 ETW000 [dev trc ,00000] New connection 0 created 50 0.026092
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 91 0.026183
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 42 0.026225
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 33 0.026258
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 81 0.026339
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0' 406 0.026745
4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 46 0.026791
4 ETW000 [dev trc ,00000] application info callback registered 39 0.026830
**************************************
Any help is appreciated
Did you check the trace and log file in /usr/sap/SID/D50/work. If the instance cannot be started properly one of the files should contain some information that might point to the underlying error.
For example the file dev_disp might be interesting.
Kind regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
All I am seeing is below files ONLY
-rwxr-xr-x 1 st1adm sapsys 25 2008-08-11 21:55 rfcexec.sec
-rw-r----- 1 st1adm sapsys 387 2010-06-09 13:21 sapcpe_base.log
-rw-r----- 1 st1adm sapsys 93262 2010-06-09 13:21 sapcpe.log
-rw-rr 1 st1adm sapsys 478 2010-06-10 10:54 sapstartsrv.log
-rw-rr 1 st1adm sapsys 54 2010-06-15 07:08 available.log
pwd
/usr/sap/ST1/D50/work
Here you go ..
cat trans.log
4 ETW000 R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 15.06.2010 - 07:18:26
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Tue Jun 15 07:18:26 2010 159 0.000159
4 ETW000 [dev trc ,00000] db_con_init called 36 0.000195
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 63 0.000258
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/ST1/SYS/exe/run/dboraslib.so' ... 65 0.000323
4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/ST1/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 25439 0.025762
4 ETW000 [dev trc ,00000] Library '/usr/sap/ST1/SYS/exe/run/dboraslib.so' loaded 41 0.025803
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 59 0.025862
4 ETW000 [dev trc ,00000] Version of '/usr/sap/ST1/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.42)
4 ETW000 108 0.025970
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 55 0.026025
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 69 0.026094
4 ETW000 [dev trc ,00000] New connection 0 created 48 0.026142
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 88 0.026230
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 37 0.026267
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 32 0.026299
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 79 0.026378
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0' 401 0.026779
4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 45 0.026824
4 ETW000 [dev trc ,00000] application info callback registered 38 0.026862
I did perform DI through sapinst, so there is noway I miss any.
Regarding trans.log with R3trans -d, below ALL the Lines from trans.log. Please note the R3trans -d terminates with Bus Error, Hope this helps
***R3trans -d***
***This is R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).***
***unicode enabled version***
***Bus error***
cat trans.log
4 ETW000 R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 15.06.2010 - 09:01: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] Tue Jun 15 09:01:39 2010 166 0.000166
4 ETW000 [dev trc ,00000] db_con_init called 35 0.000201
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 65 0.000266
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/ST1/SYS/exe/run/dboraslib.so' ... 68 0.000334
4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/ST1/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 25743 0.026077
4 ETW000 [dev trc ,00000] Library '/usr/sap/ST1/SYS/exe/run/dboraslib.so' loaded 42 0.026119
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 59 0.026178
4 ETW000 [dev trc ,00000] Version of '/usr/sap/ST1/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.42)
4 ETW000 106 0.026284
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 54 0.026338
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 71 0.026409
4 ETW000 [dev trc ,00000] New connection 0 created 48 0.026457
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 90 0.026547
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 37 0.026584
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 32 0.026616
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 79 0.026695
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0' 405 0.027100
4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 45 0.027145
4 ETW000 [dev trc ,00000] application info callback registered 39 0.027184
Bala
>
> Please note the R3trans -d terminates with Bus Error, Hope this helps
That's why the trans.log is incomplete...
You could try to replace the R3trans you use with the newest R3trans available on SMP.
If the error still occurs, you should open a CSN message.
If there is a core file in /usr/sap/trans/tmp, you can add it to the CSN (you might have to compress it, of course).
Also, run the "sapsysinfo" script as described in SAP note 618104 and add the results to the CSN.
- Elmar.
Hi Balasubramanian,
please run "R3trans -d" as st1adm and post the complete resulting trans.log here.
- Elmar.
Edited by: Elmar Billen on Jun 15, 2010 9:26 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here you go ..
R3trans -d
This is R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).
unicode enabled version
Bus error
cat trans.log
4 ETW000 R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 15.06.2010 - 06:58: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] Tue Jun 15 06:58:39 2010 165 0.000165
4 ETW000 [dev trc ,00000] db_con_init called 37 0.000202
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 67 0.000269
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/ST1/SYS/exe/run/dboraslib.so' ... 67 0.000336
4 ETW000 [dev trc ,00000] Tue Jun 15 06:58:40 2010 26613 0.026949
4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/ST1/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 68 0.027017
4 ETW000 [dev trc ,00000] Library '/usr/sap/ST1/SYS/exe/run/dboraslib.so' loaded 42 0.027059
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 59 0.027118
4 ETW000 [dev trc ,00000] Version of '/usr/sap/ST1/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.42)
4 ETW000 106 0.027224
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 55 0.027279
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.so
4 ETW000 70 0.027349
4 ETW000 [dev trc ,00000] New connection 0 created 49 0.027398
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 89 0.027487
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 38 0.027525
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 32 0.027557
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 79 0.027636
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0' 400 0.028036
4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 45 0.028081
4 ETW000 [dev trc ,00000] application info callback registered 39 0.028120
Hi Balasubramanian,
the log is incomplete, maybe because the number of characters you are allowed to post here is limited.
Please try the following:
run R3trans -d # yes, I really mean "-d", not "-x"
check trans.log for lines not beginning with "4 ETW000"
post this lines (and ~20 lines around them) here
- Elmar
Edited by: Elmar Billen on Jun 15, 2010 2:26 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.