EBS to Cloud: FNDFS Failure

Hi Everyone!

We have been working on Oracle Cloud Migration for awhile. I thought to post some articles on this to share some information.

Our migration involves on-premise Exadata to Cloud ExaCS with Compute classic 7 node midtiers.
After the migration, startup script was complaining and FNDFS service failure.


adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_r12uat.

adalnctl.sh: exiting with status 1


adalnctl.sh: check the logfile /u01/app/applmgr/r12uat/inst/apps/r12uat_ovaqlofinappl1/logs/appl/admin/log/adalnctl.txt for more information ...

01/12/18-23:34:33 :: You are running adalnctl.sh version 120.3


Log file had the error

LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 12-JAN-2018 23:34:33

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=ovaqlofinappl1)(Port=1626))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

01/12/18-23:34:33 :: adalnctl.sh: Starting listener process APPS_r12uat.

LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 12-JAN-2018 23:34:33

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting /s_u01/app/applmgr/r12uat/apps/tech_st/10.1.2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.1.0.5.0 - Production
System parameter file is /u01/app/applmgr/r12uat/inst/apps/r12uat_ovaqlofinappl1/ora/10.1.2/network/admin/listener.ora
Log messages written to /u01/app/applmgr/r12uat/inst/apps/r12uat_ovaqlofinappl1/logs/ora/10.1.2/network/apps_r12uat.log
Error listening on: (ADDRESS=(PROTOCOL=TCP)(Host=ovaqlofinappl1)(Port=1626))
TNS-12533: TNS:illegal ADDRESS parameters
 TNS-12560: TNS:protocol adapter error
  TNS-00503: Illegal ADDRESS parameters

Listener failed to start. See the error message(s) above...

01/12/18-23:34:34 :: adalnctl.sh: exiting with status 1

After researching the errors it was I found that $TNS_ADMIN/sqlnet.ora generates

tcp.validnode_checking = yes
tcp.invited_nodes = (server1, server2,server3,server4.,server7)

I thought to comment out these two parameters at first, however sqlnet.ora is not template based autoconfig file.  It is generated by Java Class file.

since our design didn't have local DNS yet in Oracle cloud, we are unable to resolve few of the hosts that I have highlighted in Yellow.

I have worked around that by adding /etc/hosts  entries and things started fine with FNDFS listener.

Stay Tuned for more information on EBS Cloud Migration.