1. There should be a Service Manager defined.
Run the following statement as the APPS user:
select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like 'FNDSM%';
The above statement should return a value related to the CP node.
If the above does not return any value then please do the following: Go to $FND_TOP/patch/115/sql
Connect SQLPLUS as APPS user and run the following script :
afdcm037.sql.
This script will create libraries for FNDSM and create managers for preexisting nodes.
2. Verify the entries in the FND_NODES as correct.
Run the following statement as the APPS user:
select node_name "Node Name", node_mode "Mode", support_cp "C", support_web "W", support_admin "A", support_forms "F" from FND_NODES;
If the above statement returns any invalid node or IP address follow the steps provided in the following note to clean up and repopulate the table.
3. Verify entries in tnsnames.ora on CP node. The below entry should present in tnsnames.ora on CP node :
FNDSM_ORACLETEST_VIS=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracletest.idc.oracle.com)(PORT=1626)) (CONNECT_DATA=
(SID=FNDSM)
)
)
FNDSM_ORACLETEST.oracle.com_VIS=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracletest.idc.oracle.com)(PORT=1626))
(CONNECT_DATA=
(SID=FNDSM)
)
)
Where ORACLETEST is the "hostname", VIS is the "SID" and ".oracle.com" is domain.
4. Check that tnsping is successful for all entries related to FNDSM in tnsnames.ora on CP node.
$ tnsping FNDSM_ORACLETEST_VIS
TNS Ping Utility for Linux: Version 8.0.6.3.0 - (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=oracletest.idc.oracle.com)(PORT=1626)) OK (50 msec)
$ tnsping FNDSM_ORACLETEST.oracle.com_VIS
TNS Ping Utility for Linux: Version 8.0.6.3.0 - (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=oracletest.idc.oracle.com)(PORT=1626)) OK (0 msec)
5. Verify that no error exists in APPS Listener log file on CP node and it is running.
APPS Listener should be up and running for Service Manager to be up and running as expected. There should not be any error in the APPS Listener log file.
If there will be any error in APPS Listener log file then the Service Manager will not start properly.
Check the APPS Listener log file.
You can find this APPS Listener log file in one directory up of $TNS_ADMIN named as "apps_>:SID<:
6. Are you able to ping the host name/IP Address of the host. Host name and the related IP address should be pingable to get a connection like below :
$ hostname
ORACLETEST.oracle.com
$ ping ORACLETEST.oracle.com
PING ORACLETEST.oracle.com (10.100.100.10) 56(84) bytes of data. 64 bytes from ORACLETEST.oracle.com (10.100.100.10): icmp_seq=0 ttl=64 time=0.029 ms 64 bytes from ORACLETEST.oracle.com (10.100.100.10): icmp_seq=1 ttl=64 time=0.028 ms
--- ORACLETEST.oracle.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 999ms
rtt min/avg/max/mdev = 0.028/0.028/0.029/0.005 ms, pipe 2
$ ping 10.100.100.10
PING 10.100.100.10 (10.100.100.10) 56(84) bytes of data. 64 bytes from
10.100.100.10: icmp_seq=0 ttl=64 time=0.028 ms
64 bytes from 10.100.100.10: icmp_seq=1 ttl=64 time=0.028 ms
--- 10.100.100.10 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 999ms
rtt min/avg/max/mdev = 0.028/0.028/0.028/0.000 ms, pipe 2
7. Verify FNDSM does not give the "segmentation fault" at the time of execution.
Go to $FND_TOP/bin
$ FNDSM <- Enter
It should not give any segmentation fault here.
If it is giving any segmentation fault then it means that the executable is not relinked well.
Relink the executable as below.
$ adrelink.sh force=y "fnd FNDSM"
For Linux Operating System Please follow the notes below to get correct the segmentation fault by FNDSM
