8.16 and 8.0.5 listeners
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: 8.16 and 8.0.5 listeners

  1. #1
    Join Date
    Nov 2000
    Posts
    11
    Hello
    I have 8.0.5 and 8.1.6 running on a NT machine.
    I am trying to get 8.1.6 so that can connect to the db's that the 8.0.4 version can connect to.
    There is no problem accessing db through the 804 version but cant access anything through 8.1.6

    I have entered the appropriate tns entries but still get

    ERROR:
    ORA-12154: TNS:could not resolve service name

    I can not get both of the listeners to start and am not sure if i have set the 8.1.6 listener up to allow two listeners to run.
    I have supplied the listener files.

    What steps do i need to take to get this problem solved

    Thanks for any help you can offer

    RJ


    8.1.6 listener.ora file

    ORACLEORACLEHOME816LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oraking)(PORT = 1521))
    )
    )

    ORACLETNSLISTENER80 =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oraking)(PORT = 1521))
    )
    )

    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = oraking)(PORT = 1521))
    )
    )

    8.0.5 listener.ora file

    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
    (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    (ADDRESS = (COMMUNITY = NMP.world)(PROTOCOL = NMP)(SERVER = ORAKING)(PIPE = ORAPIPE))
    (ADDRESS = (PROTOCOL = TCP)(Host = oraking)(Port = 1521))
    (ADDRESS = (PROTOCOL = TCP)(Host = oraking)(Port = 1526))
    (ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
    (ADDRESS = (PROTOCOL=IPC)(KEY=RCV))
    )

  2. #2
    Join Date
    Oct 2000
    Posts
    48
    Don't know if this helps any or not, but in addition to starting the second listener on a different port than the first, you have to specify the name in the start command. So for the 8.1.6, set PORT=1522 (or any free port) in listener.ora, then try to start with:

    lsnrctl start ORACLEORACLEHOME816LISTENER

    Also, after upgrading from 8.0.5 to 8.1.6 on Sun, I was receiving the same ORA-12154 error when using sqlnet. However, commenting out the NAMES.DEFAULT_DOMAIN parameter in sqlnet.ora fixed this problem (suggestion taken from oracle doc #114085.1).

    Good luck.

    [Edited by lake612 on 12-14-2000 at 11:55 AM]

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    database links use TNSNAMES.ORA, what is important is to check TNSNAMES.ORA.
    Use 2 different ports as well

  4. #4
    Join Date
    Oct 2000
    Posts
    48
    Yes, you're right Pando, and I should have mentioned that too. However, in my case, my tnsnames.ora was correct and I never had to change it. Just removing that one parameter from sqlnet.ora completely solved my problem. But Rejoe could have a completely different problem than me. Anyway, that doc I mentioned gives many ways to troubleshoot the ORA-12154 error.

  5. #5
    Join Date
    Nov 2000
    Posts
    11
    Hello

    thanks for the help so far have manager to get the 816 listener running but still cannot get it to connect to other remote db's . i get this errror.

    ERROR:
    ORA-12154: TNS:could not resolve service name

    I copied over my tns file from 805 which does connect the other remote db's so i think this is correct.

    Any ideas on what is wrong.

    Thanks

    Rejoe

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    that simply means your tnsnames.ora is incorrect. DONT use tnsnames.ora from 8.0.5 for 8.1.6

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