TNS Address problem

[pwoneill]

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.

[marist89]

Are you still running the 8.0.5 listener?

[pwoneill]

Nope, so they aren't competing for the port.

[marist89]

I was thinking more about the LD_LIBRARY_PATH pointing to the wrong path. I had a similar problem, but I was using a 8.1.7 listener with an 8.1.5 database and I had to put (ENVS='LD_LIBRARY_PATH=/u01/product/815/lib') in my listener.ora file.

[sreddy]

Do you have your current TNS_ADMIN path set under local modifications at the end of script for oraenv/coraenv ??

Give a try setting it and exporting the environment.