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…

Linked tables having Calculated field can’t be made Local in MS Access 2016

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”…

Cloning a virtual machine in VirtualBox

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”…

Create an ECS Linux instance in OpenStack based Fusion Cloud

What is an ECS? ECS stands for Elastic Cloud Server that facilitates computing needs for applications, technically it is a virtual machine in cloud environment. Steps to create an ECS: Determine the resource required like cpu, memory and storage. Determine the Operating System images with required version. For networking create a VPC if not already…

Configure sending mail by sendmail in Ubuntu Linux

Background: I need email functionality to send emails from the web server by querying data from MySQL database and email the result to appropriate recipient. Workaround:  Install sendmail. sudo apt-get update sudo apt-get install sendmail Install mailutils. sudo apt-get install mailutils Configure the /etc/hosts file, provide your domain name in the following format 127.0.0.1 localhost…

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…

MS Access Error: 3162: “You tried to assign the Null value to a variable that is not a Variant data type.”

Background: All of a sudden importing data from spreadsheet in a form produced the above error(it was tested and worked fine over two weeks), the same operation in another form is executing fine. This is bit frustrating when everything seems fine, no errors in logic or elsewhere but things are not working. Solution: Digging down further…