Skip to Content
0
Former Member
May 05, 2010 at 12:00 PM

at DI R3trans fails with this error code ORA-12545, but CI runs

189 Views

Hello Gurus,

We have our BW System on two instances with a separated oracle database server.

Last week the system was unreachable and we must restarted it hard.

After that, the Listener could started and runs. The DB could started, mounted and opened successfully.

Now we have a special problem.

The central instance can connect at startup to the database. But the dialog instance not.

The DI get the following error:

|> R3trans -x
This is R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'BW2'"
R3trans finished (0012).

The trans.log entry are:

[...]
4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '12541'                        17  0.187511
4 ETW000  [dev trc     ,00000]     set_ocica() -> SQL error code 12541                                    13  0.187524
4 ETW000  [dev trc     ,00000]  -->oci_get_errmsg (con_hdl=0, rc=12541)                                   14  0.187538
4 ETW000  [dev trc     ,00000]     OCIErrorGet -> SQL error code: 12541                                   14  0.187552
4 ETW000  [dev trc     ,00000]     ORA-12541: TNS:no listener                                       
4 ETW000                                                                                22  0.187574
4 ETW000  [dblink      ,00433]  ***LOG BY2=>sql error 12541  performing CON [dblink#4 @ 433]           14396  0.201970
4 ETW000  [dblink      ,00433]  ***LOG BY0=>ORA-12541: TNS:no listener [dblink#4 @ 433]                   39  0.202009
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'BW2'"

A telnet connection test to port 1527 are also unsuccessful.

But sporadicly the telnet or R3trans connection are successful, but the second check are unsuccessful.

We have checked the telnet connection to another oracle database server (ERP) at port 1527 and it works.

The CI have some entry's in ST22 with DBIF_RSQL_SQL_ERROR --> ORA-03114: not connected to ORACLE.

Are someone known something about this issue?

regards

Chris