oracle oms可以调用吗,oracle oms

之前因为考试的原因，希望能在本机的windows上安装 Oracle OMS 以方便练习，OCM考试中使用的Grid Control 版本为10.2.0.1, 仅支持Windows相关系统号5,对于6或6.1的vista/2008/7安装过程中都会遇到问题无法解决，最为明显的是10.2.0.1自带数据库为10.1.0.4版本在windows相关版本号6以上的平台中均无法创建数据库。Oracle OCM考试中会要求你使用DBCA 建立一个干净的Customer定制数据库，仅需要建立必要的试图和过程(catalog.sql与catproc.sql运行过)并带有label security 组件(其他如Spatial与OLAP组建包括Oracle JVM等均不需要)，如图：

Oracle Grid Control 的10.2.0.5版本已经发布，其中10.2.0.4版本已支持最新的Windows操作系统，但只有patch install版本而无直接安装的full install 版本，且直接安装10.2.0.1 版本在OMS configuration部分将出错导致配置失败故我们需要另一种安装方式，如文档 ID:     763072.1

Installing On Windows 2008/Vista

The following sections discuss installing Enterprise Manager 10g Grid Control on Windows 2008/Vista.

oracle监听程序不支持服务。Installing Enterprise Manager 10g Grid Control Using A New Database On Windows 2008/Vista

Enterprise Manager 10g Grid Control will not support the New Database install option on Windows 2008/Vista as the Database 10.1.0.4 (which is the default Database for Grid Control) is not supported for Windows 2008/Vista.

Installing Enterprise Manager 10g Grid Control Using an Existing Database On Windows 2008/Vista

To install Enterprise Manager 10g Grid Control using an existing database on Windows 2008/Vista, follow these steps:

Download the fixed OUI 10204 from ARU Microsoft Windows (32-bit) (Bug 6640752) and extract it to a designated location, for example, C:OUI_Shiphome

oracle调用函数结果。Copy Enterprise Manager 10g Grid Control 10.2.0.2.0 base shiphome (Disk1) into a location, for example, C:EMGC_102020shiphome

Install the database that supports Vista/2008, such as 10.2.0.3.0/10.2.0.4. Make the following changes in the response file:

C:EMGC_Shiphome102020shiphomeDisk1installresponseemnoseed.rsp

Give the absolute path of products.xml for the FROM_LOCATION parameter.

FROM_LOCATION="C:EMGC_102020shiphomeDisk1/oms/Disk1/stage/products.xml"

oracle数据库存储过程调用、Give the OMS Oracle Home location. For example:

ORACLE_HOME=c:emnoseedoms10g

Give the Oracle Home name. For example:

ORACLE_HOME_NAME=oms10g12

Give the Agent Oracle Home location. For example:

oracle创建监听。s_agentHome=c:emnoseedagent10g

Give the Agent Home Name. For example:

s_agentHomeName=agent10g12

Note:

Ensure that the Oracle Home location and name are not identical to any previous Homes.

csh调用oracle存储过程？Invoke the setup.exe for Install in the following way:

C:OUI_ShiphomecdDisk1installsetup.exe -ignoreDiskLabel -responseFile C:EMGC_102020shiphomeDisk1installresponseemnoseed.rsp

If the Agent is not coming up, and if the value of agentTZRegion in emd.properties is GMT then do the following:

Reset TimeZone on Agent box to GMT.

Execute the following command in BIN>emctl resetTZ agent

oracle 分页？Patch OMS and Agent to version 10.2.0.5.

Installing An Additional Management Service On Windows 2008/Vista

Follow the below instructions to install an additional Management Service on Windows 2008/Vista.

Download the fixed OUI 10204 from ARU Microsoft Windows (32-bit) (Bug 6640752) and extract it to a designated location, for example, C:OUI_Shiphome

Copy Enterprise Manager 10g Grid Control 10.2.0.2.0 base shiphome (Disk1) into a location, for example, C:EMGC_102020shiphome

oracle rownum、Make the following changes in the response file:

C:EMGC_102020shiphomeDisk1installresponseoms.rsp

Supply the absolute path of products.xml for FROM_LOCATION parameter.

FROM_LOCATION="C:EMGC_102020shiphome/Disk1/oms/Disk1/stage/products.xml"

Supply the OMS Oracle Home location. For example: ORACLE_HOME=C:OH102020oms10g

Specify the Oracle Home name. For example, ORACLE_HOME_NAME=oms10g20

Supply the Agent Oracle Home location. For example, s_agentHome=C:OH102020agent10g

Supply the Agent Home Name. For example, s_agentHomeName=agent10g20

Note:

Ensure that the Oracle Home location and name not be the same as any previous homes.

Invoke the setup.exe for Install in the following way:

C:OUI_ShiphomecdDisk1installsetup.exe -ignoreDiskLabel -responseFile

C:EMGC_102020shiphomeDisk1installresponseoms.rsp

If the Agent does not come up, and if the value of agentTZRegion in emd.properties is GMT, then do the following:

Reset TimeZone on the Agent installation box to GMT

Execute the following command in BIN>emctl resetTZ agent

Patch OMS and Agent to version 10.2.0.5.

Installing An Additional Management Agent On Windows 2008/Vista

Follow the below instructions to install an additional Management Agent on Windows 2008/Vista.

Download the fixed OUI 10204 from ARU Microsoft Windows (32-bit) (Bug 6640752) and extract it to a designated location, for example, C:OUI_Shiphome

Copy Enterprise Manager 10g Grid Control 10.2.0.2.0 base shiphome (Disk1) into a location, for example, C:EMGC_102020shiphome

Make the following changes in the response file:

C:EMGC_102020shiphomeDisk1installresponseagent.rsp

Supply the absolute path of products.xml for FROM_LOCATION parameter.

FROM_LOCATION="C:EMGC_102020shiphomeDisk1/oms/Disk1/stage/products.xml"

Supply the OMS Oracle Home location. For example, ORACLE_HOME=c:agtagent10g

Supply the Oracle Home name. For example, ORACLE_HOME_NAME=agent10g13

Note:

Ensure that Oracle Home location and name are not the same as any previous homes.

Invoke the setup.exe for Install in the following way:

C:OUI_ShiphomecdDisk1installsetup.exe -ignoreDiskLabel -responseFile

C:EMGC_102020shiphomeDisk1installresponseagent.rsp

If the Agent is not coming up, and if the value of agentTZRegion in emd.properties is GMT then do the following:

Reset TimeZone on the Agent installation box to GMT.

Execute the following command in BIN>emctl resetTZ agent

Patch Agent to version 10.2.0.5.