@ECHO OFF
CLS
SET OracleClientVersion=OracleClient_v10.2.0
SET CurrentPath=%1
ECHO.
ECHO 重置当前路径
%CurrentPath:~1,1%:
CD %CurrentPath%
ECHO.
ECHO 备份旧 Oracle 注册表信息
SET DATE_STRING=%DATE%
SET TIME_STRING=%TIME%
IF "%DATE_STRING:~3,1%"==" " (
SET DATE_STRING=%DATE:~4,10%
) ELSE (
SET DATE_STRING=%DATE:~0,10%
)
IF "%TIME_STRING:~0,1%"==" " (
SET TIME_STRING=0%TIME_STRING:~1,1%-%TIME_STRING:~3,2%-%TIME_STRING:~6,2%
) ELSE (
SET TIME_STRING=%TIME_STRING:~0,2%-%TIME_STRING:~3,2%-%TIME_STRING:~6,2%
)
REG EXPORT "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE" "%CommonProgramFiles%\Oracle_%DATE_STRING%_%TIME_STRING%.REG"
ECHO.
ECHO 删除旧文件
RD "%CommonProgramFiles%\BetterStart\Oracle\" /S /Q
REM ECHO 创建目录
MD "%CommonProgramFiles%\BetterStart\ORACLE\"
REM PAUSE
ECHO.
ECHO 复制oracle文件
COPY "%APPDATA%\Justep\X3Client\BetterStart\ORACLE\%OracleClientVersion%.exe" "%CommonProgramFiles%\BetterStart\ORACLE\" /Y
ECHO.
ECHO 解压缩文件
CD "%CommonProgramFiles%\BetterStart\Oracle"
"%CommonProgramFiles%\BetterStart\Oracle\%OracleClientVersion%.exe"
REM PAUSE
ECHO.
ECHO 修改注册表
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart" /V "ORACLE_HOME" /T REG_SZ /D "%CommonProgramFiles%\BetterStart\Oracle\%OracleClientVersion%" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart" /V "ORACLE_HOME_NAME" /T REG_SZ /D "ODACHome_BetterStart" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart" /V "ORACLE_GROUP_NAME" /T REG_SZ /D "Oracle - ODACHome_BetterStart" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart" /V "ORACLE_BUNDLE_NAME" /T REG_SZ /D "Enterprise" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart" /V "NLS_LANG" /T REG_SZ /D "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart" /V "OLEDB" /T REG_SZ /D "%CommonProgramFiles%\BetterStart\Oracle\%OracleClientVersion%\oledb\mesg" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart" /V "StmtCacheSize" /T REG_SZ /D "0" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart" /V "ORACLE_HOME_KEY" /T REG_SZ /D "SOFTWARE\ORACLE\KEY_ODACHome_BetterStart" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "CacheType" /T REG_SZ /D "Memory" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "ChunkSize" /T REG_SZ /D "100" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "DistribTX" /T REG_SZ /D "1" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "FetchSize" /T REG_SZ /D "100" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "OSAuthent" /T REG_SZ /D "0" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V " LSQLRset" /T REG_SZ /D "0" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V " wdChgDlg" /T REG_SZ /D "1" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "SchRstLng" /T REG_SZ /D "10000" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "UserDefFn" /T REG_SZ /D "0" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "DisableRetClause" /T REG_SZ /D "1" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "VCharNull" /T REG_SZ /D "1" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "TraceCategory" /T REG_SZ /D "0" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "TraceFileName" /T REG_SZ /D "c:\OraOLEDB.trc" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "TraceLevel" /T REG_SZ /D "0" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "TraceOption" /T REG_SZ /D "0" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "SPPrmDefVal" /T REG_SZ /D "0" /F
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome_BetterStart\OLEDB" /V "StmtCacheSize" /T REG_SZ /D "0" /F
ECHO.
ECHO 修改环境变量
"%APPDATA%\Justep\X3Client\BetterStart\ORACLE\ChangeEnvironmentVariable.exe" "%CommonProgramFiles%\BetterStart\ORACLE\%OracleClientVersion%\BIN"
ECHO.
ECHO 复制 tnsnames.ora 文件
DEL "%OracleClientVersion%\NETWORK\ADMIN\tnsnames.ora" /F /Q
COPY "%APPDATA%\Justep\X3Client\BetterStart\ORACLE\tnsnames.ora" "%OracleClientVersion%\NETWORK\ADMIN\" /Y
EXIT |