-
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
-
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
-
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
-
ST2000, Check in Metalink for Doc ID: 334888.999. Hopefully that should help you. Thanks.
-- Dilip
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|