ITPub博客

 1. access oem to get the url for softwareEnter [Setup]-->[Extensibility]-->[Self Update]Enter Type[Agent Software] and select the version and click [Action]-->[Export], get the command line like below"emcli export_update -id=99161547BBDF9C653CF7400EBE4B23C5 -omslocal -dir="...

obiee11g

[grid@jptkydbrac011lnx ~]$ srvctl status database -d uhkcInstance uhkc1 is running on node jptkydbrac011lnxInstance uhkc2 is not running on node jptkydbrac012lnx[grid@jptkydbrac011lnx ~]$ srvctl config database -d uhkcDatabase unique name: uhkcDatabase name: uhkcOracle home: /apps/oracle/prod...

http://appsdbaworkshop.blogspot.jp/2011/11/manage-startupshutdownstatus-services.htmlAll these commands are demonstrated on a 4 node cluster running on OEL 5.6. How to check the status of CRS on specific node: [ora11g@racnode1 ~]$ crsctl check crsCRS-4638: Oracle High Availability Services i...

Standby database

物理standby database的日常维护                分类：            oracle相关 2012-12-06 22:25695人阅读评论(0)收藏举报1.停止Standbyselect process, s...

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=169781064884617&id=958557.1&_afrWindowMode=0&_adf.ctrl-state=mnmggr81a_4How To Recover From A Drop/Truncate/Delete Table Done On Primary Using Flashback On A Standby Database (Doc ID 958557.1)Applies to:Oracle Server - Enterpris...

In this DocumentSymptomsCauseSolutionReferencesApplies to: Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]Information in this document applies to any plat...

@$ORACLE_HOME/rdbms/admin/ashrpt.sql v$sessionv$active_session_historydba_hist_active_sess_historyselect * from dba_hist_active_sess_history a where a.session_id=266 and a...

v$segment_statistics SQL> desc v$segment_statistics; Name                    &nbsp...

http://www.oracledistilled.com/oracle-database/high-availability/data-guard/changing-the-data-guard-protection-mode/ Changing the Data Guard Protection Mode  Oracle Data Guard provid...

SQL> select PRIVILEGE from dba_sys_privs where GRANTEE='SCOTT';PRIVILEGE----------------------------------------UNLIMITED TABLESPACESQL> select TABLE_NAME,PRIVILEGE from dba_tab_privs where GRANTEE=...

 SQL> conn scott/tiggerConnected.SQL>SQL>SQL> select distinct sid from v$mystat;       SID----------        28SQL> create table...

http://www.oracle-class.com/?p=2409 1- AWR Concept:In this post, I am going to show you how to generate AWR reports for Real Application Clusters (RAC) environment.AWR was first introduce...

1. Change primary database to force logging modealter database force logging;2. Create standby controlalter database create standby controlfile as '/tmp/control.ctl';3. Primary database parameter file...

./emctl stop agent./emctl start agent./emctl unsecure agent./agentca -f./agentca -p  ./agentca -help After database not connected issue, oem unable to check database stat...

 Oracle Recommended Patches — Oracle Database [ID 756671.1]    文档中查到各个产品版本最新的PSU。 你也可以 找到最新的PSU通过tab[Patches & Updat...

转载： http://oracleappstechnology.blogspot.jp/2007/10/difference-between-utf8-and-al32utf8.html Difference between UTF8 and AL32UTF8UTF8 and AL32UTF8 are encodings of the Unicode charact...

转： http://gavinsoorma.com/2009/06/11g-active-standby/11g ACTIVE STANDBYActive Standby :PRIMARY DB- APEXSTANDBY DB- APEXDGNow you can bring up the standby database in read-only mode a...

1. 下载xming, 并安装http://sourceforge.net/projects/xming/files/latest/download 2．首先打開 XLaunch按完結束後 Xming 會啟動在右下角3．開啟後畫面如下，可以不改任何設定一直按下一步到底 ...