[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 499
  • Last Modified:

Can't start Oracle service (TNS error) !! Need help urgent!!

I get this error message when I try to manually start the listener from Control Panel:

"The OracleOraDb10g_home1Listener service on Local Computer started then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service. "

Is there anything I can do to manually start the service?

I have installed the Oracle Database a month back and it was working fine. I have also installed Oracle Forms and even that was working fine. Last week I moved to a new apartment and seems that IP address has been changed.
Do you think this has messed it up.

Could you please help me out in resolving this issue.

Thanks,
Vishal
0
vishal_singh
Asked:
vishal_singh
  • 2
1 Solution
 
Pra4444Commented:
check in the system event log for more accurate error information...which might help you solve the issue..
0
 
vishal_singhAuthor Commented:
What do you want me to check in it.
Could you be more specific about it
0
 
pavan27Commented:
yes,

this is the problem with ip address.

go to command prompt
type ipconfig /all

check the ip address in your listener.ora file and tnsnames.ora. can change it accordingly
0
 
vishal_singhAuthor Commented:
Good
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now