THE ORACLEORADB10G_HOME1TNSLISTENER SERVICE ON LOCAL COMPUTER STARTED AND THEN STOPPED

Sunday, March 24, 2013 ·


Database in windows throws an error when starting up the listener service:


“THE ORACLEORADB10G_HOME1TNSLISTENER SERVICE ON LOCAL COMPUTER STARTED AND THEN  STOPPED. SOME SERVICES STOP AUTOMATICALLY IF THEY HAVE NO WORK TO DO, FOR EXAMPLE, THE PERFORMANCE LOGS AND ALERTS SERVICE.”


-          Verify how many listener you have in the server
-          Ensure the listener you are working with, the environment as set properly such as “ORACLE_HOME”, “PATH”
-          When shutting and starting the service, verify your required listener service is starting ( when starting it will be mentioned in the command prompt)
-          Verify all the entries are correct in the listener file manually.
-          If nothing works out, recreate the listener using Network Configuration Assistant.
-          Stop and verify (or add) all the service that the respective listener should listen to.

0 comments:

Search This Blog

About Me

I am an Oracle certified DBA and Apps DBA, totally loving my field of work. I have created this blog in order to save my studies in my field and share it with all.

View Asif Muhammad's profile on LinkedIn

Which is the most featurized database???

Followers

Site Traffic