Enabling tracing for oracle LISTENER

Background: For the oracle errors like “ORA-12170: TNS:Connect timeout occurred”, “ORA-12535: TNS:operation timed out”, “ORA-12560: TNS:protocol adapter error”, “TNS-00505: Operation timed out” and like others related to oracle listener it is useful of tracing the listener activities to dig down further. Workaround: Connect to the listener control utility from the command line or shell. LSNRCTL…

Oracle-Error: opiodr aborting process unknown ospid ( ) as a result of ORA-609

Background: After shutdown and restarted the oracle instance by an executive, client can’t connect to database instance though database is up and running and listener service is up. OS: Windows Server 2012 x64, Oracle: 11g R2, Data Guard Configured Workaround: From the alert_SID.log file found the below error raised after shutdown and consecutive startup and when…

Show carrier’s current and previous rates information by destination

Background: After rate sheets applied in the billing system provided by the partners/carriers, executive likes to sort out the destination and carrier with their latest applied rates along with their very previous rates with the below format: Carrier Name | Destination | Prefix | Applied Date | Applied Rate | Previous Date | Previous Rate…

CDR cross check to resolute dispute with parties

In telecommunication sometimes it needs to analyze traffic to resolute dispute with parties; in this case either parties or both will provide their CDRs and will cross-check them. CDR cross-checking criteria: CDR should be matched with respect to call: start_time, a_party, b_party and duration Some cases partners have differences in the call pattern for a_party…