TNS Address problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: TNS Address problem

  1. #1
    Join Date
    Jun 2000
    Posts
    417
    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Are you still running the 8.0.5 listener?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    Posts
    417
    Nope, so they aren't competing for the port.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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
  •  



Click Here to Expand Forum to Full Width