Skip to Content
1
Former Member
Jun 28, 2007 at 11:00 AM

Transport terminated ( RC=12 ) Connect is not possible: DBMS = ORACLE

172 Views

Hi All,

I have started to get follwoing error while I try to import a request in our quality system.

The transport is ending with RC =12 . ( it was working fine few minutes ago. )

We are on Oracle 9.2.0.6 and HP-UX 11.2

The error log is as follwos:

<b>R3trans version 6.13 (release 640 - 13.02.06 - 15:46:42).

===============================================

date&time : 28.06.2007 - 16:13:16

control file: /usr/sap/trans/tmp/P3DKK904447.P3Q

> #pid 15225 on sapp3q01 (p3qadm)

> import

> buffersync=yes

> file='/usr/sap/trans/data/R904447.P3D'

> continuation='/usr/sap/trans/data/R904447_#.P3D'

> client=310

>

> excluding 'R3TRDDDD','R3TRDOMA','R3TRDTEL','R3TRENQU','R3TRMACO','R3TRMCID','R3TRMCOB','R3TRSHLP','R3TRSQLT','R3TRTABL','R3TRTTYP

R3trans was called as follows: R3trans -w /usr/sap/trans/tmp/P3DI904447.P3Q /usr/sap/trans/tmp/P3DKK904447.P3Q

TRACE-INFO: 1: [dev trc ,00000] Thu Jun 28 16:13:16 2007 34962 0.034962

TRACE-INFO: 2: [dev trc ,00000] db_con_init called 14 0.034976

TRACE-INFO: 3: [dev trc ,00000] create_con (con_name=R/3) 2362 0.037338

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

TRACE-INFO: 5: 9252 0.046590

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

TRACE-INFO: 7: 247222 0.293812

TRACE-INFO: 8: [dev trc ,00000] Library '/usr/sap/P3Q/SYS/exe/run/dboraslib.sl' loaded 19 0.293831

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

TRACE-INFO: 10: 59 0.293890

TRACE-INFO: 11: [dev trc ,00000] Version of '/usr/sap/P3Q/SYS/exe/run/dboraslib.sl' is 640.00, patchlevel (0.114)

TRACE-INFO: 12: 134 0.294024

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

TRACE-INFO: 14: 28 0.294052

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

TRACE-INFO: 16: 53 0.294105

TRACE-INFO: 17: [dev trc ,00000] New connection 0 created 19 0.294124

TRACE-INFO: 18: [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 0

TRACE-INFO: 19: 38 0.294162

TRACE-INFO: 20: [dev trc ,00000] db_con_connect (con_name=R/3) 38 0.294200

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

TRACE-INFO: 22: 16 0.294216

TRACE-INFO: 23: [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 00

TRACE-INFO: 24: 20 0.294236

TRACE-INFO: 25: [dev trc ,00000] Got ORACLE_HOME=/oracle/P3Q/920_64 from environment 31586 0.325822

TRACE-INFO: 26: [dev trc ,00000] >oci_initialize (con_hdl=0) 49 0.325871

TRACE-INFO: 27: [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment 15 0.325886

TRACE-INFO: 28: [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 4205 0.330091

TRACE-INFO: 29: [dev trc ,00000] Logon as OPS$-user to get SAPP3Q's password 25 0.330116

TRACE-INFO: 30: [dev trc ,00000] Connecting as /@P3Q on connection 0 (nls_hdl 0) ... (dbsl 640 240106)

TRACE-INFO: 31: 18 0.330134

TRACE-INFO: 32: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpB

TRACE-INFO: 33: 19 0.330153

TRACE-INFO: 34: [dev trc ,00000] 0 WE8DEC 1 8000000100ad2908 8000000100a

TRACE-INFO: 35: 19 0.330172

TRACE-INFO: 36: [dev trc ,00000] Thu Jun 28 16:13:17 2007 23963 0.354135

TRACE-INFO: 37: [dev trc ,00000] Allocating service context handle for con_hdl=0 12 0.354147

TRACE-INFO: 38: [dev trc ,00000] Allocating server context handle 22 0.354169

TRACE-INFO: 39: [dev trc ,00000] Attaching to DB Server P3Q (con_hdl=0,svchp=8000000100adae70,svrhp=8000000100add310)

TRACE-INFO: 40: 119 0.354288

TRACE-INFO: 41: [dev trc ,00000] Assigning server context 8000000100add310 to service context 8000000100adae70

TRACE-INFO: 42: 253987 0.608275

TRACE-INFO: 43: [dev trc ,00000] Allocating user session handle 52 0.608327

TRACE-INFO: 44: [dev trc ,00000] Starting user session (con_hdl=0,svchp=8000000100adae70,srvhp=8000000100add310,usrhp=8000000

TRACE-INFO: 45: 26 0.608353

TRACE-INFO: 46: [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 20 27292 0.635645

TRACE-INFO: 47: [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=8000000100add310) 19 0.635664

TRACE-INFO: 48: [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=8000000100adae70,srvhp=8000000100add310)

TRACE-INFO: 49: 19 0.635683

TRACE-INFO: 50: [dev trc ,00000] Deallocating server context handle 8000000100add310 48 0.635731

TRACE-INFO: 51: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '20' 546 0.636277

TRACE-INFO: 52: [dev trc ,00000] Try to connect with default password 33 0.636310

TRACE-INFO: 53: [dev trc ,00000] Connecting as SAPP3Q/<pwd>@P3Q on connection 0 (nls_hdl 0) ... (dbsl 640 240106)

TRACE-INFO: 54: 30 0.636340

TRACE-INFO: 55: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpB

TRACE-INFO: 56: 20 0.636360

TRACE-INFO: 57: [dev trc ,00000] 0 WE8DEC 1 8000000100ad2908 8000000100a

TRACE-INFO: 58: 20 0.636380

TRACE-INFO: 59: [dev trc ,00000] Allocating server context handle 15 0.636395

TRACE-INFO: 60: [dev trc ,00000] Attaching to DB Server P3Q (con_hdl=0,svchp=8000000100adae70,svrhp=8000000100add310)

TRACE-INFO: 61: 33 0.636428

TRACE-INFO: 62: [dev trc ,00000] Assigning server context 8000000100add310 to service context 8000000100adae70

TRACE-INFO: 63: 84636 0.721064

TRACE-INFO: 64: [dev trc ,00000] Assigning username to user session 8000000100ae6d58 23 0.721087

TRACE-INFO: 65: [dev trc ,00000] Assigning password to user session 8000000100ae6d58 20 0.721107

TRACE-INFO: 66: [dev trc ,00000] Starting user session (con_hdl=0,svchp=8000000100adae70,srvhp=8000000100add310,usrhp=8000000

TRACE-INFO: 67: 20 0.721127

TRACE-INFO: 68: [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 20 11134 0.732261

TRACE-INFO: 69: [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=8000000100add310) 18 0.732279

TRACE-INFO: 70: [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=8000000100adae70,srvhp=8000000100add310)

TRACE-INFO: 71: 19 0.732298

TRACE-INFO: 72: [dev trc ,00000] Deallocating server context handle 8000000100add310 22 0.732320

TRACE-INFO: 73: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '20' 23 0.732343

TRACE-INFO: 74: [dblink ,00419] ***LOG BY2=>sql error 20 performing CON [dblink#2 @ 419]

TRACE-INFO: 75: 31601 0.763944

TRACE-INFO: 76: [dblink ,00419] ***LOG BY0=>ORA-00020: maximum number of processes (%s) exceeded [dblink#2 @ 419]

TRACE-INFO: 77: 22 0.763966

Connect is not possible: DBMS = ORACLE dbs_or

Main import

End date and time : 20070628161317

Ended with return code: ===> 12 <===

######################################</b>

Can somebody help me to resolve the issue?

I am facing this problem for the first time.

Thanks.

-


Shamish