Oracle Listener not starting.

11-30  Source: Network gathering  Views:0 

Advertisement
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.
************************************dev_w0 *******************************
trc file: "dev_w0", trc level: 1, release: "700"
*  ACTIVE TRACE LEVEL           1
*  ACTIVE TRACE COMPONENTS      all, MJ

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 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 Tue Aug 03 22:23:18 2010
M  ThInit: running on host sapnw2004s

M Tue Aug 03 22:23:19 2010
M  calling db_connect ...
C  Prepending C:\usr\sap\PRD\DVEBMGS01\exe to Path.

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 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  Info for wp 0

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  *  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  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 Tue Aug 03 22:23:26 2010
M  call ThrShutDown (1)...
M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 3632) [dpnttool.c   327]
Related articles
  • Oracle Listener not starting. 11-30

    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 lis

  • Listener not starting up 10-11

    oracle database 8i OS windows 2000 server listener not starting following is the error message from udump network error encountered setting up listening port listening address for dispatcher is '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))' NS Primary Error

  • Oracle does not start 11-30

    Hi, I have installed oracle 11g r1 on centos. When the pc is connected to network, then I have no problem to spart oracle, else the oracle does not starts. What can I do to start oracle with or without internet connection. On windows I used a loopbac

  • FNDFS Listener not starting after patching 11-30

    12.1.3 redhat 4.8 DB 11.2.0.1 We recently did patching on our R12 system. The system is online, however the concurrent managers are not working due to the APPS_NPCP listener not starting. When attempting to start FNDFS this is the error we get. This

  • TNS-12560: TNS:protocol adapter error listener not starting up. 10-11

    Hi all we came to an issue where we have to move our server from one data centre to another after unplugging the machine and re-plugging the server 1) Operating system (OEL 5.1) started. 2) Database 11gR2 started. 3) Listener Failed to Start. [oracle

  • Oracle XE not starting up 10-11

    Hi Community, I have installed Oracle XE on top of RH FC4 running on my VM. When I start XE I get the following error: [[email protected] ~]# /etc/init.d/oracle-xe start Starting Oracle Net Listener. Starting Oracle Database 10g Express Edition Instance. Faile

  • Listener not starting on server reboot 11-30

    for securing listener I have done the following steps: Created a separate account and group at OS level and brought listener.ora,lsnrctl and related files/directories under this account and group. I have secured listener by setting password (change_p

  • Oracle instances not starting 11-30

    So, We tried to bring our Oracle 10g RAC cluster back online on Monday and have been having issues getting the instances to come up. Here's what we've seen so far: [[email protected] bin]$ ./crs_stat -t Name Type Target State Host ora....SM1.asm applica

  • Oracle 8i not starting 11-30

    Please help. I have Oracle 8I; webdb and OAS installed on NT4. (Workstation) with SP 5. Everything was working properly till I had to install Oracle7 client software to connect to Unix box, which is running Oracle7.xx. I have installed Oracle 7 clien

  • SqlPLus and Listener not Starting - Error 1067 and 1053 11-30

    Hi all, Windows 2003 Oracle 10.2. and ECC 6.0 I would really appreciate if someone could reply me quick here. I was trying to patch Oracle 10.2.0.1 to patch set 1 10.2.0.2 when it suddenly got canceled. No the Oracle listener is not starting up. Plea

  • Oracle 10g XE installation problem on Ubuntu Linux, Oracle will not start 10-11

    Hi, After installing the pakages the error is when I call sqlplus and login as SYS :- oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory ERROR: ORA-12547: TNS:lost contact What I hav

  • Oracle does not start automatically ORA-01031: insufficient privileges 10-11

    Hi, OS WS2008R2. ORACLE 11gR2. Oracle Instance does not start with oracle services but if i stop and restart the services it comes up clean. Moreover if i change service ownership to Domain\Administrator it again works well. Checked registery and all

  • Oracle 10g not starting after upgarde 10-11

    Hi,    Oracle not starting after upgrade and this service not starting automatically . This is error giving in the event viewer Description: The OracleDEV102iSQL*Plus service failed to start due to the following error: The service did not respond to

  • Oracle database not starting up in oracle 10g RAC 10-11

    Hi! Recently I came across one problem with one node oracle 10g RAC.When the Oracle database is started,while opening it is giving ORA-03113:End of file on communication channel error.When I saw the the alert trace file and other trace files I found

  • Oracle Essbase not starting up 10-11

    Hi, We are having issues with oracle essbase server in our oracle Hyperion planning system. The ./opmncl startall process gives below error. checked OPMN log and it says, JVM initialization and singleserver signon are succesfull. However, i see error

  • Oracle Database Not Starting Up Properly 10-11

    On VMware there's a known issue with Oracle databases on a Windows client not starting up properly all the time and a manual startup using oradim -start -sid <whatever> is required to get it fully running. I kinda figured that I wouldn't run into th

  • Oracle Service not starting on Win 7 11-30

    Hi, Ive just installed Oracle 11g (11.2.0) on my Win 7 home edition. All the oracle services except 'OracleServiceORCL' have started. The below error is recorded in Windows Event Viewer. Error 1067 pop up comes after unsuccessful startup attempt is d

  • Listener not starting after restart 11-30

    Hello, After rebooting my Windows PC yesterday, I can't get the Listener to start. I've read every post I could find on this and nothing has helped so far. When I try to start the listener on the command line, I get this error: C:\Documents and Setti

  • Oracle is not starting (ORA-27102: out of memory) 11-30

    Hi All, We have installed successfuly SAP Netweaver EHP1(SR1) (ABAP and Java)  with  SUNOS & Oracle10 on the same server. After installation we have stopped the java instance and tried to start but the database is not starting and it is showing the e

  • Oracle Database not starting ORA-01034: ORACLE not available and ORA-27101 11-30

    Dear Sir, today i have restarted the database server (11gR2) after that database service is not starting, the error message is ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or