DBAsupport.com Forums - Powered by vBulletin
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 42

Thread: Listener

  1. #1
    Join Date
    Feb 2003
    Posts
    69

    Listener

    Hi Network gurus,

    problem is yesterday powergone. now i trying to connect ot my database. it is giving error No Listen... How to start my Listener...

    before i did't the task..

    please need step to start listner...
    HTML

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Platform???

    Unix:

    lsnrctl start


    NT:

    Start the listener service.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Feb 2003
    Posts
    69
    hi,

    When i ping to my server it shows the alive.

    but trying to start the listerner it is giving the error:


    TNSLSNR for Solaris: Version 8.0.5.0.0 - Production
    NL-00280: error creating log stream /export/home0/oradata/d01/app/oravis/product/805/network/log/listener.log
    NL-00278: cannot open log file
    SNL-00016: snlfohd: error opening file
    Solaris Error: 13: Permission denied


    what should i do...
    HTML

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Does the path /export/home0/oradata/d01/app/oravis/product/805/network/log/ exist and is it writable by the oracle account?

    Is there a corrupt listener.log file in there if so you may want to rename it and try the process again

    A temporary fix will be to either disable logging or to move the log to a new destination using the set options in lsnrctl

    eg
    Code:
    $ lsnrctl 
    
    LSNRCTL for Solaris: Version 9.2.0.3.0 - Production on 06-AUG-2003 09:00:21
    
    Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
    
    Welcome to LSNRCTL, type "help" for information.
    
    LSNRCTL> set log_status off
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=itdev)(PORT=1521)))
    LISTENER parameter "log_status" set to OFF
    The command completed successfully
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Feb 2003
    Posts
    69
    file exists and has error msgs. what should i do now..shall i rename the file ...
    HTML

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    What are the errors?
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  7. #7
    Join Date
    Feb 2003
    Posts
    69
    check it out

    System parameter file is /export/home0/oradata/d01/app/oravis/product/805/network/admin/listener.ora
    Log messages written to /export/home0/oradata/d01/app/oravis/product/805/network/log/listener.log

    Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=7)(KEY=PNPKEY))
    Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=13)(HOST=10.21.0.21)(PORT=1521))
    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
    17-MAR-03 22:33:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LIST ENER)(VER
    SION=134238208)) * status * 0

    TNSLSNR for Solaris: Version 8.0.5.0.0 - Production on 17-MAR-03 22:39:50

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    System parameter file is /export/home0/oradata/d01/app/oravis/product/805/network/admin/listener.ora
    Log messages written to /export/home0/oradata/d01/app/oravis/product/805/network/log/listener.log

    Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=8)(KEY=PNPKEY))
    Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=13)(HOST=10.21.0.21)(PORT=1521))
    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
    17-MAR-03 22:39:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LIST ENER)(VER
    SION=134238208)) * status * 0
    17-MAR-03 22:56:58 * ping * 0
    17-MAR-03 23:05:34 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=VAYU)(USER
    =administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.65)(PORT=3515)) * establish * vis * 12514
    TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS

    17-MAR-03 23:06:13 * ping * 0
    17-MAR-03 23:08:24 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=VAYU)(USER
    =administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.65)(PORT=3525)) * establish * vis * 12514
    TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS

    17-MAR-03 23:08:36 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=VAYU)(USER
    =administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.65)(PORT=3527)) * establish * vis * 12514
    TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS

    17-MAR-03 23:09:09 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=VAYU)(USER
    =administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.65)(PORT=3529)) * establish * vis * 12514
    TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS

    19-MAR-03 16:21:27 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LIST ENER)(VER
    SION=134238208)) * status * 0
    19-MAR-03 16:22:07 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LI STENER)(V
    ERSION=134238208)) * services * 0
    19-MAR-03 16:22:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LIST ENER)(VER
    SION=134238208)) * status * 0
    24-MAR-03 15:49:51 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    09-MAY-03 20:14:20 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=HYPA-MUMWS
    )(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.91)(PORT=1079)) * establish * vis * 12514
    TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS
    HTML

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    You do not have the right permissions! As JOVERY suggested: path /export/home0/oradata/d01/app/oravis/product/805/network/log/ is not proabbly writable by the oracle account.

    As which OS user are you starting the listener?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  9. #9
    Join Date
    Feb 2003
    Posts
    69
    solaris
    HTML

  10. #10
    Join Date
    Feb 2003
    Posts
    69
    even i am trying to status off it is giving errors..

    LSNRCTL> set log_status off
    Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
    TNS-12224: TNS:no listener
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Solaris Error: 146: Connection refused
    Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=muso001
    TNS-12224: TNS:no listener
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Solaris Error: 146: Connection refused

    how can solve
    HTML

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