-
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.
-
Are you still running the 8.0.5 listener?
Jeff Hunter
-
Nope, so they aren't competing for the port.
-
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.
Jeff Hunter
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|