Migrating Bitnami WordPress website from AWS EC2 to VPS Bitnami NGINX

Steps to perform during migration: Install VPS with CentOS 7 without any LAMP stack. configure the x11 window and forwarding make a directory named as /bitnami to be used as installed directory Download the WordPress NGINX stack installer from bitnami. Login as root user, installation should be done as root user to avoid later complexities.…

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…