I installed Oracle10g on windows2008. After a long time, I found that the normal method would not work. The current situation is that there is no installation package for 10.2.0.3 for vista. This package can be directly installed on windows2008, and Oracle11g cannot be directly installed. Confirm that the windows version of oracle 10.2.0.4 can run on windows. So, can I port it directly, similar to green installation.
After a simple thought, I thought it should be feasible. on linux, I often do this, and windows won't work.
Step 1: create users and groups
In windows, the user uses the administrator, and the oracle group needs to be created. The name must be ora_dba and the administrator belongs to the ora_dba group.
Step 2: Set environment variables and copy the software directories installed in oracle
Set PATH = D: \ oracle \ product \ 10.2.0 \ db_1 \ bin; % PATH %
Set ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1
Set ORACLE_SID = mikidb
Copy the installed folder on windows2003 to the ORACLE_HOME directory.
Step 3: Create a windows Service and configure the Registry
Create a windows Service manually as follows:
Oradim-new-sid mikidb-startmode auto-pfile d: \ oracle \ product \ 10.2.0 \ db_1 \ database \ INITmikidb. ORA
Although the windows service is successfully created, it cannot be recovered. An error is reported that the system cannot find the file.
Stop and think about the registry information required by all software on windows. This is no exception.
Configure the registry according to the registry information of the oracle software on the windows 2003 Registry. As follows:
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_BASE" = "d :\\ oracle \ product \ 10.2.0"
"ORACLE_BUNDLE_NAME" = "Enterprise"
"ORACLE_GROUP_NAME" = "Oracle-OraDb10g_home1"
"ORACLE_HOME" = "d :\\ oracle \ product \ 10.2.0 \ db_1"
"ORACLE_HOME_KEY" = "SOFTWARE \ ORACLE \ KEY_OraDb10g_home1"
"ORACLE_HOME_NAME" = "OraDb10g_home1"
"ORACLE_SID" = "mikidb"
"ORA_mikidb_AUTOSTART" = hex (2): 54,00, 52,00, 55,00, 45,00, 00,00
"ORA_mikidb_SHUTDOWN" = hex (2): 54,00, 52,00, 55,00, 45,00, 00,00
"ORA_mikidb_SHUTDOWNTYPE" = hex (2): 69,00, 6d, 00, 6d, 00 ,\
"ORA_mikidb_SHUTDOWN_TIMEOUT" = hex (2): 39,00, 30,00, 00,00
"NLS_LANG" = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
Use the oradim tool to delete the service and manually recreate it.
D: \ oracle \ product \ 10.2.0 \ db_1 \ database> SC delete OracleServicemikidb
[SC] DeleteService successful
D: \ oracle \ product \ 10.2.0 \ db_1 \ database> oradim-new-sid mikidb-startmode auto
-Pfile d: \ oracle \ product \ 10.2.0 \ db_1 \ database \ INITmikidb. ORA
Instance created.