Pages

Tuesday 25 June 2013

Listener Not starting on Oracle11G gateway server.

We have Oracle 11G gateway in production and UAT environment, used to fetch data from sql database to oracle database and vise versa using DBLINKS. The issue comes whenever we required listener restart after adding entry in listener, it doesn’t start. It displays message “some services stop automatically if they are not in use” . I found some dg4msql.exe`s are running, so I tried to kill them but it doesn’t allow me. I decided to run task manager under Local System Account.
1)      Login to the server using admin console.
2)      Open command prompt and type command “AT 12:00 /interactive cmd.exe
3)      Open task scheduler and run created task, it will launch Command prompt.
4)      Type “taskmgr” on Command prompt, it will launch task manager. Now you will able to kill services using task manager.
5)      Kill all dg4msql.exe services.
6)      Now you are able to start Listener service.




0 comments:

Post a Comment