I'm getting an error with Oracle Applications but I'm pretty sure it boils down to a TNS problem somewhere.

On our old 8.0.5 database, for the apps_sid listener, we would see messages like this in the listner log file.

<font face="courier">
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=9)(HOST=166.17.136.115)(PORT=1553))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
30-JUN-00 07:31:18 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=irad-rms)(USER=oralmc))(
COMMAND=status)(ARGUMENTS=64)(SERVICE=APPS_sand)(VERSION=134238208)) * status *
0
30-JUN-00 07:56:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=irad-rms)(USER=oralmc))(
COMMAND=stop)(ARGUMENTS=64)(SERVICE=APPS_sand)(VERSION=134238208)) * stop * 0
</font>

Followed by more data.

When I created the apps_sid listener for the new 8.1.6 database I pretty much mirrored what was on the 8.0.5 database making the proper changes to SID and paths where required, however when someone tries to connect I get

<font face="courier">
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=irad-rms)(PORT=1553)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
04-JAN-2001 15:15:59 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=irad-rms)(USER=oralmc)
)(COMMAND=status)(ARGUMENTS=64)(SERVICE=apps_funk)(VERSION=135290880)) * status
* 0
04-JAN-2001 15:39:13 * (CONNECT_DATA=(SID=FNDFS)(GLOBAL_NAME=FNDFS_irad-rms.worl
d)) * (ADDRESS=(PROTOCOL=tcp)(HOST=166.17.136.115)(PORT=49116)) * establish * FN
DFS * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12533: TNS:illegal ADDRESS parameters
TNS-12560: TNS:protocol adapter error
TNS-00503: Illegal ADDRESS parameters

DFS * 12500ESS=(PROTOCOL=tcp)(HOST=166.17.136.115)(PORT=49159)) * establish * FN
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12533: TNS:illegal ADDRESS parameters
TNS-12560: TNS:protocol adapter error
TNS-00503: Illegal ADDRESS parameters
</font>

Note the "Listening on: (DESCRIPTION=(ADDRESS=(...)))" for the 8.1.6 database where the 8.0.5 database (which works) has "Listening on: (ADDRESS=(...))"

Is that the problem or does 8.1.6 also show the (DESCRIPTION...)? If that is the problem, any ideas on how to resolve? The config files are all the same between the database (other than the required differences) so I'm not sure what else could be the problem.

If that's not the problem, any ideas on what it could be? I'll refrain from dumping my config files for now as it would be a lot of reading but if requested I'll put them up somewhere.