user521233 wrote:Single listener can support multiple instances in multiple ORACLE_HOME & even multiple IP# & ports.
sorry but i'm a bit of a noob with database administration.
i have a windows 7 box with an oracle 11g database. i was wanting to create a new listener to listen for requests on the machines ip address. traditionally the database is down and i go into windows services and start the database and listener from there.
i created new listener using Oracle Net Configuration Assistant and noticed in the windows services list. then i deleted it using the same tool.
i created a new listener using Oracle Enterprise Manager, did not notice it in the windows services list but understand that it is dynamically created? either way... i deleted it.
now, the funny thing is that i have a second listener in windows services list. i'm unable to see it using Oracle Net Configuration Assistant. the ususal listener in that list is started. Oracle Enterprise Manager only sees one listener and is unable to start it. i'm able to connect to the database using sqlplus.
i'm a little confused...
can i delete the listener that i can't start in Oracle Enterprise Manager to see if it rids me of the extra listener in the windows services list? why can't OEM see the started listener from the windows services list?
thanks for any direction in the matter.
user521233 wrote:My biggest peeve are folks who too lazy & inconsiderate to mark threads as answered.
its my biggest peeve when people respond yet provide nothing helpful.
user521233 wrote:since V10 no listener.ora file is required to start or use the listener.
do you suggest that i simply leave my configuration at situation 2 above then, sb92075? with tns_admin set to "C:\oracle11g\product\11.2.0\dbhome_1\NETWORK\ADMIN"?
is it best to remove any entries in the listener.ora files that i have (if it wasn't clear, this is simply a workstation and has no external facilities accessing it)?