cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Please clarify:

1) Is your CI on the same server as database, or on the same server as DI, or on a third server?

2) What Oracle error do you get? ORA-12545 as stated in the subject, or ORA-12545 as shown in the quote, or both, or even more?

Former Member
0 Kudos

Oh Sorry:

1)Tthe database is on a third server.

2) The ORA-12545 as shown in the quote.

regards

Chris

Former Member
0 Kudos

Oh, just noticed a typo of my own:

probably should be:

ORA-12541 as shown in the quote

The my guess would be network problems between DI and database.

A firewall?

A different network segment with heavy load?

PS: Or maybe hardware problems with the network interface of the DI server?

Edited by: Joe Bo. on May 5, 2010 3:20 PM

Former Member
0 Kudos

yes ORA-12541

We have no firewall between db and DI.

A telnet connect at port 21 to the db server are successful.

We have no heavy load in the network.

So we don't think it is a network problem.

regards

Chris

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

Is /sapmnt directory common on DI, DB and CI server ? If yes, then please check /sapmnt directory should be mounted on DI and DB as well.

Thanks

Sunny

Former Member
0 Kudos

Hi,

Please check the configuration of listener file at location $ORACLE_BASE/network/admin and find out the name of listener.

Also check if the listener is running fine and not obsolete. Also, check your database is up and running while checking connectivity using R3trans -x.

Regards,

Ankit

Former Member
0 Kudos

Hi,

What is the output of the below command from DI instance ?

# tnsping <SID>

Is tnsping successful from DI instance ?

Which tnsnames.ora it shows in the output of tnsping <SID> ?

Could you please post the log of listener.log file.

Last, check your "/etc/hosts" file on DI server, if it contains correct host entry for your DB server.

Regards.

Rajesh Narkhede

Former Member
0 Kudos

@ Sunny Pahuja:

We checked sapmnt.

Sapmnt is common on CI and DI. It was never mounted on DB. But DB runs perfectly until this issue.

@ Ankit Gupta

We checked the configuration of listener.

It is the same like the listener configuration of our ERP system with CI, DI and DB on separate Servers, too.

@ Rajesh Narkhede

From DB Server


|> tnsping BW2

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 06-MAY-2010 07:40:56

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
/oracle/BW2/102_64/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) 
(HOST = bw2dba) (PORT = 1527))) (CONNECT_DATA = (SID = BW2) (GLOBAL_NAME = BW2.WORLD)))
OK (100 msec)

On CI and DI we don't have tnsping.

Just copy it don't work.


|> tnsping BW2

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 06-MAY-2010 08:39:17

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Message 3511 not found; No message file for product=network, facility=TNS
Message 3512 not found; No message file for product=network, facility=TNS
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) 
(HOST = bw2dba) (PORT = 1527))) (CONNECT_DATA = (SID = BW2) (GLOBAL_NAME = BW2.WORLD)))
Message 3509 not found; No message file for product=network, facility=TNS

How to get it on the CI and DI. In the SAR files at SAP it is not included. I can't found something in the Web.

kishore_soma
Active Participant
0 Kudos

Hi,

Can you post the environment variables of both SAP users (ora<sid> and <sid>adm, if unix and <sid>Adm if windows).

Regards,

Kishore Soma

Former Member
0 Kudos

bw2adm> env
_=/usr/bin/env
LANG=en_US
WSM_WS_CMD="startsrc -s http4websm"
THREAD=NOPS
LOGIN=bw2adm
PATH=/usr/java14_64/bin:.:/home/bw2adm:/usr/sap/BW2/SYS/exe/run::/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin
NLS_LANG=AMERICAN_AMERICA.WE8DEC
ORACLE_BASE=/oracle
LC__FASTMSG=true
LOGNAME=bw2adm
MAIL=/usr/spool/mail/bw2adm
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/BW2_dsm.opt
dbs_ora_tnsname=BW2
ORACLE_SID=BW2
LOCPATH=/usr/lib/nls/loc
PS1=
bw2adm>
DB_SID=BW2
DIR_LIBRARY=/usr/sap/BW2/SYS/exe/run
WSM_DOC_DIR="/usr/websm/http/com.ibm.websm.http.server_1.0.0"
USER=bw2adm
AUTHSTATE=files
TNS_ADMIN=/nfsmnt/sapmnt/BW2/profile/oracle
IBM_JAVA_OPTIONS=-Xmx256M -Xj9
dbs_ora_schema=SAPSR3
SHELL=/bin/ksh
ODMDIR=/etc/objrepos
JAVA_HOME=/usr/java14_64
SAPDATA_HOME=/oracle/BW2
HOME=/home/bw2adm
CT_MANAGEMENT_SCOPE=2
TERM=xterm
DSM_DIR=/usr/tivoli/tsm/client/ba/bin
MAILMSG=[YOU HAVE NEW MAIL]
PWD=/home/bw2adm
TZ=NFT-1DFT,M3.5.0,M10.5.0
dbms_type=ORA
WSM_CGI_DIR=
SAPSYSTEMNAME=BW2
DSM_CONFIG=/usr/tivoli/tsm/client/ba/bin/BW2_dsm.opt
DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
A__z=! LOGNAME
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/usr/lib:/lib:/usr/sap/BW2/SYS/exe/run:/oracle/client/10x_64/instantclient
Former Member
0 Kudos

orabw2> env
_=/usr/bin/env
LANG=en_US
WSM_WS_CMD="startsrc -s http4websm"
THREAD=NOPS
LOGIN=orabw2
PATH=/oracle/BW2/102_64/bin:.:/home/orabw2:/usr/sap/BW2/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin
NLS_LANG=AMERICAN_AMERICA.WE8DEC
ORACLE_BASE=/oracle
LC__FASTMSG=true
LOGNAME=orabw2
MAIL=/usr/spool/mail/orabw2
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/BW2_dsm.opt
dbs_ora_tnsname=BW2
ORACLE_SID=BW2
LOCPATH=/usr/lib/nls/loc
PS1=
orabw2>
DB_SID=BW2
DIR_LIBRARY=/usr/sap/BW2/SYS/exe/run
WSM_DOC_DIR="/usr/websm/http/com.ibm.websm.http.server_1.0.0"
USER=orabw2
AUTHSTATE=files
IBM_JAVA_OPTIONS=-Xmx256M
dbs_ora_schema=SAPSR3
SHELL=/bin/ksh
ODMDIR=/etc/objrepos
SAPDATA_HOME=/oracle/BW2
HOME=/home/orabw2
CT_MANAGEMENT_SCOPE=2
TERM=xterm
DSM_DIR=/usr/tivoli/tsm/client/ba/bin
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/oracle/BW2/102_64
PWD=/home/orabw2
TZ=NFT-1DFT,M3.5.0,M10.5.0
dbms_type=ORA
WSM_CGI_DIR=
SAPSYSTEMNAME=BW2
DSM_CONFIG=/usr/tivoli/tsm/client/ba/bin/BW2_dsm.opt
DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
A__z=! LOGNAME
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/usr/lib:/lib:/usr/sap/BW2/SYS/exe/run:/oracle/BW2/102_64/lib
Former Member
0 Kudos

Hi,

Can you please clearify, are you using oracle client on CI and DI system to connect to the oracle DB server ?

As per my understanding you should have oracle client installed on CI and DI system in order to connect to DB server.

Please correct me if I am wrong...

Regards.

Rajesh Narkhede

Former Member
0 Kudos

Hello Gurus,

We have found the solution for the issue.

We use TSA in our landscape for fail over switching of the DB and the instances.

On the idle server was the same ip as on the online server.

So we had the service ip of the db two times in the network.

As the ip was set two times, the unusual was that no error are shown.

Thanks for your support.

regards

Chris

Answers (0)