DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Listener help

  1. #1
    Join Date
    Apr 2001
    Posts
    112
    Hi
    My db version is 805 on solaris.

    We have several databases installed on our unix box.
    I created a new database (805). It got successfully created.
    When I do a LSNRCTL status , it shows me the service handles for all other database SIDs. But the one I just created does not get included.

    So I put the new SID description in LISTENER.ora file & tnsnames.ora file on the Server.
    Even after this it does not show up with the LSNRCTL status command. Also this does not cause any client connection to be made to the new database.

    My question is do I have to STOP my listener and then RESTART to cause the listener to acknowledge my new database?

    Any help is greatly appreciated.


  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    LSNRCTL RELOAD

    or

    LSNRCTL STOP
    then
    LSNRCTL START
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Apr 2001
    Posts
    112
    Hi grjohnson
    I cant stop the Lsnr till tommorow coz of processes running on my database.
    Does Lsnrctl RELOAD causes the lsnr to stop and start ?

    I appreciate your help

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    When your listener is down, only new connections will not be accepted. Existing connections will not be dropped. Sure, nobody will be able to connect for 5 seconds, but you can usually find 5 seconds in the day to bounce the listener...
    Jeff Hunter

  5. #5
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Jeff is right, the users shouldn't even notice. Do a LSNRCTL RELOAD, it doesn't start and stop the listener.
    OCP 8i, 9i DBA
    Brisbane Australia

  6. #6
    Join Date
    Apr 2001
    Posts
    112
    Jeff & grjohnson
    even after doing the reload I get the following error & the STATUS does not show the new service. Please help.

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PRNC8))
    TNS-12224: TNS:no listener
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Solaris Error: 2: No such file or directory




  7. #7
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    LSNRCTL START

    You could also have a syntax problem in you listener.ora file.


    [Edited by grjohnson on 08-16-2001 at 10:27 PM]
    OCP 8i, 9i DBA
    Brisbane Australia

  8. #8
    Join Date
    Apr 2001
    Posts
    112
    When I do this it gives me the following message:

    TNS-01106: Listener using listener name tnslsnr has already been started


    Thanks

  9. #9
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Are your users connecting via the TCP protocol?

    In your listener.ora file,

    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sunbox5)(PORT = 1521))
    )
    OCP 8i, 9i DBA
    Brisbane Australia

  10. #10
    Join Date
    Apr 2001
    Posts
    112
    Hi
    Yes the clients connect through TCP/IP

    My Listener.ora

    TNSLSNR =
    (ADDRESS_LIST =
    (ADDRESS= (PROTOCOL=IPC)(KEY= PRNC8)
    )

    (ADDRESS =(PROTOCOL = TCP)(HOST = gem)(PORT = 1521)
    )

    Thanks

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