Solution to service failure after Oracle changes the machine name

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