Oracle Database PL/SQL that's something---changed your computer's username.

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.