----------------------------------------
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\cloneDBCreation.sql :中第（4，22，38，39）行中的XE改为mysid
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\cloneDBCreation.sql(4): Create controlfile reuse set database "mysid"
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\cloneDBCreation.sql(22): Create controlfile reuse set database "mysid"
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\cloneDBCreation.sql(38): alter database "mysid" open resetlogs;
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\cloneDBCreation.sql(39): alter database rename global_name to "mysid";
----------------------------------------
'D:\oracle\app\oracle\product\10.2.0\server\config\scripts\init.ora' :中第（13）行中的XE改为mysid
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\init.ora(13): db_name=mysid
----------------------------------------
'D:\oracle\app\oracle\product\10.2.0\server\config\scripts\initXETemp.ora' : 中第（13）行中的XE改为mysid
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\initXETemp.ora(13): db_name=mysid
----------------------------------------
'D:\oracle\app\oracle\product\10.2.0\server\config\scripts\XE.bat' 中第（14，16，18）行中的XE改为mysid
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\XE.bat(14): set ORACLE_SID=mysid
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\XE.bat(16): D:\oracle\app\oracle\product\10.2.0\server\bin\oradim.exe -new -sid mysid -startmode manual -spfile > D:\oracle\app\oracle\product\10.2.0\server\config\log\XE.bat.log，
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\XE.bat(18): D:\oracle\app\oracle\product\10.2.0\server\bin\oradim.exe -edit -sid mysid -startmode auto -srvcstart system >> D:\oracle\app\oracle\product\10.2.0\server\config\log\XE.bat.log
若你想修改http的监听端口可修改一下文件
D:\oracle\app\oracle\product\10.2.0\server\config\scripts\postDBCreation.sql中第（9）行中的dems_xdb.sethttpport(9098);
然后运行D:\oracle\app\oracle\product\10.2.0\server\config\scripts\XE.bat。
运行完XE.bat后进入D:\oracle\app\oracle\product\10.2.0\server\database中复制名为PWDXE.ora，initXE.ora的文件，更改文件名分别为PWDMYSID.ora，initMYSID.ora
修改D:\oracle\app\oracle\product\10.2.0\server\NETWORK\ADMIN中listener.ora中
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\oracle\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_mysid))
(ADDRESS = (PROTOCOL = TCP)(HOST = lp)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (mysid)
修改D:\oracle\app\oracle\product\10.2.0\server\NETWORK\ADMIN中tnsnames.ora中
mysid=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lp)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mysid)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_mysid))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
OR