Wednesday, January 23, 2019

Medical Records

I like to solve problems and one of the problem that I encountered is that if you are sick and seeing a doctor then you need to have few of your details handy like recent temperatures, medications taken, blood pressure and blood glucose readings.

The doctor would like to have a look that how each has been over a period of time.

Even sometime you would like to keep a track of these things for your own records.

I have Android phone and to fix this issue I have created and Android application which store this kind of information.

Now I can create profiles for all of my family member and keep their information different and if I am seeing a doctor then I just get their profile out and show it to doctor. It is much convenient and hoping that you like it as well.

Below is the Google Play store link from where you can download it:

https://play.google.com/store/apps/details?id=com.appowl247.fever

I will really like your feedback, please feel free to comment or provide feedback in Google Play.

Wednesday, January 16, 2019

Friday, January 11, 2019

FATAL: OCI listening thread exited. Failed to get IP address of host.

I am getting an error in the connection log when I am trying to connect to RAC database server


BLABLA(devel): sqlplus user/password@MY_TNS_NAME 

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 11 14:11:21 2019

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

FATAL: OCI listening thread exited. Failed to get IP address of host.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options

SQL>


As the name suggests sqlplus is not able to determine the IP address of local machine and showing this error.

It looks like it is a warning and can be fixed very easily by adding the hostname and the IP address in the /etc/hosts file.

Once it is done then I tried connecting and it is fixed.

BLABLA(devel): sqlplus user/password@MY_TNS_NAME    

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 11 14:13:19 2019

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options

SQL>