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?
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
(Check the port is not in use)
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...
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
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?
By the way, the listener file is in /etc. Could this be a problem?
Click Here to Expand Forum to Full Width