After the computer name is changed, Oracle cannot start properly. Solution

Source: Internet
Author: User

After the computer name is changed, Oracle cannot start the problem properly. The solution has found a lot of information on the Internet, but none of them can solve my problem completely. The following is an example, for your reference (my Oracle is installed on the D Drive): 1: first, change D: two files (tnsname. ora, listener. ora) change the host name to your computer name. If these two files are modified, the pl/SQL connection to Oracle is not affected, but the OracleDBConsoleorcl service cannot be started normally. 2: Find the folder named "old computer name _ ORCL" in the Directory D: \ oracle \ product \ 10.2.0 \ db_1, change to "current computer name _ ORCL"; then find: D: change the "OC4J_DBConsole _ old computer name _ ORCL" folder under the \ oracle \ product \ 10.2.0 \ db_1 \ Solaris \ j2ee directory to "OC4J_DBConsole _ current computer name _ ORCL ", if the following error occurs, see step 1. C:> set oracle_sid = orcl C:> emctl start dbconsole Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996,200 5 Oracle Corporation. all rights reserved. http: // old computer name: 1158/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database Control... the OracleDBConsoleorcl service is being started. the OracleDBConsoleorcl service cannot be started. System error. 3: Enter $ emca-config dbcontrol db in the command line and enter the following information: SID: XXXX Listener port number: 1521 Sys password, emctl start dbconsole again.
 

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.