Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

21

积分

0

好友

0

主题
1#
发表于 2012-4-23 11:56:00 | 查看: 8165| 回复: 4
$OMS_HOME/bin/emctl start omsOracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0  Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.Starting WebTier...WebTier Successfully StartedStarting Oracle Management Server...Oracle Management Server Successfully StartedOracle Management Server is Down

logs.rar

245.27 KB, 下载次数: 933

2#
发表于 2012-4-23 18:38:29
<Apr 20, 2012 4:24:05 PM CST> <Error> <Deployer> <BEA-149205> <Failed to initialize the application 'wsm-pm' due to error weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection.
weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection



你确认OMS 可以连接到 EM Repository数据库吗? 就报错信息看 “The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection”  是无法建立数据库链接

回复 只看该作者 道具 举报

3#
发表于 2012-4-23 20:35:41

回复 2# 的帖子

所以我有其中一个想法就是会不会是因为我数据库有问题导致出错.
而且我还想问一下有没有彻底删除OEM和ORACLE数据库的详细方法?
因为我也是刚接触这两款产品又没有培训过.所以不是太懂.

回复 只看该作者 道具 举报

4#
发表于 2012-4-23 20:43:06
删除 OMS Cloud Control 12.1 可以参考 以下Note:

How To De-Install EM 12c Cloud Control

Applies to:
Enterprise Manager Base Platform - Version 12.1.0.1.0 to 12.1.0.1.0 [Release 12.1]
Information in this document applies to any platform.
Purpose

This document describes in detail the steps for deinstalling Oracle Enterprise Manager Cloud Control 12c.
It includes the following:

    Prerequisites
    Dinstalation Steps
    Post Deinstallation Steps

Scope

This document describes in detail the Steps for Deinstalling Oracle Enterprise Manager Cloud Control 12c and Oracle Management Agent (Management Agent) 12c using a Graphical and Silent methods. You can also refer to the Advanced Installation guide on OTN from the following link:
http://docs.oracle.com/cd/E24628_01/index.htm
Advanced Installation and Configuration Guide
Chapter 16 - Deinstalling Enterprise Manager Cloud Control
Details
Prerequisites
Before you deinstall Enterprise Manager Cloud Control, follow these steps:

1. Delete Oracle Management Service (OMS) by running the following command from the OMS home.

Deconfigure and remove the OMS:
<OMS_HOME>/bin/omsca delete -full

Note: Ensure that the repository database and listener are up and running while running the above omsca command. Also when prompted for the inputs, provide 'Y' (in capital letters) for the command to be executed.
2. Shut down Oracle Management Agent (Management Agent) by running the following command from the Management Agent home:
<AGENT_HOME>/bin/emctl stop agent

3. If you want to deinstall the entire Enterprise Manager system, including Oracle Management Repository (Management Repository) that is configured in your database, then follow these steps:

a. Ensure that there are no SYSMAN users logged in.

b. Drop the Enterprise Manager Cloud Control schema (SYSMAN schema) and the Metadata schema (MDS schema) from the Management Repository by running the following command from the OMS home:
<OMS_HOME>/sysman/admin/emdrep/bin/RepManager <database_host> <repository_database_port> <repository_database_sid> -action dropall -dbUser <repository_database_user> -dbPassword <repository_database_password> -dbRole <repository_database_user_role> -reposName <repository_name> -reposPassword <repository_password> -mwHome <middleware_home> -mwOraHome <middleware_ora_home> -oracleHome <OMS_HOME>




Note: For Microsoft Windows, invoke RepManager.bat.

Manually delete the data files mgmt.dbf and mgmt_ecm_depot1.dbf from the database home.

Refer the following note to drop the Repository:
Note 1365820.1 - Repmanager Dropall Command Fails To Drop all the Repository Objects

4. Uninstall the Weblogic server by logging Middleware/utils/uninstall:
./uninstall.sh

Deinstallation Steps
This describes the following methods:

    Deinstalling in Graphical Method
    Deinstalling in Silent Method

Deinstalling in Graphical Method
To deinstall Enterprise Manager Cloud Control in graphical mode, follow these steps:

1. Invoke the installer from the OMS home by running the following command:
$<OMS_HOME>/oui/bin/runInstaller -deinstall -removeallfiles




2. In the installation wizard, inventory section select all the components apart from jdk1, oms12c1, agent12c1, common12c1.




3. On the Inventory screen, select the plug-in homes, and click Remove.

4. On the Inventory screen, select the sbin home, and click Remove.

5. On the Inventory screen, select the Java Development Kit (JDK) home, oms12c1, agent12c1 and common12c1, and click Remove.


6. On the Inventory screen, click Cancel.

7. On the My Oracle Support Details screen, click Exit to exit the installation wizard.

Known Issues:

1. If you try to remove oms or agent without removing the others, it prompts that respective plugins needs to be dropped before dropping oms & agent.


The home /home/oracle/Middleware/oms cannot be deinstalled. Please deinstall all referenced home(s) /home/oracle/Middleware/jdk16 before deinstalling selected home.

plugin1

The home /DATA/Middleware/agent/core/12.1.0.0.0 cannot be deinstalled. Please deinstall all referenced homes(s) .. It lists all the plugins.

plugin2

The home /home/oracle/Middleware/oms cannot be deinstalled. Please deinstall all referenced home(s) .. It lists all the plugins.

2. Similarly we cannot delete the oracle_common before deleting the Oracle_WT:

oracle_common
The home /DATA/Middleware/oracle_common cannot be deinstalled. Please deinstall all referenced home(s) /DATA/Middleware/Oracle_WT before deinstalling selected home.

3. Also we need to remove the sbin before deinstalling the agent:

sbin
The home /home/oracle/Middleware/agent/core/12.1.0.1.0 cannot be deinstalled. Please deinstall all referenced home(s)
/home/oracle/Middleware/agent/sbin before deinstalling selected home.

4. We should not remove JDK before uninstalling weblogic server, as JDK is mandatory to uninstall WLS.
Deinstalling in Silent Method
To deinstall Enterprise Manager Cloud Control in silent mode, follow the steps:

1. Deinstall the plug-in homes:
$<OMS_HOME>/oui/bin/runInstaller -silent -deinstall -removeallfiles "REMOVE_HOMES={absolute_path_to_plug-in_home}" -invPtrLoc <absolute_path_to_oraInst.loc>

2. Deinstall the sbin home:
$<OMS_HOME>/oui/bin/runInstaller -silent -deinstall -removeallfiles "REMOVE_HOMES={absolute_path_to_sbin_directory}" -invPtrLoc <absolute_path_to_oraInst.loc>

3. Uninstall the Weblogic Server by logging in Middleware/utils/uninstall:
./uninstall.sh
4. Deinstall the Java Development Kit (JDK) home.

5. Deinstall the Oracle WebTier home:
$<OMS_HOME>/oui/bin/runInstaller -silent -deinstall -removeallfiles "REMOVE_HOMES={absolute_path_to_web_tier}" -invPtrLoc <absolute_path_to_oraInst.loc>

6. Deinstall the OMS, the Management Agent, and the Oracle Common directory:
$<OMS_HOME>/oui/bin/runInstaller -silent -deinstall -removeallfiles "REMOVE_HOMES={absolute_path_to_oracle_homes_and_directories_to_be_deinstalled}" -invPtrLoc <absolute_path_to_oraInst.loc>

Note: The argument REMOVE_HOMES accepts more than one path separated by a comma.



Post Deinstallation Steps
The Oracle homes you deinstalled are deregistered from the central inventory. However, some files might still remain in these Oracle homes. You might also see the OMS instance base directory and the Oracle home for Web Tier. You can manually delete these files and directories.

You must also manually delete the auto-start script titled S98gcstartup. To do so, navigate to the /etc/rc.d/ directory, and search for the auto-start script S98gcstartup. This script is usually present in a subdirectory within the /etc/rc.d/ directory. Navigate to the subdirectory where the script is found and delete the script.
For example, /etc/rc.d/rc3.d/S98gcstartup

回复 只看该作者 道具 举报

5#
发表于 2012-4-23 23:08:37

回复 4# 的帖子

非常感谢你的帮忙.我明天先去试试.

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 14:59 , Processed in 0.053527 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569