default and non-default port# and listeners?
Hi,
As we all know that by default Oracle instance port is on "1521" and the listener name is LISTENER. I have multiple instances on each port and thus different LISTENER names in one host as follows:
1) DB1 -> on default port "1521" on default LISTENER
2) DB2 -> on port "1547" on LISTENER_DB2
3) DB3 -> on port "1549" on LISTENER_DB3
This makes auto dbstart and dbshut more complicated. But I don't want to put all instances in one port/one listener because if one port/listener dies, it'd impact all 3 intances.
Q1) How often and what would make listener die?
Q2) Can I put all 3 different ports on ONE default listener, called "LISTENER"? Any negative impact?
What's your take on this?
Any suggestions/insights would be greatly appreciated :)
Helen