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.