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

[Former Member]

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

[andreas_herzog · Accepted solution]

==> <b>ORA-00020: maximum number of processes (%s) exceeded</b> <==

too many oracle processes are active...you have to get rid of any inactive process (eg. by killing them on os level) and adjust the oracle parameter accordingly...

GreetZ, AH

[Former Member · Accepted solution]

Thanks Juan & Adreas.

I had seen the log and noticed the line which you highlighted. But was unble to decide the action since I havent yet 'played with' database that much.

So I stopped the SAP system ( along with database ) and then restarted it.

But not to let the opprtunity to go, can you please explain what should the value of parameter be set to? ( we have currently 80 )

One more querry : Why do the processes do not get refreshed or replaced when they are inactive or idle?

I ran the command ps -ef|grep ... But I dont understand from the output I see... I mean don't really get how to realize the output of this command.

Once again thanks for your instant reply.

---Shamish

[andreas_herzog · Accepted solution]

-> you have to concentrate on the oracle sessions (= query the v$sessions via sqlplus) to see which oracle processes are active

-> i'd go for 100 processes (that's 25% more..) - in case you get stuck again, increase the value to 120 (it's iterative...)

-> stopping the database is mostly your only choice - if you're lucky! if stopping via sqlplus (shutdown immediate) is not possible you have to kick some processes first...

GreetZ, AH

[david_malinconici2 · Accepted solution]

Depending on the Oracle release you have, set the parameters as follows:

Oracle 9i

PROCESSES=2*SAP Work processes+ 20

SESSIONS=1.2*PROCESSES

Oracle 10g

PROCESSES=2ABAP work processes+J2EE server processes<max-connections>+PARALLEL_MAX_SERVERS + 40

SESSIONS=2*PROCESSES

Regards,

David

[Former Member · Accepted solution]

Thanks David for the mathematical formula.

We have 16 processes ( SAP )

So the desired oracle processes will be 52. and we have 80 here. So according to you it is more than sufficient right?

Andreas,

I didn't get your point of going on increasing the parameter value.

Because I think that this maximum number is not going to be reached everytime; so why to increase the parameter value in iterative manner? Because ultimately there has to be some limit for increasing this value right? ( Is there any formula to know such restriction? )

Please correct me if my assumption is wrong anywhere...

Thanks.

---Shamish

[david_malinconici2 · Accepted solution]

80 should be right, so it's strange you have the problem.

Do you also have java stack or external product using the same database?

[Former Member · Accepted solution]

Hi,

log on to Unix, terminate all tp processes.

ps -ef |grep -i tp

then import again...this should work..

Regards

Ben

[Former Member · Accepted solution]

No David,

we don't have any Java Stack or external application running on same database.

--Shamish

[david_malinconici2 · Accepted solution]

It's very strange... everything is ok in listener configuration files?

Do you use autorestart for workprocesses?

[Former Member · Accepted solution]

Hi David ,

What should I check exactly. Please elaborate a bit in detail.

Thanks.

__ Shamish

( Sorry for the late reply )

[david_malinconici2 · Accepted solution]

Check the configuration in file listener.ora.

In my opinion the problem could be that oracle processes are not released by SAP workprocesses when they stop...

[Former Member]

Hi,

Look at your log:

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

This error is caused when the maximum number of processes are running in your DB. Check if your PROCESSES parameter in initSID.ora is too low (and correct it if needed), or if there's another cause of exceeding this limit (see alert file...).

Best Regards,

JC Llanes.