Install Oracle 10g and 11g in Windows XP SP2.

1           Firstly, I try to install oracle 11g in Windows XP SP2. Although I setup the loopback adaptor correctly in step #4, the em can’t be configured and started successfully. I tried the command in step #2 and #3 so many times after installation, but it failed finally. At last I resorted to installing oracle 10g in my windows from step #4.

 

2           Oracle 支持在具有 DHCP 分配的 IP 地址的系统上进行安装

 

The check result from Oracle installer is like this,

 

    2007-11-23 10:35检查完成。此次检查的总体结果为: 未执行 <<<<

建议案: Oracle 支持在具有 DHCP 分配的 IP 地址的系统上进行安装。但在安装之前, 必须将 Microsoft LoopBack Adapter 配置为系统的主网络适配器。有关在配置有 DHCP 的系统上安装软件的详细信息, 请参阅 Installation Guide。

 

解决：

 

到控制面板/添加硬件，在向导中选择“是，已经连接了此硬件”→“网络适配器”→“Microsoft Loopback Adapter”，添加完成，你会发现新建了个“本地连接”，用的就是这个假的“Microsoft Loopback Adapter”（因为根本就没有连接这个硬件，只是骗下Oracle而已）。把这个本地连接的IP设置一下（例如10.10.10.1）。好了，现在回 去重新让Oracle检测一遍吧，应该通过了吧。

 

常用的命令：

 

创建一个EM资料库

emca -repos create

重建一个EM资料库

emca -repos recreate

删除一个EM资料库

emca -repos drop

配置数据库的 Database Control

emca -config dbcontrol db

删除数据库的 Database Control配置

emca -deconfig dbcontrol db

重新配置db control的端口，默认端口在1158

emca -reconfig ports

emca -reconfig ports -dbcontrol_http_port 1160

emca -reconfig ports -agent_port 3940

先设置ORACLE_SID环境变量后,启动EM console服务

emctl start dbconsole

先设置ORACLE_SID环境变量后,停止EM console服务

emctl stop dbconsole

先设置ORACLE_SID环境变量后,查看EM console服务的状态

emctl status dbconsole

 

配置dbconsole的步骤

emca -repos create

emca -config dbcontrol db

emctl start dbconsole

重新配置dbconsole的步骤

emca -repos drop

emca -repos create

emca -config dbcontrol db

emctl start dbconsole

 

3           If the em console service can not be started normally, please try to recreate the EM console,

3.1          emctl status dbconsole

3.2          emca -repos drop emca -repos create emca -config dbcontrol db emctl start dbconsole

3.3          emctl stop dbconsole emctl start dbconsole

 

4           How to install the oracle 10g in XP?

4.1          Install DHCP.

4.1.1     From the Start menu, select Control Panel .

4.1.2     Double-click Add Hardware to start the Add Hardware wizard.

4.1.3     On the Welcome screen, click Next .

4.1.4     On the Is the hardware connected? screen, select Yes, I have already connected the hardware , and click Next .

4.1.5     On the The following hardware is already installed on your computer screen, select Add a new hardware device , and click Next .

4.1.6     On the The wizard can help you install other hardware screen, select Install the hardware that I manually select from a list , and click Next .

4.1.7     From the list, select the type of hardware you are installing screen, select Network adapters , and click Next .

4.1.8     On the Select Network Adapter screen, make the following selections:

4.1.8.1    Manufacturer : select Microsoft .

4.1.8.2    Network Adapter : select Microsoft Loopback Adapter .

4.1.9     Click Next .

4.1.10 On the The wizard is ready to install your hardware screen, click Next .

4.1.11 On the Completing the Add Hardware Wizard screen, click Finish .

4.1.12 If you are using Windows 2003, restart your computer.

4.1.13 Right-click My Network Places on the desktop and choose Properties . This displays the Network Connections control panel.

4.1.14 Right-click the connection that was just created. This is usually named Local Area Connection 2. Choose Properties .

4.1.15 On the General tab, select Internet Protocol (TCP/IP) , and click Properties

4.1.16 In the Properties dialog, do the following:

4.1.16.1    IP Address: Enter a non-routable IP for the loopback adapter. Oracle recommends the following non-routable addresses - 10.10.10.1

4.1.16.2       2.Subnet mask: Enter 255.255.255.0.

4.1.16.3       3.Leave all other fields empty.

4.1.16.4       4.Click OK.

4.1.17 Click OK.

4.1.18 Click OK in the Local Area Connection 2 Properties dialog.

4.1.19 Restart the computer.

4.2          Edit file C:\WINDOWS\system32\drivers\etc\host as,

4.2.1     10.10.10.1      robert-cn.cn.oracle.com     robert-cn

4.2.2     127.0.0.1       localhost

4.3          Open System Properties, and select the Computer Name tab. In Full computer name, make sure you see the hostname is robert-cn.cn.oracle.com which is the same one with previous step. The short name should be robert-cn when you click the change button.

4.4          Then install the oracle.

4.5          The console url is https://localhost:1158/em/console/aboutApplication you can get the page by command emctl status dbconsole .

 

5           At this time if you access the em console, you can login correctly. But when you view some information, it blows up with some exception like this. java.lang.Exception: Exception in sending Request :: null

5.1          Open the file db_1/sysman/admin/supportedtzs.lst .

5.2          Find the time zone of your OS or the one one hour later than your OS time zone. For example, my OS’s Timezone is (GMT+08:00)Beijing, ChongQing, HongKong, Wulumuqi, so I need to try these with GMT+08:00 or GMT+07:00

5.3          Put their name in file db_1/HOSTNAME_orcl/sysman/config/emd.properties like this.

agentTZRegion=Asia/Shanghai or agentTZRegion= Asia/Jakarta

5.4          Then try these commands.

emctl stop dbconsole

emctl resetTZ agent

emctl start console

5.5          Please refer to them.

              http://read.newbooks.com.cn/info/115091.html

http://forums.oracle.com/forums/thread.jspa?threadID=334048&start=0&tstart=0

http://www.itpub.net/750634,3.html

 

6           Now you can access the em console normally.