Error in STMS_IMPORT

[Former Member]

Hi,

I'm getting following error while transporting the request via stms_import and as well as from OS level too...

Connect is not possible: DBMS = ORACLE dbs_or

Main import

End date and time : 20070820151121

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

What to do to resolve the problem...?

Regards,

Neehir Bhatt

[Former Member · Accepted solution]

Hi Neerav,

There is some problem with database i guess.

Can u copy log file resides in \trans\log.

Check environment variable DBMS_TYPE. It should be ORA.

Regards,

Payal patel

[Former Member · Accepted solution]

Hi,

The env variable dbms_type is configured properly as ORA..

Here with this message in attaching some significant line from trans.log file...

4 ETW000 [dev trc ,00000] Thu Aug 23 12:50:31 2007 103976 0.213989

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

4 ETW000 177 0.214166

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537'

4 ETW000 181 0.214347

4 ETW000 [dev trc ,00000] Try to connect with default password 462 0.214809

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@FRP on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 198 0.215007

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 193 0.215200

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x1018b6bd0 0x1018be620 0x1018ced58

4 ETW000 193 0.215393

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x1018d0f78)

4 ETW000 172 0.215565

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

4 ETW000 178 0.215743

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1018d0f78 189 0.215932

4 ETW000 [dev trc ,00000] Allocating server context handle 207 0.216139

4 ETW000 [dev trc ,00000] Attaching to DB Server FRP (con_hdl=0,svchp=0x1018cec88,svrhp=0x1018d0f78)

4 ETW000 210 0.216349

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

4 ETW000 92872 0.309221

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537'

4 ETW000 184 0.309405

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12537 performing CON [dblink#3 @ 431]

4 ETW000 520 0.309925

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

4 ETW000 177 0.310102

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

3WETP000 This is R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

3WETP000 unicode enabled version

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

3WETP000 R3trans finished (0012).

1 ETP186 R3TRANS CONNECT

1 ETP110 end date and time : "20070823125031"

1 ETP111 exit code : "12"

[Former Member · Accepted solution]

Hello ,

<b>ORA-12537: TNS:connection closed </b> ..

Can you please start Listner and try again !

Regards ,

Santosh Karadkar

[Former Member · Accepted solution]

Hi,

Listner is all ready started.... Infact My oraganization is able to login into the system and they are able to perform their routine....

Regards,

Neehir Bhatt

[Former Member · Accepted solution]

Hello ,

As per log :

<b>no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'FRP'"</b>

Execute R3trans -x and check the logs

Regards ,

Santosh

[Former Member · Accepted solution]

Hi,

Sorry friends none of your solution help me...

The solution is very simple....

Just set your Oracle session and processes in reference to your work processes...

Regards,

Neehir Bhatt

[Former Member · Accepted solution]

Hi Neehir,

Can you please tell me what is the stadard clculation followed to set Oracle session and processes in reference to work processes.

Regards,

Chandra.

[Former Member · Accepted solution]

Hi,

SAP NOTE NO: 830576

Formula:

For Processes in Oracle 10g:

#ABAP work processes * 2 + #J2EE server processes * <max-connections> + PARALLEL_MAX_SERVERS + 40

where PARALLEL_MAX_SERVERS = for example, 8 CPU Cores, the SAP central instance and the Oracle database are to share resources 50:50 -> PARALLEL_MAX_SERVERS = 8 * 0.5 * 10 = 40)

For Session in Oracle 10g:

2*process..

Regards:

Neehir Bhatt

[Former Member]

In addtion into my question......

From OS level, by user <sid>adm, when I'm applying the cmd tp connect <sid> it gives me following error..

tp connect FRP

This is tp version 370.00.09 (release 700, unicode enabled)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

Connection to Database of FRP was successful.

tp finished with return code: 12

meaning:

A tool used by tp aborted

Regards,

Neehir Bhatt

[Former Member]

Please check that STMS should be consistent .

STMS -> Import Queue ->Check