Resolution of service failure after the machine name of Oracle10 is modified

After you modify the machine name of Oracle10, you will find that the service cannot be started. If you want to have a good understanding of this phenomenon or want to solve this problem, you can read the following articles to learn about how to modify the machine name of Oracle10.

After Oracle10 is installed, modify the machine name to make the oracledbconsoleorcl service unavailable. The specific solution is as follows:

1. Find D: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ listener. ora and change the original machine name to the new machine name.

2. Find the directory named after the original machine name under the D: \ oracle \ product \ 10.2.0 \ db_1 directory and change it to the new machine name.

3. Find the directory OC4J_DBConsole _ original machine name _ orcl under the D: \ oracle \ product \ 10.2.0 \ db_1 \ Solaris \ j2ee directory and change it to the new machine name. However, after Oracle10 is installed, the oracledbconsoleorcl startup reports an error of 3 and the path cannot be found. Let's continue with the operation.

4. Execute emca-repos recreate under the CMD command to re-create the EM database)

5. Run the command "emca-config dbcontrol db" in CMD.

Appendix:

SID: XXXX (Database Name, default orcl)

Listener port: 1521 (Port: 1521 by default)

SYS password: ****** (system administrator password)

DBSNMP User Password: system

SYSMAN user's password: sysman

Finally, at login prompt: ORA-12545: because the target host or object does not exist, reason: Machine name after the change appeared

Solution:

1. Find D: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ tnsnames. ora and change the original machine name to the new machine name. The modification is the same as that of listener. ora. After modification, you can log on.

The above content is to modify the machine name after Oracle10 is installed, causing the oracledbconsoleorcl service to fail to start. The specific solution is described. I hope you will find some gains.