startsap on Dialog Instance will lose connection to DB of CI

[Former Member]

Hi,

We Have a problem in our Production Server.

We have CRM 7.0 Installation on the Production Setup.

The Production setup is installation on the SUSE 10 SP2 OS & Clustered.

The Cluster Setup is working fine.

We have also installed An additional Dialog Instance on a Separate

Machine other than 2 cluster nodes.

Problem is that when We start the Dialog Instance with the

command u201Cstartsap R3 D03u201D where the D03 is the Dialog Instance name, the

SAP Cluster loses the connection to the DB & we have to stop the

additional Dialog in order to Use the PRD Server..

Request you to help resolve this Issue

Regards

manjunath

[markus_doehr2]

What do you mean with "loosing connection to the DB"? Any logs that prove that?

Markus

[Former Member]

Hi,

" Connect is not possible: DBMS = ORACLE. "

ex: I get error when i try to import any request in stms. when i stop the Addition Dialog Instacne, the Import of the request is successful.

Regards

Manjunath

[markus_doehr2]

> " Connect is not possible: DBMS = ORACLE. "

Can you please paste the full log?

> ex: I get error when i try to import any request in stms. when i stop the Addition Dialog Instacne, the Import of the request is successful.

You may run out of allowed client connections to the database.

Markus

[Former Member]

Thanks for the reply Markus,

Pls find the logs.

4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/trans/tmp/CRDI902645.CRP /usr/sap/trans/tmp/CRDKK902645.CRP

4 ETW000 TRACE-INFO: 1: [dev trc ,00000] Mon Nov 16 15:43:19 2009 2288 0.002288

4 ETW000 TRACE-INFO: 2: [dev trc ,00000] db_con_init called 13 0.002301

4 ETW000 TRACE-INFO: 3: [dev trc ,00000] create_con (con_name=R/3) 59 0.002360

4 ETW000 TRACE-INFO: 4: [dev trc ,00000] Loading DB library '/usr/sap/CRP/SYS/exe/run/dboraslib.so' ...

4 ETW000 TRACE-INFO: 5: 26 0.002386

4 ETW000 TRACE-INFO: 6: [dev trc ,00000] load shared library (/usr/sap/CRP/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 TRACE-INFO: 7: 29281 0.031667

4 ETW000 TRACE-INFO: 8: [dev trc ,00000] Library '/usr/sap/CRP/SYS/exe/run/dboraslib.so' loaded 23 0.031690

4 ETW000 TRACE-INFO: 9: [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/CRP/SYS/exe/run/dboraslib.so

4 ETW000 TRACE-INFO: 10: 41 0.031731

4 ETW000 TRACE-INFO: 11: [dev trc ,00000] Version of '/usr/sap/CRP/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.0)

4 ETW000 TRACE-INFO: 12: 82 0.031813

4 ETW000 TRACE-INFO: 13: [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/CRP/SYS/exe/run/dboraslib.so

4 ETW000 TRACE-INFO: 14: 32 0.031845

4 ETW000 TRACE-INFO: 15: [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/CRP/SYS/exe/run/dboraslib.so

4 ETW000 TRACE-INFO: 16: 72 0.031917

4 ETW000 TRACE-INFO: 17: [dev trc ,00000] New connection 0 created 35 0.0319524 ETW000 TRACE-INFO: 18: [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 TRACE-INFO: 19: 36 0.031988

4 ETW000 TRACE-INFO: 20: [dev trc ,00000] db_con_connect (con_name=R/3) 41 0.032029

4 ETW000 TRACE-INFO: 21: [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 TRACE-INFO: 22: 29 0.0320584 ETW000 TRACE-INFO: 23: [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 TRACE-INFO: 24: 31 0.032089

4 ETW000 TRACE-INFO: 25: [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 836 0.032925

4 ETW000 TRACE-INFO: 26: [dev trc ,00000] -->oci_initialize (con_hdl=0) 28 0.032953

4 ETW000 TRACE-INFO: 27: [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 6108 0.039061

4 ETW000 TRACE-INFO: 28: [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 21 0.039082

4 ETW000 TRACE-INFO: 29: [dev trc ,00000] Connecting as /@CRP on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 TRACE-INFO: 30: 32 0.039114

4 ETW000 TRACE-INFO: 31: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 TRACE-INFO: 32: 41 0.039155

4 ETW000 TRACE-INFO: 33: [dev trc ,00000] 0 UTF8 1 0x1a6ef80 0x1a769d0 0x1a870c8

4 ETW000 TRACE-INFO: 34: 31 0.039186

4 ETW000 TRACE-INFO: 35: [dev trc ,00000] Allocating service context handle for con_hdl=0 40 0.039226

4 ETW000 TRACE-INFO: 36: [dev trc ,00000] Allocating server context handle 22 0.039248

4 ETW000 TRACE-INFO: 37: [dev trc ,00000] Attaching to DB Server CRP (con_hdl=0,svchp=0x1a86ff8,srvhp=0x1a892d8)

4 ETW000 TRACE-INFO: 38: 102 0.039350

4 ETW000 TRACE-INFO: 39: [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12537

4 ETW000 TRACE-INFO: 40: 52019 0.091369

4 ETW000 TRACE-INFO: 41: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537' 26 0.0913954 ETW000 TRACE-INFO: 42: [dev trc ,00000] set_ocica() -> OCI or SQL return code 12537 40 0.091435

4 ETW000 TRACE-INFO: 43: [dev trc ,00000] Try to connect with default password 59 0.091494

4 ETW000 TRACE-INFO: 44: [dev trc ,00000] Connecting as SAPSR3/<pwd>@CRP on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 TRACE-INFO: 45: 31 0.091525

4 ETW000 TRACE-INFO: 46: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 TRACE-INFO: 47: 32 0.091557

4 ETW000 TRACE-INFO: 48: [dev trc ,00000] 0 UTF8 1 0x1a6ef80 0x1a769d0 0x1a870c8

4 ETW000 TRACE-INFO: 49: 31 0.091588

4 ETW000 TRACE-INFO: 50: [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x1a892d8) 18 0.091606

4 ETW000 TRACE-INFO: 51: [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1a86ff8,srvhp=0x1a892d8)

4 ETW000 TRACE-INFO: 52: 29 0.091635

4 ETW000 TRACE-INFO: 53: [dev trc ,00000] Deallocating server context handle 0x1a892d8 49 0.091684

4 ETW000 TRACE-INFO: 54: [dev trc ,00000] Allocating server context handle 44 0.091728

4 ETW000 TRACE-INFO: 55: [dev trc ,00000] Attaching to DB Server CRP (con_hdl=0,svchp=0x1a86ff8,srvhp=0x1a892d8)

4 ETW000 TRACE-INFO: 56: 44 0.091772

4 ETW000 TRACE-INFO: 57: [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12537

4 ETW000 TRACE-INFO: 58: 47060 0.138832

4 ETW000 TRACE-INFO: 59: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537' 25 0.138857

4 ETW000 TRACE-INFO: 60: [dev trc ,00000] set_ocica() -> OCI or SQL return code 12537 19 0.138876

4 ETW000 TRACE-INFO: 61: [dblink ,00431] ***LOG BY2=>sql error 12537 performing CON [dblink#1 @ 431]4 ETW000 TRACE-INFO: 62: 129 0.139005

4 ETW000 TRACE-INFO: 63: [dblink ,00431] ***LOG BY0=>ORA-12537: TNS:connection closed [dblink#1 @ 431]

4 ETW000 TRACE-INFO: 64: 30 0.139035

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'CRP'"

1 ETP154 MAIN IMPORT

1 ETP110 end date and time : "20091116154319"1 ETP111 exit code : "12"

1 ETP199 ######################################

1 ETP199X######################################

1 ETP154 MAIN IMPORT

1 ETP101 transport order : "CRDK902645"

1 ETP102 system : "CRP"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.40" "701"

1 ETP198

4 ETW000 R3trans version 6.14 (release 701 - 07.10.08 - 06:12:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 16.11.2009 - 15:56:36

4 ETW000 control file: /usr/sap/trans/tmp/CRDKK902645.CRP

4 ETW000 > #pid 23909 on wisapcrpna (crpadm)

4 ETW000 > import

4 ETW000 > buffersync=yes

4 ETW000 > file='/usr/sap/trans/data/R902645.CRD'

4 ETW000 > continuation='/usr/sap/trans/data/R902645_#.CRD'

4 ETW000 > client=900

4 ETW000 >4 ETW000 > excluding 'R3TRDDDD','R3TRDOMA','R3TRDTEL','R3TRENQU','R3TRMACO','R3TRMCID','R3TRMCOB','R3TRSHLP','R3TRSQLT','R3TRTABL','R3TRTTYP','R3TRUENO','R3TRVIEW'

4 ETW000 R3trans was called as follows: R3trans -u 26 -w /usr/sap/trans/tmp/CRDI902645.CRP /usr/sap/trans/tmp/CRDKK902645.CRP

4 ETW000 active unconditional modes: 26

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'CRP' --- SYSTEM = 'CRP'.

4 ETW690 COMMIT "0" "0"

4 ETW000 trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 16.11.2009 - 15:56:36

4 ETW000 function : IMPORT

4 ETW000 data file : /usr/sap/trans/data/R902645.CRD

4 ETW000 Continuation : /usr/sap/trans/data/R902645_#.CRD

4 ETW000 buffersync : YES

4 ETW000 client : 900

4 ETW000 repeatimport : NO

4 ETW000 repeatclimport : NO

4 ETW000 c.s.i. : NO

4 ETW000 l.s.m. : VECTOR

4 ETW000 charsetadapt : YES

4 ETW000 def. charset : WEUROPEAN

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic4 ETW000 EXCLUDING : 'R3TRVIEW','R3TRUENO','R3TRTTYP','R3TRTABL','R3TRSQLT','R3TRSHLP','R3TRMCOB','R3TRMCID','R3TRMACO','R3TRENQU','R3TRDTEL','R3TRDOMA','R3TRDDDD'

4 ETW000

4 ETW000 Data file is compressed with algorithm 'L'.

4 ETW000 Export was executed on 16.11.2009 at 13:19:44 by crdadm

3 ETW709 "701 "

4 ETW000 with R3trans version: 17.11.08 - 18:00:00

4 ETW000 Source System = AMD/Intel x86_64 with Linux on DBMS = ORACLE --- dbs_ora_tnsname = 'CRD' --- SYSTEM = 'CRD'.

4 ETW000

4 ETW000 language vector during export: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdi(),./:;&4 ETW000 language vector during export: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdi(),./:;& (ISO-ARHECSDEENFRELHUITJADAPLZFNLNOPTSKRUESTRFISVBGLTLVZ1SRZHTHKOROSLHRMSUKETAFISCASHIDZ2Z3Z4Z5Z6Z7Z8Z9)

4 ETW000 lsm during export: VECTOR

4 ETW000 trfunction = K (transport to consolidation system)

4 ETW000 Used Commandfile CRDK902645 (TRAMSA/2)

4 ETW000 This commandfile was already imported completely. Skipping ...

4 ETW000 CRDK902645 touched.

4 ETW690 COMMIT "128" "128"

4 ETW000 2292 bytes read.

4 ETW000 Transport overhead 100.0 %.

4 ETW000 Duration: 0 sec (2292 bytes/sec).

3 ETW710 "0" "0"

4 ETW0004 ETW000 Summary:

4 ETW000

4 ETW000 128 bytes modified in database.

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 8975 0.008975

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 46 0.009021

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x1a87048,usrhp=0x1a77238)

4 ETW000 295 0.009316

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1a87048,srvhp=0x1a89328)

4 ETW000 751 0.010067

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 460 0.010527

4 ETW000 [dev trc ,00000] Disconnected from connection 0 20 0.010547

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=2, com_tx=2)

4 ETW000 25 0.010572

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 24 0.010596

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 16.11.2009 - 15:56:36

1 ETP154 MAIN IMPORT

1 ETP110 end date and time : "20091116155636"

1 ETP111 exit code : "0"

1 ETP199 ######################################

[markus_doehr2]

> 4 ETW000 TRACE-INFO: 63: [dblink ,00431] ***LOG BY0=>ORA-12537: TNS:connection closed [dblink#1 @ 431]

This is your problem.

What patchlevel are you running on the server? did you apply all the interim fixes?

Markus

[Former Member]

Pls find the detail,

Kernel release: 701

Compilation : Linux GNU SLES-9

Sup.Pkg lvl.: 14

ABAP Load: 1565

CUA load : 32

Mode : opt

Regards

manjunath

[markus_doehr2]

> Kernel release: 701

This is the kernel version.

I was talking about the DATABASE version.

Markus

[Former Member]

Database system: ORACLE

Release: 10.2.0.2.0

[markus_doehr2]

> Database system: ORACLE

> Release: 10.2.0.2.0

Ok - and did you install the latest interim patch for that version? If not, then I'd try that first. If it still doesn't work I'd open an OSS call.

Markus