DBA OCP | Database Engineer | Developer (MS Access, VBA)
Why partitioning: Enhances the performance, manageability, and availability. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces. When to partition a table: Tables larger than 2gb size. Historical data Contents must be stored in different storage Avoid index maintenance when data is removed Index maintenance on parts of data like rebuilding…
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.…
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…
Background: For the purpose of taking backup of the MS access database, VBA script failed for one of the tables of the source database, showing “Property not found Error: 3270“. Resolution: Compact and repairing didn’t solve the issue, recreated the table also didn’t help. Upon further dig down its been observed that removing the “Calculated”…
Background When you create a virtual machine in VirtualBox the virtual machine or OS needs internet or the virtual machine and your physical machine need to talk to each other or the virtual machine need to be reached from other computers from the network and vice-versa. These are done by VirtualBox networking which uses its…
Background Cloning of a virtual machine is the easiest way around to get the copy of the same operating system environment which saves time and effort of another installation and configuration of the same. Workaround Choose the virtual machine that should be cloned. Right click on the VM and select “Clone”. Provide the “Name”, “Path”…
Background Individuals working in the soft engineering like database, software, development, quality assurance more often needs to deploy & configure different things which need to have an Operating System obviously and sometimes more. With the advent, maturity and easy to get virtual technologies like VirtualBox, Vmware and Parallels Desktop and others it is easier to…