on 11-02-2015 5:55 AM
Hello Experts,
I have a issue while starting SAP when execute startsap r3 I have experienced the error
TNS-12541: TNS:no listener, V2 connect is not available. Terminating.
My SAP environment is RHEL 5 and SAP NW7.0 with Oracle.
Please help me how to fix the issue.
before executing I have checked R3trans -d also it's fineshed with 0012.
Please refer below screenshot of error.
Lsnrctl start:
DBstartup.log:
R3trans -d:
R3trans.log
4 ETW000 R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 01.11.2015 - 12:46:34
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Sun Nov 1 12:46:34 2015 116 0.000116
4 ETW000 [dev trc ,00000] db_con_init called 19 0.000135
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 33 0.000168
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/W89/SYS/exe/run/dboraslib.so' ...
4 ETW000 39 0.000207
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/W89/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 6731 0.006938
4 ETW000 [dev trc ,00000] Library '/usr/sap/W89/SYS/exe/run/dboraslib.so' loaded
4 ETW000 23 0.006961
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/W89/SYS/exe/run/dboraslib.so
4 ETW000 4 0.006965
4 ETW000 [dev trc ,00000] Version of '/usr/sap/W89/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.107)
4 ETW000 3 0.006968
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/W89/SYS/exe/run/dboraslib.so
4 ETW000 1 0.006969
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/W89/SYS/exe/run/dboraslib.so
4 ETW000 0 0.006969
4 ETW000 [dev trc ,00000] New connection 0 created 1 0.006970
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 0 0.006970
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 0 0.006970
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 0 0.006970
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 0 0.006970
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 968 0.007938
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 23 0.007961
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2565 0.010526
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 24 0.010550
4 ETW000 [dev trc ,00000] Connecting as /@W89 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 23 0.010573
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 34 0.010607
4 ETW000 [dev trc ,00000] 0 UTF8 1 0xa21f2b0 0xa22491c 0xa2241a4
4 ETW000 23 0.010630
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 53 0.010683
4 ETW000 [dev trc ,00000] Allocating server context handle 32 0.010715
4 ETW000 [dev trc ,00000] Attaching to DB Server W89 (con_hdl=0,svchp=0xa224130,srvhp=0xa235914)
4 ETW000 54 0.010769
4 ETW000 [dev trc ,00000] Sun Nov 1 12:46:55 2015 21013400 21.024169
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541
4 ETW000 28 21.024197
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 29 21.024226
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 24 21.024250
4 ETW000 [dev trc ,00000] Try to connect with default password 43 21.024293
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@W89 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 24 21.024317
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 25 21.024342
4 ETW000 [dev trc ,00000] 0 UTF8 1 0xa21f2b0 0xa22491c 0xa2241a4
4 ETW000 23 21.024365
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0xa235914)
4 ETW000 22 21.024387
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0xa224130,srvhp=0xa235914)
4 ETW000 21 21.024408
4 ETW000 [dev trc ,00000] Deallocating server context handle 0xa235914 3 21.024411
4 ETW000 [dev trc ,00000] Allocating server context handle 3 21.024414
4 ETW000 [dev trc ,00000] Attaching to DB Server W89 (con_hdl=0,svchp=0xa224130,srvhp=0xa235914)
4 ETW000 2 21.024416
4 ETW000 [dev trc ,00000] Sun Nov 1 12:47:16 2015 21011598 42.036014
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541
4 ETW000 36 42.036050
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 25 42.036075
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 15 42.036090
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12541 performing CON [dblink#3 @ 431]
4 ETW000 99 42.036189
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#3 @ 431]
4 ETW000 22 42.036211
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'W89'"
Listener.log
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 01-NOV-2015 15:55:49
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /oracle/W89/102_32/network/admin/listener.ora
Log messages written to /oracle/W89/102_32/network/log/listener.log
Trace information written to /oracle/W89/102_32/network/trace/listener.trc
Trace level is currently 0
Started with pid=5530
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=willsys89)(PORT=1527)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
01-NOV-2015 15:56:10 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
WARNING: Subscription for node down event still pending
01-NOV-2015 15:56:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
WARNING: Subscription for node down event still pending
01-NOV-2015 17:20:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89.WORLD)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=willsys89)(PORT=1527)))
Listener completed notification to CRS on stop
01-NOV-2015 17:20:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 01-NOV-2015 17:21:35
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /oracle/W89/102_32/network/admin/listener.ora
Log messages written to /oracle/W89/102_32/network/log/listener.log
Trace information written to /oracle/W89/102_32/network/trace/listener.trc
Trace level is currently 0
Started with pid=25861
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=willsys89)(PORT=1527)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
01-NOV-2015 17:21:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
WARNING: Subscription for node down event still pending
01-NOV-2015 17:22:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 02-NOV-2015 10:40:29
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /oracle/W89/102_32/network/admin/listener.ora
Log messages written to /oracle/W89/102_32/network/log/listener.log
Trace information written to /oracle/W89/102_32/network/trace/listener.trc
Trace level is currently 0
Started with pid=5624
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=willsys89)(PORT=1527)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
02-NOV-2015 10:40:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
TNSNAMES.ORA:
Please help me how to fix the issue and let me know any information required.
Thanks in Advance,
Karthik Bura
Hi Karthick,
AS from the r3trans log its clear your system is unable to connect using Listerner.
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541
4 ETW000 28 21.024197
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 29 21.024226
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 24 21.024250
4 ETW000 [dev trc ,00000] Try to connect with default password 43 21.024293
So can you check if your DB is perfectly up and runnng fine in "OPEN" mode.
As from the Listner start it say unknown handlers.
You can check the same from below command;
select OPEN_MODE from v$database;
Also do below validations:-
run below command by SIDadm in your case w89adm:-
tnsping W89
And check if you have tnsnames.ora in your profile directory:- /sapmnt/W89/profile/oracle.
And has the same descriptors
Update us on the same.
Regards,
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ramakrishna,
I already checked database by executing command "select status from v$instance;"
the result is OPEN.
I have checked many times keeping DB Open and mount phase also but same issue repeated.
tnsping W89/willsys89/IP i have checked already pinging properly.
I have checked /sapmnt/W89/profile/oracle. tnsnames.ora is existing and same in both locations.
Thanks,
Karthik
Hello Ram,
I have performed below modification :
Open for edit the file $ORACLE_HOME/network/lib/env_network.mk and identify the following line:
TNSLSNR_LINKLINE+=$(SYSLIBS)
Add above the line TNSLSNR_LINKLINE+=$(SYSLIBS) the following entry:
LLIBCRYPT = -lcrypt
Modify the entry TNSLSNR_LINKLINE+=$(SYSLIBS) as below
from
TNSLSNR_LINKLINE+=$(SYSLIBS)
to
TNSLSNR_LINKLINE+=$(SYSLIBS) $(LLIBCRYPT)
Relink again oracle:
$ cd $ORACLE_HOME/bin
$ ./relink all
After performing check below screenshot:
Thanks,
Karthik
it seems listener issue i have tried below:
[root@willsys89 ~]# su - w89adm
willsys89:w89adm 1> lsnrctl start w89
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-NOV-2015 11:29:45
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /oracle/W89/102_32/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /usr/sap/W89/SYS/profile/oracle/listener.ora
Log messages written to /oracle/W89/102_32/network/log/w89.log
TNS-01151: Missing listener name, w89, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
Below is listener.ora file which is located in Oracle home/admin/network/
Listener.ora :
###### # Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
###### ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = W89.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = W89)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = willsys89)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = W89)
(ORACLE_HOME = /oracle/W89/102_32)
)
)
same file already available also in profiles/oracle/listener.ora
/usr/sap/W89/SYS/profile/oracle/listener.ora
###### # Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
###### ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = W89.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = W89)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = willsys89)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = W89)
(ORACLE_HOME = /oracle/W89/102_32)
)
)
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.