DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2000

    I have installed 8.1.6 onto a machine that already has 8.0.4 installed on it .

    The 8.0.4 version accesses about 20 db's through the listener.

    I have added the tns entries to the 8.1.6 version but get the following error when trying to connect. I have checked these over and they seem OK
    ORA-12154: TNS:could not resolve service name

    How do i go about setting up the 8.1.6 listener to listen to the 8.0.4 dbs?



  2. #2
    Join Date
    Sep 2000
    I'm not aware that you can do that - surely you'll still have to go through the 8.0.4 listener for the 8.0.4 databases.
    I'm pretty sure you can have both running on the machine at the same time (since the 8.0.4 will be in the default_home, and 8.1.6 in a new home). You would of course need to use different ports for each listener, and update client TNSNAMES.ORA to point to the correct port for each database.

  3. #3
    Join Date
    Aug 2000
    Yes it's possible.

    I did it on an NT box with ora 734 and 816. ( while testing 7to8i migration )

    In the listener.ora file of the listeners, you have to define
    other ports to listen on.
    eg 734 : listener port 1521
    816 : listener port 1526

    You also have to start both the listener

    To specify which listener you want to use, specify the corresponding port in your tnsnames.ora file.

    Hope this helps

  4. #4
    Join Date
    Sep 2000
    That sounds like using 2 different listeners though like I suggested. (i.e. as in 2 listener services, one from 8.0.4 and one from 8.1.6 each listening for their respective database)

    I think the question was can he use the one listener (supplied with the 8.1.6 database) to listen for both the 8.0.4 and 8.1.6 database - to which I 'think' the answer is no.

  5. #5
    Join Date
    Aug 2000

    It should work with 8.1.6

    I am using 8.1.6 listener to connect to both 8.1.6 & 7.3.4 databases and assuming that it should work with 8.0.4 too.

    Any how please post your listener.ora and tnsnames.ora files here.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.