Solution to service failure after Oracle changes the machine name
After the machine name is changed in Oracle, the service cannot be started normally. You can do the following: 1. in the oracle \ product \ 10.2.0 \ db_3 \ network \ ADMIN directory, listener. change the LISTENER in the ora file to your new machine name. If there is a domain name, add the domain name; tnsnames. in ora, change ORCL to your new machine name. If there is a domain name, add the domain name. 2. there is a folder named "old machine name _ orcl" under oracle \ product \ 10.2.0 \ db_3 \. Change the old machine name to the new name 3. oracle \ product \ 10.2.0 \ db_3 \ Solaris \ j2ee has a folder named OC4J_DBConsole _ old machine name _ orcl, which can be used to change the old machine name 4. run emca-reops recreate in CMD to recreate the EM Database: 5. when you execute emca-config dbcontrol db and execute 4 or 5, you will be asked to enter SID: [that is, the database name. The default value is orcl] listener port number: [Default Value: 1521] SYS, DBSNMP, SYSMAN Password