Orcale service cannot be started after oracle ip address change

Source: Internet
Author: User


After oracle changes the ip address, the orcale service cannot be started. Today, the virtual machine is configured with an ip address, so that the virtual machine and the host are in the same network segment, and then webservice is used successfully, but a new problem arises, oracle cannot be connected. Www.2cto.com: I found that the OracleOraDb10g_home1TNSListener service was automatically disabled after it was started. I think it must be related to ip address change, the following method was used to immediately succeed: 1. running emca-config dbcontrol db in the cmd environment requires the user to enter the database SID. My database SID is the default orcl, and the listening port is 1521 by default. Then configure it step by step. Start OracleDBConsoleorcl. 2. Use Oracle net configuration assistant, an application that comes with orcale, to delete the original listener and configure a new listener. The method is simple. OracleOraDb10g_home1TNSListener can be started, and the database will resume normal use.
 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.