Got "ORA-12541: TNS:no listener" even lsnrctl status looks ok
408126Nov 3 2003 — edited Nov 7 2003
I'm new to Oracle Internet Directory and just took over configuration of
OID from my colleague. I've spent a whole day to configure a new pair of
OID servers. My purpose is to setup them as a replication group. Here is
what I've done so far:
1. installed application schema on server1 (db3.lemurnetworks.net);
2. installed indexes on server1;
3. installed initial data on server1;
4. installed application ACL on server1;
5. installed replication group by running "ldaprepl.sh -asrsetup";
6. installed application schema on server2 (db4.lemurnetworks.net);
7. installed indexes on server2;
8. installed initial data on server2;
9. installed application ACL on server2;
10. start oidldapd and oidrepld on both servers;
After finishing above steps, I noticed replication servers on both server
are trying to replicate changes from each other. Since those changes are
manually applied to both servers, I then change the Change Log Life
Parameter to 1 hour by Using ldapmodify. I assume those changes will be
moved out of the change log table an hour later. However, when I connect to
the OID and the Oracle database this morning, I noticed there are several
problems:
1. the ASR_CHG_LOG and ODS_CHG_LOG table still contains thousands of lines;
2. ORA_HOME/ldap/log/oidrepld00.log complains that it can not connect to the
ldap server even oidldapd is running and I can connect to it
Failed on ldap_open. ldaphost=db3.lemurnetworks.net, ldapport=389.
3. Unable to stop and start oidldapd/oidrepld because of this error
oidctl connect=db3.lemurnetworks.net server=oidldapd instance=1 flags=' -p 389' start
[gsdsiConnect] ORA-12541, ORA-12541: TNS:no listener
The trouble shooting guide directs me to restart the TNS Listener by
using lsnrctl. I did that and the listener status looks ok to me but I
was still not able to oidldapd and oidrepld.
================== output of "lsnrctl status" ============================
LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 03-NOV-2003 10:30:21
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
Start Date 03-NOV-2003 09:42:37
Uptime 0 days 0 hr. 47 min. 43 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /export/home/oracle/OraHome1/network/admin/listener.ora
Listener Log File /export/home/oracle/OraHome1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db3.lemurnetworks.net)(PORT=1521)))
Services Summary...
Service "OEMREP.lemurnetworks.net" has 1 instance(s).
Instance "OEMREP", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "db3.lemurnetworks.net" has 1 instance(s).
Instance "db3", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
==========================================================================
Now I really need guru's help to move forward. Here are my questions:
What caused the "no listener" error and what can be done to get rid of it?
Is it possible to manually clear the change log if I know both servers are
in sync?
Thanks in advance!
Guoliang Cao