DBA – MySQL, PostgreSQL, MongoDB, Oracle
Background For the IGW application testbed preparation we need the schema export and then be imported. When export initiated by Data Pump EXPDP the oracle error showed up. UDE-22303: operation generated ORACLE error 22303 OCI-22303: type “SYS”.”KU$_STATUS1020″ not found Workaround Upon investigating in the alert log file the below lines are showing up indicating a…
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…
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…
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…