When installing the Oracle database's PL/SQL tool, the computer name is the name of the user name that is automatically generated after reloading the system, as a programmer, there is a strong obsessive-compulsive disorder, you want to use their English name as the name of their computer, so the name of the computer changed; Results pl/ The SQL database visualizer cannot be opened; Here are the steps to modify the Oracle database-related data after modifying the computer user name :
This problem occurs after the modification:
Windows cannot start ORACLEDBCONSOLEORCL on the local computer
Steps to resolve:
1. Start-"Run cmd"
2. Execute Emctl start Dbconsole
C:\Documents and Settings\xcl>emctl start Dbconsole
environment variable ORACLE_SID not defined. Please define it.
Hint: The environment variable oracle_sid is undefined, please define it.
3, set Oracle_sid =ORCL (ORCL is my instance name, is also the service name)
C:\Documents and Settings\xcl>set ORACLE_SID=ORCL
4, re-execute emctl start dbconsole
C:\Documents and Settings\xcl>emctl start Dbconsole
Oc4j Configuration issue. E:\ORACLE\PRODUCT\10.2.0\DB_1/OC4J/J2EE/OC4J_DBCONSOLE_CHINA-D9E3F7D07_ORCL not found.
Tip: Unable to find "E:\ORACLE\PRODUCT\10.2.0\DB_1/OC4J/J2EE/OC4J_DBCONSOLE_CHINA-D9E3F7D07_ORCL"
Note: China-d9e3f7d07 is the name of my Computer
Copy the "OC4J_DBCONSOLE_LOCALHOST_ORCL" folder under the directory in the same directory and change the name to "OC4J_DBCONSOLE_CHINA-D9E3F7D07_ORCL".
5, re-execute emctl start dbconsole
C:\Documents and Settings\xcl>emctl start Dbconsole
EM Configuration issue. E:\ORACLE\PRODUCT\10.2.0\DB_1/CHINA-D9E3F7D07_ORCL not found.
Tip: Unable to find "E:\ORACLE\PRODUCT\10.2.0\DB_1/CHINA-D9E3F7D07_ORCL"
Copy the "LOCALHOST_ORCL" folder under the directory in the same directory and change the name to "CHINA-D9E3F7D07_ORCL".
6, re-execute emctl start dbconsole
C:\Documents and Settings\xcl>emctl start Dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
http://localhost:1158/em/
Starting Oracle Enterprise Manager 10g Database Control ... Oracledbconsoleorcl
Service is starting
..............................
ORACLEDBCONSOLEORCL Service has started successfully
Oracle Database PL/SQL that's something---changed your computer's username.