Oracle Listener not starting.

[Former Member]

Hi

I have installed NW2004s ABAP only on 2003 server with oraccle database. I have installed two instances with SID's DEV & PRD. I have one loop-back adapter and 2 Listeners(OraclePRD102TNSListener and OracleDEV102TNSListener). Initially both the listeners were working fine and now OraclePRD102TNSListener is not getting started and when I try to start it through services.msc, it is throwing the below pop-up

*************************************************************************

Listener service on Local computer started and then stopped. Some services stop automatically if they have no work to do,

for example, the Performance Logs and Alerts service.

**************************************************************************

I didn't changed any ip address nor any setting. Both the *.ora files are looking good and nothing is abnormal.

Looking forward your suggestions.

[Former Member]

Hi,

Make sure that the oracle listener port is different for both the instances running on the same host. Else recreate the listener services so that both the instance will listen from different ports.

Also check whether the ip address is maintained in the hosts file correctly.

Regards,

Varadharajan M

[Former Member]

Hi,

Make sure that both LISTENERs are having different name and are running on different port.

(Check the name and port in <drive>:\oracle\<SID>\102\network\admin\tnsnames.ora)

You might have used same port (default) for both listeners.

Also check host entry in C:\windows\System32\drivers\etc\hosts file.

(if it doesn't solve the issue, change the command line for both listener from registry...)

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OraclePRD102TNSListener

ImagePath = <ORACLE_HOME>\bin\lsnrctl <prd_listener_name>

Do the same thing for second listener...

Regards.

Rajesh Narkhede

[Former Member]

HI Rajesh

Thanks your quick reply. When I checked tnsnames.ora file, my both the Listeners are using the same port i.e 1527. Could you please advise how to change the Listener port and which port number can be used ?

Thanks

Kumar

[Former Member]

Thanks Rajesh

I have changed one of port from 1527 to 1521. Now both the Listeners are up and running. Even system was up initially and then disp+work.EXE got stopped. Could you please advise if I need to change something ? I have checked the host entry in

C:\windows\System32\drivers\etc\hosts file and it is alright.

Thanks

kumar

[Former Member]

************************************dev_w0 *******************************

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
*  ACTIVE TRACE LEVEL           1
*  ACTIVE TRACE COMPONENTS      all, MJ
*
B  
B Tue Aug 03 22:23:16 2010
B  create_con (con_name=R/3)
B  Loading DB library 'C:\usr\sap\PRD\DVEBMGS01\exe\dboraslib.dll' ...
B  Library 'C:\usr\sap\PRD\DVEBMGS01\exe\dboraslib.dll' loaded
B  Version of 'C:\usr\sap\PRD\DVEBMGS01\exe\dboraslib.dll' is "700.08", patchlevel (0.73)
B  New connection 0 created
M sysno      01
M sid        PRD
M systemid   560 (PC with Windows NT)
M relno      7000
M patchlevel 0
M patchno    75
M intno      20050900
M make:      multithreaded, Unicode, optimized
M pid        3632
M 
M  kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)
M  length of sys_adm_ext is 572 bytes
M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3632) [dpxxdisp.c   1299]
I  MtxInit: 30000 0 0
M  DpSysAdmExtCreate: ABAP is active
M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M  
M Tue Aug 03 22:23:17 2010
M  DpShMCreate: sizeof(wp_adm)		18304	(1408)
M  DpShMCreate: sizeof(tm_adm)		3994272	(19872)
M  DpShMCreate: sizeof(wp_ca_adm)		24000	(80)
M  DpShMCreate: sizeof(appc_ca_adm)	8000	(80)
M  DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064
M  DpShMCreate: sizeof(comm_adm)		528064	(1048)
M  DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M  DpShMCreate: sizeof(file_adm)		0	(72)
M  DpShMCreate: sizeof(vmc_adm)		0	(1440)
M  DpShMCreate: sizeof(wall_adm)		(38456/34360/64/184)
M  DpShMCreate: sizeof(gw_adm)	48
M  DpShMCreate: SHM_DP_ADM_KEY		(addr: 06600040, size: 4653368)
M  DpShMCreate: allocated sys_adm at 06600040
M  DpShMCreate: allocated wp_adm at 06601E40
M  DpShMCreate: allocated tm_adm_list at 066065C0
M  DpShMCreate: allocated tm_adm at 066065F0
M  DpShMCreate: allocated wp_ca_adm at 069D5890
M  DpShMCreate: allocated appc_ca_adm at 069DB650
M  DpShMCreate: allocated comm_adm at 069DD590
M  DpShMCreate: system runs without file table
M  DpShMCreate: allocated vmc_adm_list at 06A5E450
M  DpShMCreate: allocated gw_adm at 06A5E490
M  DpShMCreate: system runs without vmc_adm
M  DpShMCreate: allocated ca_info at 06A5E4C0
M  DpShMCreate: allocated wall_adm at 06A5E4C8
X  EmInit: MmSetImplementation( 2 ).
X  MM global diagnostic options set: 0
X  <ES> client 0 initializing ....
X  Using implementation flat
M  <EsNT> Memory Reset disabled as NT default
X  ES initialized.
M  
M Tue Aug 03 22:23:18 2010
M  ThInit: running on host sapnw2004s
M  
M Tue Aug 03 22:23:19 2010
M  calling db_connect ...
C  Prepending C:\usr\sap\PRD\DVEBMGS01\exe to Path.
C  
C Tue Aug 03 22:23:24 2010
C  Oracle Client Version: '10.2.0.1.0'
C  Client NLS settings: AMERICAN_AMERICA.UTF8
C  Logon as OPS$-user to get SAPSR3's password
C  Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch
C    0 UTF8                                                      1   06BE65B8   06BEBB54   06BEB3DC
C  Attaching to DB Server PRD (con_hdl=0,svchp=06BEB328,svrhp=06BFACF4)
C  
C Tue Aug 03 22:23:25 2010
C  *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12505
 [dboci.c      4172]
C  *** ERROR => CONNECT failed with sql error '12505'
 [dbsloci.c    10933]
C  Try to connect with default password
C  Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch
C    0 UTF8                                                      1   06BE65B8   06BEBB54   06BEB3DC
C  Detaching from DB Server (con_hdl=0,svchp=06BEB328,srvhp=06BFACF4)
C  Attaching to DB Server PRD (con_hdl=0,svchp=06BEB328,svrhp=06BFACF4)
C  *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12505
 [dboci.c      4172]
C  *** ERROR => CONNECT failed with sql error '12505'
 [dbsloci.c    10933]
B  ***LOG BY2=> sql error 12505  performing CON [dbsh#2 @ 1204] [dbsh    1204 ]
B  ***LOG BY0=> ORA-12505: TNS:listener does not currently know of SID given in connect descriptor [dbsh#2 @ 1204] [dbsh    1204 ]
B  ***LOG BY2=> sql error 12505  performing CON [dblink#3 @ 431] [dblink  0431 ]
B  ***LOG BY0=> ORA-12505: TNS:listener does not currently know of SID given in connect descriptor [dblink#3 @ 431] [dblink  0431 ]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1411]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10156]
M  
M  Info for wp 0
M  
M    stat = 4
M    reqtype = 1
M    act_reqtype = -1
M    rq_info = 0
M    tid = -1
M    mode = 255
M    len = -1
M    rq_id = 65535
M    rq_source = 255
M    last_tid = 0
M    last_mode = 0
M    semaphore = 0
M    act_cs_count = 0
M    control_flag = 0
M    int_checked_resource(RFC) = 0
M    ext_checked_resource(RFC) = 0
M    int_checked_resource(HTTP) = 0
M    ext_checked_resource(HTTP) = 0
M    report = >                                        <
M    action = 0
M    tab_name = >                              <
M    vm = V-1
M  
M  *****************************************************************************
M  *
M  *  LOCATION    SAP-Server sapnw2004s_PRD_01 on host sapnw2004s (wp 0)
M  *  ERROR       ThInit: db_connect
M  *
M  *  TIME        Tue Aug 03 22:23:25 2010
M  *  RELEASE     700
M  *  COMPONENT   Taskhandler
M  *  VERSION     1
M  *  RC          13
M  *  MODULE      thxxhead.c
M  *  LINE        10354
M  *  COUNTER     1
M  *
M  *****************************************************************************
M  
M  PfStatDisconnect: disconnect statistics
M  Entering TH_CALLHOOKS
M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   720]
M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  260]
M  Entering ThSetStatError
M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M  Entering ThReadDetachMode
M  
M Tue Aug 03 22:23:26 2010
M  call ThrShutDown (1)...
M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 3632) [dpnttool.c   327]

[Former Member]

HI,

Check which instances are currently known by the listener by executing: lsnrctl services <listener name>

- Check that the SID parameter in the connect descriptor specifies an instance known by the listener.

- Check for an event in the listener.log file.

Thanks

Deepu

[sunny_pahuja2]

Hi,

Can you please check window event logs ?

Thanks

Sunny