其他

1、oracle不在dba組中。[root@localhost ~]# gpasswd -d oracle dbaRemoving user oracle from group dba[root@localhost ~]# su - oracle-bash: /etc/profile: line 61: syntax error: unexpected end of file[oracle@localhost ~]$ sqlplus / as sysdbaSQL*Plus: Release 10

SQL> SELECT   id FROM (SELECT  /*+ INDEX(si SIE_INVOICES_N3) */  si.id FROM binbin1 si,  2    binbin2 bs where si.id = bs.id and si.type ='AR_INVOICE' AND  3     si.import_failed_reason is null AND (si.imp_into_mis_flag is NULL OR si.imp_into_mis_

今天有一童鞋來問我delete是不是要commit，我也只知道個大概，所以順便就整理下。COMMIT對於commit，官方文檔《SQL Language Reference》解釋如下：PurposeUse the COMMIT statement to end your current transaction and makepermanent all changes performed in the transaction. A transaction is a sequence of

上午goldengate的R44XIB1 abbended了。GGSCI (YJPORTFRT001) 1> Program     Status     Group       Lag           Time Since Chkpt MANAGER     RUNNING                                          REPLICAT    ABENDED    R44XIB1     00:00:06     

今天看了一下alert log發現如下報錯：查看alert log：Fri Aug  2 07:13:33 2013Errors in file /u01/oracle/admin/eptdb/bdump/eptdb1_j002_962644.trc:ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], []Fri Aug  2 07:13:36 2013Errors in file

cd  /u01/oracle/product/10.2.0/network/admin[oracle@test admin]$ vi listener.ora SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = /u01/oracle/product/10.2.0)      (PROGRAM = extproc)    ))LISTENER = 

Applies to:Oracle GoldenGate - Version 10.0.0.1 and laterInformation in this document applies to any platform.Symptoms 1. I am using filter or where clause in extract parameter file and the column is not a part of primary or unique key2.Update and

下午檢查下備庫的alter log，一直報如下警告，該備庫是邏輯備庫。Mon Aug  5 16:29:17 2013WARNING: the following transaction makes no progressWARNING: in the last 30 seconds for the given message!WARNING: xid = 0x0003.025.0013b492 cscn = 9532709322703, message# = 11, slavid =

對RAC環境建立了DATA GUARD後，RAC環境的一個執行個體關閉後無法啟動，報錯資訊為：ORA-01105和ORA-1677。RAC環境的一個執行個體關閉後，在重啟時報錯如下：bash-2.03$ srvctl start inst -d testrac -i testrac2PRKP-1001 : Error starting instance testrac2 on node racnode2racnode2:ora.racnode2.vip:Created new logical

SELECT T.INSTOREITEMID, II.TEXTATTR12, T.binbin2ID FROM binbin1 T, binbin2 II WHERE II.TEXTATTR11 = '0' AND T.binbin2ID=II.binbin2ID ;no rows selectedElapsed: 00:04:14.28Execution Plan----------------------------------------------------------Plan

Applies to:Oracle GoldenGate - Version 10.0.0.1 and laterInformation in this document applies to any platform.Symptoms 1. I am using filter or where clause in extract parameter file and the column is not a part of primary or unique key2.Update and

SQL>   select * from ( select row_.*, rownum rownum_ from ( select i.itemname, i.ITEMDESC,      3   i.LOTNUM,     5   case when o.requestflag = 'Y' then '物資申領' else (select dd.dictionaryname from datadictionary dd  6     where

Applies to:Oracle Server - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.Symptoms- 11.2 Database with partitioned objects:select partitioned,count(*) from dba_tables group by

SQL> explain plan for SELECT SUM(OCCOUNT) as EVENTCOUNT , F_4 FROM binbin1 WHERE binbin1.EUIDCODE like '19739-19740-704013-%' or binbin1.EUIDCODE like '19739-19740-704018-%' or binbin1.EUIDCODE like '19339-19440-704274-%' AND STARTTIME>=1375237

The jobs used in this example:- Export job SCOTT.EXPDP_20051121 is a schema level export that is running- Export job SCOTT.SYS_EXPORT_TABLE_01 is an orphaned table level export job- Export job SCOTT.SYS_EXPORT_TABLE_02 is a table level export job

 recover database using backup controlfile  until

Issue:     Why does GoldenGate report the Lag is unknown?  The "Lag" command fails with "Timestamp Mismatch".  Sometimes the "Info All" will also show the Lag is unknown.How to troubleshoot the problem?Add a user token to a test table.e.g.,table

select * from (SELECT BH.LAST_UPDATE_DATE, BH.LAST_UPDATED_BY, BH.CREATION_DATE, BH.CREATED_BY, BH.LAST_UPDATE_LOGIN, BH.ENABLED_FLAG, BH.BOE_HEADER_ID,

節點二：[oracle@rac2 ~]$ crs_stat -tCRS-0184: Cannot communicate with the CRS daemon節點一：[root@rac1 ~]# crs_stat -tName           Type           Target    State     Host------------------------------------------------------------ora.DATA.dg   

環境：redhat 6.1+11.2.0.3RAC實驗：節點一sessions：SQL> select userenv('sid') from dual;USERENV('SID')--------------            62SQL> create table binbin(id number,name varchar2(20));Table created.SQL> insert into binbin values(1,'binbin');1 row