Listener down in Oracle 11g
Posted on 2009-07-08
I have an Oracle 11g database on Windows 2003 on a VM hypervisor. Yesterday morning we the listener was down. I started the listener and then started the database, no problem. Then sometime during the day, the listener went down. I tried bringing the listener back up but I'm getting a TNS error. What is causing this? There are many users on this system so I'm not sure if anything was changed. One theory I have is that the listener runs because it sees the only instance and uses the default settings. But when it needs the listener.ora file or tns file there is incorrect info. in these files?? How do I fix the problem so the listener stops going down?