When it is time to go on a vacation break or there is inclement weather, someone (staff and client) always report a database log in failed error which is always expected as everyone is trying to retrieve information that they will need during their time off from work or school since time restrictions can be placed on the resources for maintenance.

Database Log In Failed
TNS is unable to connect to destination. Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.

Verify that the TNS name in the connectstring entry of the DAD for this URL is valid and the database listener is running.

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory Error-Code:1034 Error TimeStamp:Sat, 17 Jan 2015 07:45:02 GMT

Where It Happens
The issues mostly happen at educational institutions (colleges and universities) as that uses Ellucian Banner Navigation.

Why It Happens
This is usually a sign that the database is down and needs to be restarted. Since it is near vacation break or closure due to inclement weather (as I mentioned earlier), the database geeks are most likely taking the opportunity to do maintenance without giving anyone sufficient forewarning. At times, notifications are sent via email at the last minute when people are ignoring emails and are planning what fun they will have over the break or lost access to email.

Database Log In Failed
TNS is unable to connect to destination. Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.

Verify that the TNS name in the connectstring entry of the DAD for this URL is valid and the database listener is running.

ORA-12170: TNS:Connect timeout occurred Error-Code:12170 Error TimeStamp:Sat, 17 Jan 2015 07:45:02 GMT

Temporary Fix
It is not my duty to restart the database server but it is my duty to make sure that the free Internet browsers that our staff and clients are accessing the database with is Internet Explorer (if on a Windows PC) and at least version 9. For the staff, this is an easy fix as I can make changes to their devices. I cannot update their home devices but since the release of Windows 10, I have not gotten a call regarding the issue.

The following two tabs change content below.

• Bio
• Latest Posts

Stephan Pringle

Technology Support Specialist at Sipylus

About The Author: Stephan Pringle is an Information Technology Support Specialist. He covers hardware and software and provides tips for you to troubleshoot and repair issues on your own. In his spare time, he writes articles about the State of New York on his Hackintosh and HackBook and that has helped him to become the top contributor of the New York City section of Yahoo! Answers.

Latest posts by Stephan Pringle (see all)

• Importing a PDF File to an Excel File - Saturday, August 19, 2023