DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: listener problems

  1. #1
    Join Date
    Oct 2000
    Posts
    449

    listener problems

    Hi.. Today we suddenly experience a blip in listeners across our systems and when I looked into the listener.log I could find some of these lines..

    29-NOV-2002 06:18:37 * service_update * AAP * 0

    Also I could find some lines with "service_register" with all the instance names and then after sometime followed by these lines.. Everyday we only start a new listener.ora file at 12:30 and do not stop the listener.

    Can anyone tell, what this is and why listener can stop ?

    Thanks, ST2000

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    What port number are you using? This is a known problem with Port 1521. Change it to something else like 1526. Do let us know. Thanks.
    -- Dilip

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    I guess you are talking about the listener.ora

    oracle@CG_JDA1:/home/oracle/product/8.1.7/network/admin_> more listener.ora
    # LISTENER.ORA Network Configuration File: /home/oracle/product/8.1.7/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = CG_JDA1)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    )
    )


    -------------

    But why do I have these messages in my listener.log

    29-NOV-2002 10:42:42 * (CONNECT_DATA=(SERVICE_NAME=AAMPROD)(CID=(PROGRAM=)(HOST=CG_JDA1)(USER=odbms))) * (ADDRESS=(PROTOCOL=tcp)(HOS
    T=172.16.160.100)(PORT=51431)) * establish * AAMPROD * 0
    29-NOV-2002 10:42:43 * (CONNECT_DATA=(SERVICE_NAME=ODBMSPRD)(CID=(PROGRAM=)(HOST=CG_JDA1)(USER=odbms))) * (ADDRESS=(PROTOCOL=tcp)(HO
    ST=172.16.160.100)(PORT=51432)) * establish * ODBMSPRD * 0
    29-NOV-2002 10:42:43 * (CONNECT_DATA=(SERVICE_NAME=AAMPROD)(CID=(PROGRAM=)(HOST=CG_JDA1)(USER=odbms))) * (ADDRESS=(PROTOCOL=tcp)(HOS
    T=172.16.160.100)(PORT=51433)) * establish * AAMPROD * 0


    I am able to log in successfully..

    Is this listening to the wrong port then?

    What are the side effects and proven alternatives?

    Thanks, ST2000

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    ST2000, Check in Metalink for Doc ID: 334888.999. Hopefully that should help you. Thanks.
    -- Dilip

  5. #5
    Join Date
    Oct 2000
    Posts
    449
    Thanks a lot, patel_dil.. The doc most certainly helps.. So, to configure to a different port, all we have to do is changes in the tnsnames.ora right? And by the way we have a dedicated server and not MTS, as the article was referring to more as a MTS problem.
    ST2000

  6. #6
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Make the changes in listener.ora as well. If your system is not MTS configured, Check whether any MTS parameters are present in your init.ora File. Good Luck.

    Thanks.
    -- Dilip

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