Oracle 10g怎么重新注册哈~

Question

咱把Win2003注册表中的Oracle项干掉了，数据库貌似傻到了，怎恢复咧？~

Answer 1

手动添加相应注册表内容。
或者将数据库备份后，重新安装oracle软件。
第一个方法也不麻烦，其实主要就oracle_sid,oracle_home,oracle_base,nls_lang,然后还有后台服务在注册表中的内容。

Answer 2

可以参照别人机器上的，也可以自已重装了再恢复，见：http://www.eygle.com/archives/2006/08/oradim_on_windows.html 

Answer 3

Win2003,Oracle 10g的朋友可以帮上这个忙的，不过LZ要注意一下路径。

Answer 4

运行：regedit；
第三项，software,oracle
特别是HOME0

Answer 5

Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"inst_loc"="C:\\Program Files\\Oracle\\Inventory"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1]
"ORACLE_HOME"="d:\\oracle\\product\\10.2.0\\db_1"
"ORACLE_HOME_NAME"="OraDb10g_home1"
"ORACLE_GROUP_NAME"="Oracle - OraDb10g_home1"
"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
"ORACLE_BUNDLE_NAME"="Enterprise"
"OLEDB"="d:\\oracle\\product\\10.2.0\\db_1\\oledb\\mesg"
"StmtCacheSize"="0"
"StatementCacheSize"="0"
"OO4O"="d:\\oracle\\product\\10.2.0\\db_1\\oo4o\\mesg"
"SQLPATH"="d:\\oracle\\product\\10.2.0\\db_1\\dbs"
"ORACLE_HOME_KEY"="SOFTWARE\\ORACLE\\KEY_OraDb10g_home1"
"MSHELP_TOOLS"="d:\\oracle\\product\\10.2.0\\db_1\\MSHELP"
"ORACLE_BASE"="d:\\oracle\\product\\10.2.0"
"RDBMS_CONTROL"="d:\\oracle\\product\\10.2.0\\db_1\\DATABASE"
"RDBMS_ARCHIVE"="d:\\oracle\\product\\10.2.0\\db_1\\DATABASE\\ARCHIVE"
"ORA_STUDY_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_STUDY_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_STUDY_SHUTDOWNTYPE"=hex(2):69,00,6d,00,6d,00,65,00,64,00,69,00,61,00,74,\
  00,65,00,00,00
"ORA_STUDY_SHUTDOWN_TIMEOUT"=hex(2):39,00,30,00,00,00
"ORA_RMANDB_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_RMANDB_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_RMANDB_SHUTDOWNTYPE"=hex(2):69,00,6d,00,6d,00,65,00,64,00,69,00,61,00,74,\
  00,65,00,00,00
"ORA_RMANDB_SHUTDOWN_TIMEOUT"=hex(2):39,00,30,00,00,00
"ORACLE_SID"="rmandb"
"nls_date_format"="yyyy-mm-dd hh24:mi:ss"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ODP.NET]
"TraceFileName"="C:\\ODPNET.trc"
"TraceLevel"="0"
"TraceOption"="0"
"StatementCacheSize"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB]
"CacheType"="Memory"
"ChunkSize"="100"
"DistribTX"="1"
"FetchSize"="100"
"OSAuthent"="0"
"PLSQLRset"="0"
"PwdChgDlg"="1"
"SchRstLng"="10000"
"UserDefFn"="0"
"DisableRetClause"="1"
"VCharNull"="1"
"TraceCategory"="0"
"TraceFileName"="c:\\OraOLEDB.trc"
"TraceLevel"="0"
"TraceOption"="0"
"SPPrmDefVal"="0"
"StmtCacheSize"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\OO4O]
"CacheBlocks"="20"
"FetchLimit"="100"
"FetchSize"="4096"
"HelpFile"="d:\\oracle\\product\\10.2.0\\db_1\\oo4o\\doc\\oracleo.hlp"
"PerBlock"="16"
"SliceSize"="256"
"TempFileDirectory"="c:\\temp"
"OO4O_HOME"="d:\\oracle\\product\\10.2.0\\db_1\\oo4o"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN][HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDBConsolermandb]
"EMDROOT"="d:\\oracle\\product\\10.2.0\\db_1"
"ORACLE_HOME"="d:\\oracle\\product\\10.2.0\\db_1"
"EMSTATE"="d:\\oracle\\product\\10.2.0\\db_1\\dragon_rmandb"
"CONSOLE_CFG"="dbconsole"
"ORACLE_SID"="rmandb"
"TIMEOUT"="15"
"TRACE_LEVEL"="16"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDBConsolestudy]
"EMDROOT"="d:\\oracle\\product\\10.2.0\\db_1"
"ORACLE_HOME"="d:\\oracle\\product\\10.2.0\\db_1"
"EMSTATE"="d:\\oracle\\product\\10.2.0\\db_1\\dragon_study"
"CONSOLE_CFG"="dbconsole"
"ORACLE_SID"="study"
"TIMEOUT"="15"
"TRACE_LEVEL"="16"

Answer 6

看我的这个，楼主copy到文本文件里（注意改动相关的文件路径），把文本文件的扩展名改成.reg, 双击导入即可

Answer 7

估计有好几个地方要改，sid之类的都要改成你自已的