Id Date Task Module Version Description Comment
1 2019-03-07 05:27:42 @ 2019-03-07 Research & Development Oracle Spatial 12c Geocoding, Spatially enabling a table, Spatial indexing, Spatial examples to practice, Moving spatial data to a dedicated tablespace, SPATIAL_VECTOR_ACCELERATION to increase performance, Java API, Adding user data like pinning in map(Location data enrichment), Spatial Operators, Procedures, and Functions, SDO_WITHIN_DISTANCE, Tolerance and an Input Parameter Chapter-1: Spatial Concepts
2 2019-03-07 10:57:31 @ 2019-03-07 Project: Nagad DFS Multiple connections from single instance in Dev server 0.2.6 Multiple connections creating from the developers instance, a maximum of 40 connections observed. Current version 0.2.6 is using multiple days sources which might be too he causes of the bottlenecks, in previous version one data source was using and no hicckup found. Diagnosed with Cyrus user.
3 2019-03-09 23:05:11 @ 2019-03-07 Meetings Database Backup Dev DB Optimization Spatial/GIS data operation performance improvements Querying transaction history optimization Meeting with CTO Khaled bhai
4 2019-03-09 23:15:25 @ 2019-03-07 Website Posts/Maintenance Implemented Task Logger and Show Activities in www.kaysariqbal.com Using wordpress plugins implemeted task logging and showing activities. Plugins used Contact Form 7, Save Contact Form 7 and WordPress Tables. Pages built and used are Task Logger, Show Activities both of them are password protected. Additionally ARI Adminer is used to show and edit the rows from WordPress admin panel.
5 2019-03-10 01:38:40 @ 2019-03-10 Database Administration Changing or altering user password Changed password for the user TEMP_AUTH & TEMP_DBS in the ORCL development db hosted in Tuhin\'s Desktop VM.
6 2019-03-10 09:06:07 @ 2019-03-10 Research & Development Oracle Spatial 12c 2.1 Simple Example: Inserting, Indexing, and Querying Spatial Data 2.2 SDO_GEOMETRY Object Type Table 2-1 Valid SDO_GTYPE Values 2.2.2 SDO_SRID 2.2.2 SDO_SRID 4.1.2 Bulk Loading Point-Only Data in SDO_GEOMETRY Objects 4.1.2 Bulk Loading Point-Only Data in SDO_GEOMETRY Objects 5.2 Querying Spatial Data 5.2.1.1 Primary Filter Operator 5.2.1.2 Primary and Secondary Filter Operator 5.2.1.3 Within-Distance Operator 5.2.1.4 Nearest Neighbor Operator 6.1.3 Geodetic Coordinates (Geographic Coordinates) 6.2.2 Choosing a Geodetic or Projected Coordinate System 6.1.3 Geodetic Coordinates (Geographic Coordinates) 6.7 Coordinate Systems Data Structures 6.13 Google Maps Considerations
7 2019-03-11 03:49:44 @ 2019-03-11 Research & Development Oracle Spatial 12c 9.1 Spatial Information and Data Mining Applications 12.1 Concepts for Geocoding; 12.1.1 Address Representation 13.1 Business Directory Concepts SQL Statements for Indexing Spatial Data Spatial Operators Reference: Oracle Spatial and Graph Developer\'s Guide 12c
8 2019-03-12 04:42:28 @ 2019-03-12 Research & Development Install Smaple Schemas in Test DB 12c Installed test sachemas in test database to implement various oracle spatial / locator features for google maps in mobile applications.
9 2019-03-12 23:45:50 @ 2019-03-12 Research & Development Oracle Spatial 12c Written down the action plan to implement the oracle spatial approach to the GIS data, sat with tuhin bhai discussed some SQL performance tuning issues, requested to get the location data from Nagad.
10 2019-03-13 01:19:26 @ 2019-03-13 Aunko WebSite Renew Lets Encrypt SSL certificate manually. Run the below command manually from ubuntu user when notification email arrived: #renew Let\'s Encrypt SSL certificate sh /etc/lego/renew-certificate.sh
11 2019-03-13 05:20:58 @ 2019-03-13 Aunko WebSite Rearrange the main menu and links Rearranged the menu links, includes only Home,Features and Buy. Others linked are transferred to the bottom of page. inspired from inc.com article.
12 2019-03-13 05:26:46 @ 2019-03-13 Aunko Technical/User Documentation Technical documentation hosted in website Technical documentation ported to website, will be used as central repository of technical docs for operational and referencing tasks. It should be strictly maintained.
13 2019-03-14 11:07:14 @ 2019-03-14 Meetings Nagas DB down Meeting with nagad team, deadlock happened by query from app, index was added to the referential foreign key column.
14 2019-03-27 10:36:13 @ 2019-03-27 Aunko Desktop FrmACT_OnInstall, start using aunko from uqid other than registered one 1014 Start using aunko after installation for a valid and active instance from another uqid other than the registered one. In progress
15 2019-03-28 08:13:58 @ 2019-03-28 Database Development Query writing to find Token and Pan Kmdbp database WITH PD AS (SELECT SUBSTR ( CUBEONE.xx1.dec_varchar2_sel (PAN, \'10\', \'CARD_INFO\'), 1, 6) AS pand, id FROM PAN_DETAILS), TPMAP AS (SELECT bin_Pan, bin_token FROM TOKEN_BIN_TO_PAN_BIN_MAPPING), TSQ AS (SELECT seq_name, id, bin_token FROM token_bin_Seq) SELECT DISTINCT --td.created, CUBEONE.xx1.dec_varchar2_sel (td.token, \'10\', \'CARD_INFO\') AS token, pand AS PAN, bin_pan, pd.id AS PAN_ID, TSQ.SEQ_NAME, tsq.bin_token FROM pd JOIN tpmap ON (pd.pand = tpmap.bin_pan) JOIN token_details td ON (TD.PAN_DETAILS_ID = pd.id) JOIN tsq ON (tsq.id = tpmap.bin_token); Query provided to Saikat to find Token and Pan values which matched.
16 2019-04-02 05:44:02 @ 2019-04-01 Aunko Desktop Activating from another UQID 1014 Start using aunko after installation for a valid and active instance from another uqid other than the registered one.
17 2019-04-02 05:48:37 @ 2019-04-02 Database Administration DEV db stuck 12c No user can\'t do any work, connection time was too slow. More than one connection is happening from backend though previous time session kill will do the job, but this time totally halted. From linux process there were zombie process seen, when listing with top no actual process were shown but a unknown and suspicious name was showing. From alert log file it shows the Fatal NI connect error 12170. After database shutdown still it was 95% cpu usage, then rebooted the VM then started the DB along with profile IDLE_TIME set to Five minutes solved the situation.
18 2019-04-02 11:38:32 @ 2019-04-02 Database Administration Recreating DEV DB instance as it compromised 12c DEV db has been compromised as it has access from pubic network, to meet the continuing development the development database server should be functional. To resolve, as the dev server was in VM and QA also in a VM machine and QA holds the tends to same db design copied the QA VM disk files and created a new VM to serve as DEV server. Later ip configured for new VM, db instance made up and running, small tuning of SGA and Parallel processing.
19 2019-04-03 02:32:26 @ 2019-04-03 Database Administration Install & Configure Oracle 12c RAC in VirtualBox 12c ORacle RAC 12c should be configured to resolve DBBL Nexus Pay issues where some components are failing. Today got the physical machine delivered by the IT Service department.
20 2019-04-04 05:43:08 @ 2019-04-04 Database Administration Install & Configure Oracle 12c RAC in VirtualBox 12c Faced network issues, two vm can talk to each other for public and private net but from my laptop vm2 public bridge ip is not reachable.
21 2019-04-07 23:56:27 @ 2019-04-07 Database Administration Install & Configure Oracle 12c RAC in VirtualBox 12c Work in progress
22 2019-04-07 23:58:19 @ 2019-04-07 Database Administration Create Nagad Release test db server 12c Current release test server for Nagad, os installed and database created. Export backup taken from DEV server.
23 2019-04-07 23:58:56 @ 2019-04-08 Database Administration Create Nagad Release test db server 12c Exported database imported to newly created database server.
24 2019-04-08 13:23:23 @ 2019-04-08 Database Administration Create Create Nagad Release test db server Database backup from Dev server has been imported, server is usable.
25 2019-04-08 13:27:16 @ 2019-04-08 Database Administration Install & Configure Oracle 12c RAC in VirtualBox 12c DNS server has been configured and the cluster installation error has been resolved, the error raised due to the absence of scan ips reachability from the nodes. This has been done based on Oracle base tutorial on host only network. This same thing should be done with the bridge network ips to reach from the biz network. The performance of the VM nodes are painstakingly slow.
26 2019-04-09 11:00:04 @ 2019-04-09 Database Administration Can\'t connect to new Nagad Test Release Db 12c Bodiuzzaman can\'t connect to the db while deploying the component, though the db server was up and running. During the connection attempt Listener handlers related error was showing. As the db is in the dedicated connection mode and he hadn\'t closed sessions all the processes were eaten by users, no process can\'t be attached for new connection. Changed the process to 500 and restart the db solve the problem.
27 2019-04-09 13:01:30 @ 2019-04-09 Database Administration Install & Configure Oracle 12c RAC in VirtualBox 12c Got error while configuring cluster, cluster verification failed for umask for Oracle user on both nodes, chrony has failed also to synchronize with external entity. Should fix the errors and try again.
28 2019-07-03 02:42:18 @ 2019-07-03 Database Administration create new schema nd import data 12c For G I Al Mamun Bhai, created user AUTH_SERVER_KBC and imorted data from AUTH_SERVER schema in DEV-DB server.
29 2019-07-03 02:43:39 @ 2019-07-03 Database Administration Import full QA server database into Release-Test database 12c For testing purpose imported full QA db server database into the Release testing database.
30 2019-07-03 06:07:57 @ 2019-07-03 Project: Nagad DFS Merchant fee calculation configuration scripts 0.2.9 HF Ensure the maximum records involved in the scripts to ensure those will run smoothly. Queried Abdullah Al Mamun DBA of Nagad and got the output. /* Formatted on 7/3/2019 10:08:28 AM (QP5 v5.256.13226.35538) */ SELECT MAX (CLR_TRSN_ID) FROM \"KOD\".\"CLEARING_TRANSACTION\"; SELECT CLR_TRSN_ID FROM \"KOD\".\"CLEARING_TRANSACTION\" ORDER BY 1 DESC FETCH FIRST 5 ROWS ONLY; SELECT MAX (SEQ) FROM \"KOD\".\"FEE_RATE\"; SELECT SEQ FROM \"KOD\".\"FEE_RATE\" ORDER BY 1 DESC FETCH FIRST 5 ROWS ONLY; SELECT MAX (TO_NUMBER (CLR_CD)) FROM \"KOD\".\"CLEARING_CODE\"; SELECT CLR_CD FROM \"KOD\".\"CLEARING_CODE\" ORDER BY 1 DESC FETCH FIRST 5 ROWS ONLY; SELECT MAX (ID) FROM \"KOD\".\"PARTNER_GROUP\"; SELECT ID FROM \"KOD\".\"PARTNER_GROUP\" ORDER BY 1 DESC FETCH FIRST 5 ROWS ONLY;
31 2019-07-04 05:36:26 @ 2019-07-04 Database Administration Gone through AWR Report of Nagad nodes 12c Going through AWR, findings points that need to be pointed out.
32 2019-07-04 05:38:13 @ 2019-07-04 Project: Nagad DFS Meeting at Nagad premise 12c Performance tuning and current DB bottlenecks issues.
33 2019-07-07 02:02:48 @ 2019-07-03 Database Administration Import full QA server database into Release-Test database 12c For testing purpose imported full QA db server database into the Release testing database.
34 2019-07-07 02:04:53 @ 2019-07-04 Project: Nagad DFS AWR report go through and preparation of final outcome 12c From Nagad AWR reports for RAC instance has given, going through this reports.
35 2019-07-07 02:05:10 @ 2019-07-05 Project: Nagad DFS AWR report go through and preparation of final outcome 12c From Nagad AWR reports for RAC instance has given, going through this reports.
36 2019-07-07 02:05:28 @ 2019-07-07 Project: Nagad DFS AWR report go through and preparation of final outcome 12c From Nagad AWR reports for RAC instance has given, going through this reports.
37 2019-07-07 03:41:13 @ 2019-07-07 Project: Nagad DFS Hot Fix for KOD 0.2.9 0.2.9 HF Hot fix for KOD