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?