2013年3月7日 星期四

Oracle Database - 移除Oracle Management Agent in Silent Mode



  • Deinstalling Oracle Management Agent in Silent Mode


/u01/oracle/agent11g/oui/bin/runInstaller -silent -deinstall "REMOVE_HOMES={/u01/oracle/agent11g}" -removeallfiles


/u01/oracle/agent11g/bin/emctl pingOMS



emctl upload agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet. If this issue persists check trace files for ping to OMS related errors.


Solution
1. Stop the agent:
<AGENT_HOME>/BIN> emctl stop agent

2. Secure the agent which will generate a new key:
<AGENT_HOME>/BIN> emctl secure agent

3.  Start the agent:
<AGENT_HOME>/BIN> emctl start agent

4. Login to the grid console >> Setup >> Agents >> Navigate to the problematic agent home page >> Click on Agent resynchronization

5. Once the Agent resynchronization works fine,  perform an upload agent:
<AGENT_HOME>/BIN> ./emctl upload

2013年3月6日 星期三

Oracle Database - 用export backup 特定table/tablespaces



--Backup 特定table

exp system/xxxxxxxx tables=simctl.F0092,simctl.F9000,simctl.F9001,simctl.F9002,simctl.F9005,simctl.F9005D,simctl.F9006,simctl.F9006D file=simctl_menu.exp log=exp_simctl_menu.log

--Backup 特定tablespaces
day=`date +%Y-%m-%d`
exp system/xxxxxxxx tablespaces=DEV_MDS,DEV_IAS_TEMP,DEV_BIPLATFORM,BIEE_BIPLATFORM,BIEE_MDS,BIEE_IAS_TEMP,BIEE_ODI_TEMP,BIEE_ODI_USER file=biee_$day.exp log=exp_biee_$day.log