on 05-05-2010 1:00 PM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
@ 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.
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
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
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.