on 06-29-2012 9:26 AM
Hi,
From problem to question:
I was upgradeing EHP5 to sap 4.7 and everything went fine until step 5 - EU_IMP2 - when all hang. I Stopped SAP and killed hanged sessions in oracle and in processes and shut down Oracle aswell. (Actual problem was that archivelogs were full allthough df -h did not say anything about some disk being full...).
Anyway - when archivelogs were cleaned to last date listener was restarted the same with oracle - both started fine. When starting SAP via sapstart gives error that Oracle needs to be started on remote machine (allthough both oracle and sap reside in same machine.)
When troubleshooting:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
R3trans -x
This is R3trans version 6.13 (release 640 - 19.01.11 - 17:51:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TAU'"
R3trans finished (0012).
(Allthough Oracle is started and operational and db is open)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 29-JUN-2012 11:21:27
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 29-JUN-2012 00:34:18
Uptime 0 days 10 hr. 47 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/TAU/112_64/network/admin/listener.ora
Listener Log File /oracle/diag/tnslsnr/sledda/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xx)(PORT=1521)))
The listener supports no services
The command completed successfully
(i replaced XXX vith correct hostname in this post. What botheres me is marked with bold text)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
listener.ora
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
################
ADR_BASE_LISTENER_TAU = /oracle/TAU/saptrace
ADMIN_RESTRICTIONS_LISTENER_TAU = on
LISTENER_TAU =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = TAU.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = TAU)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = xxx.xxx.xx)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER_TAU = 0
CONNECT_TIMEOUT_LISTENER_TAU = 10
TRACE_LEVEL_LISTENER_TAU = OFF
SID_LIST_LISTENER_TAU =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = TAU)
(ORACLE_HOME = /oracle/TAU/112_64)
)
)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
tnsnames.ora
################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
################
TAU.WORLD =
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = xxx.xxx.xx)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = TAU)
(GLOBAL_NAME = TAU.WORLD)
)
)
LOCAL_LISTENER_TAU.WORLD =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xx)(PORT = 1527))
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
I have even tried to make Oracle register itself to listener via alter database register - command goes thru but when executing listener status it's the same as before.
As I cannot start SAP the upgrade proccess also gives tp connection error and upgrade cannot continue.
Any advice given on my text above how to make oracle to appear in listener?
Thanks in an advance,
Kristjan T.
Message was edited by: Kristjan T
can you stop the listener process using lsnrctl stop
Start the listener as follows :
lsnrctl
lsnrctl > start LISTENER_TAU
Then check if the above works.
lsnrctl> status LISTENER_TAU
lsnrctl> services LISTENER_TAU
Regards
Ratnajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you paste the trans.log file , output from R3trans -x
Regards
Ratnajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your quick response - trans.log is:
4 ETW000 R3trans version 6.13 (release 640 - 19.01.11 - 17:51:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 29.06.2012 - 11:39:42
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Fri Jun 29 11:39:42 2012 67 0.000067
4 ETW000 [dev trc ,00000] db_con_init called 21 0.000088
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 24 0.000112
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/TAU/SYS/exe/run/dboraslib.so' ...
4 ETW000 46 0.000158
4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/TAU/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 9495 0.009653
4 ETW000 [dev trc ,00000] Library '/usr/sap/TAU/SYS/exe/run/dboraslib.so' loaded
4 ETW000 28 0.009681
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/TAU/SYS/exe/run/dboraslib.so
4 ETW000 30 0.009711
4 ETW000 [dev trc ,00000] Version of '/usr/sap/TAU/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.369)
4 ETW000 71 0.009782
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/TAU/SYS/exe/run/dboraslib.so
4 ETW000 25 0.009807
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/TAU/SYS/exe/run/dboraslib.so
4 ETW000 33 0.009840
4 ETW000 [dev trc ,00000] New connection 0 created 22 0.009862
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 46 0.009908
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 22 0.009930
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 23 0.009953
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 36 0.009989
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/TAU/112_64 from environment
4 ETW000 227 0.010216
4 ETW000 [dev trc ,00000] Default connection: tnsname ='TAU' 32 0.010248
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalChar C EnvHp ErrHp ErrBt
4 ETW000 44 0.010292
4 ETW000 [dev trc ,00000] -->oci_initialize (con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2)
4 ETW000 28 0.010320
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment
4 ETW000 24 0.010344
4 ETW000 [dev trc ,00000] default client setting: NLS_CHAR=charset='UTF8'
4 ETW000 5295 0.015639
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 21 0.015660
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get XXXXXX's password 18 0.015678
4 ETW000 [dev trc ,00000] Connecting as /@TAU on connection 0 (nls_hdl 0) ... (dbsl 640 090311, UNICODE[2])
4 ETW000 27 0.015705
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalChar C EnvHp ErrHp ErrBt
4 ETW000 31 0.015736
4 ETW000 [dev trc ,00000] 0 UTF8 AL16UTF16 1 0x2290770 0x229bb88 0x229d698
4 ETW000 27 0.015763
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 25 0.015788
4 ETW000 [dev trc ,00000] Allocating server context handle 21 0.015809
4 ETW000 [dev trc ,00000] Attaching to DB Server TAU (con_hdl=0,svchp=0x229baa8,srvhp=0x22a0720)
4 ETW000 43 0.015852
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
4 ETW000 2047 0.017899
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error 12541.
4 ETW000 31 0.017930
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 21 0.017951
4 ETW000 [dev trc ,00000] SAPUSER or connect error rc=99, oerr=12541. 89 0.018040
4 ETW000 [dblink ,00430] ***LOG BY2=>sql error 12541 performing CON [dblink#6 @ 430]
4 ETW000 54 0.018094
4 ETW000 [dblink ,00430] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#6 @ 430]
4 ETW000 26 0.018120
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TAU'"
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.