AIK step 3.2 doesn't correctly set the hostname variable; "TNS:listener does not

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20

Description:
AIK step 3.2 doesn't correctly set the hostname variable, and then it fails to create the correct tnsnames.ora file, which causes the DB install to fail, which causes the Aleph21 install to fail.

We believe this is the line that is causing the problem:

SERVER_NAME=$(host $HOSTNAME | awk '{print $1}' | sed 's/\..*//')

The incorrect hostname it is generating: "Host";
the correct form it should be generating: 'labslcl0640'"

After correctling the tnsnames.ora manually, the install process then quits on step AIK 3.4 where it fails to verify the Oracle listener is working. We get this error message:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. The connection to the database aleph21 via listener hasn't been established yet...

We've tried several different attempts to fix this process, including modifying the installation script. We can connect to the DB on the UNIX command line, but cannot make the connection work in the installation script.

Resolution:
From Ex Libris: The problem was related to the fact that the host command failed to find the short server name in the DNS. The easiest solution is to add the lab domain to the search entry in /etc/resolv.conf (qalab.abc.edu)

We will also open a Jira issue to handle such cases in the next kit release.

Article last edited: 10/8/2013