cancel
Showing results for 
Search instead for 
Did you mean: 

Adding Linux dialog instance with AIX CI

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Elmar Billen meant to run R3trans -x not -d to create the trans.log. Please perform that command.

Former Member
0 Kudos

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

Former Member
0 Kudos

No, I meant "-d"

Former Member
0 Kudos

You won't see a dev_disp here, because the startup script checks the database first. If it find's that the database is not running, it won't continue with the startup process. So no dispatcher/workprocess is started.

- Elmar.

Former Member
0 Kudos

trans.log - I do not see any lines not beginning with "4 ETW000". That is the ALL lines from trans.log. Also wanted to let you know, the app server (Linux) trying to communicate with CI in AIX, with the current configuration only the Kernel and Oracle Client installed in Liunx App server.

Former Member
0 Kudos

What is the result of running "R3trans -d" - what's the screen output? Does it end with "R3trans finished (0000)"?

Former Member
0 Kudos

What exactly do you mean by "only Kernel and Oracle Client"? You didn't perform a normal DI setup?

Regarding the log file another approach: Can you identify those lines in trans.log that implicate an error in the connection to the database and post those lines?

Former Member
0 Kudos

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

Former Member
0 Kudos

>

> 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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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