very urgent!!!!!!!!!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: very urgent!!!!!!!!!!!

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    The TNS Listner of is stopping suddenly again and again I am using oracle 8.1.5 on NT. One application is using that database.

    Please suggest me what to do now?

    Thanks
    SHailendra


  2. #2
    Join Date
    Oct 2000
    Posts
    467
    Check if listener is running

    lsnrctl status
    if down restart it using lsnrctl start.

    Check the listener log for any errors.
    Vinit

  3. #3
    Join Date
    Sep 2000
    Posts
    305
    Is this problem related to JDBC or it is a netwrok problem it is happening continously please adive me
    I have started it again and again

    thanks again

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    It's a listener problem. Check $ORACLE_HOME/network/log/listener.log for errors.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Sep 2000
    Posts
    305
    hi

    guys now the service is stopping suddenly also the tns listner

    what could be the problem?

    thanks is advance
    Shailendra

  6. #6
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    have you checked the listener.log ??
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  7. #7
    Join Date
    Sep 2000
    Posts
    305
    Hi

    I am pasting here the last modified part of my listner
    can anybody tell me what is the problem

    it is urgent
    thanks




    System parameter file is e:\Oracle\Ora81\network\admin\listener.ora
    Log messages written to e:\Oracle\Ora81\network\log\listener.log

    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=white5)(PORT=1521))(PROTOCOL_STACK=(PRESENTATION=TTC)(SESS ION=NS)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=white5)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SES SION=RAW)))
    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
    11-FEB-02 17:21:36 * service_register * ASHINFO * 0
    11-FEB-02 17:21:55 * service_register * ASHINFO * 0
    11-FEB-02 17:22:02 * (CONNECT_DATA=(SERVICE_NAME=ashinfo.WHITE5)(CID=(PROGRAM=C:\Oracle\Ora81\bin\sqlplusw.exe)(HOST=GOLD 2)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.1.32)(PORT=1672)) * establish * ashinfo.WHITE5 * 0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width