Listeners on 8.1.6
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Listeners on 8.1.6

  1. #1
    Join Date
    Jan 2001
    Posts
    4

    Question

    I want to run several listeners each pointing to a separate database on the same machine (unix hp-11). When I want I can then stop a particular listener to stop client software access, and use bequeath paths on the server to access those databases.

    But it doesn't work!

    I cannot get access thorught ports higher than 1521 yet the listener thinks everything is OK.

    What can I do?

    Thanks.....

  2. #2
    Anyway, Oracle doesn't recommend this; What if the user is already connected? Shutting the listener down won't get him away, you would have to "kill him".
    The recommended way is shutting the database down and bringing up in restricted mode.
    You should have only one listener.ora with many LISTENER_SOMETHING entries, and to start it you should put
    $ lsnrctl start listener_something
    Try it.
    (Check the port is not in use)
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Jan 2001
    Posts
    4
    We are migrating databases and trying to keep everything the same. We do already close the DBs before shutting the listener and then restart the DBs. We do have several entries in the listener.ora file as you remarked, but still this doesn't seem to work. Even though the file listener.ora is more or less the same as the one on 7.3.4

    Perhaps it is a port problem...

  4. #4
    Ok, to avoid any typo make the listener.ora with the Net8 Assistant.
    If you have HP 11 I guess you have 8i, the executable is netasst.
    Create the listener here and use other ports like 2001,2002,2003,etc; don't use 1521 or 1526 to verify you are not picking up a wrong listener.ora
    Ramon Caballero, DBA, rcaballe@yahoo.com

  5. #5
    Join Date
    Jan 2001
    Posts
    4
    I've set the listener.ora file.
    I've changed my tnsnames.ora
    Still nothing but ORA-12535: TNS:operation timed out

    Is there anything else I need to do?

    John.

  6. #6
    Join Date
    Jan 2001
    Posts
    4
    By the way, the listener file is in /etc. Could this be a problem?

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