Oracle GoldenGate from Anar Godjaev

Redo Log Files Migration from Disk from Anar Godjaev

Asm disk group migration from from Anar Godjaev

oracle@anarexadatatest01:~$ export ORACLE_SID=ANARDEV1 oracle@anarexadatatest01:~$ echo $ORACLE_SID ANARDEV1 oracle@anarexadatatest01:~$ rman Recovery Manager: Release 11.2.0.3.0 – Production on Mon Jan 26 14:42:58 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connect target /; connected to target database: ANARDEV (DBID=247039367) RMAN> list backup of database; using target database control file instead of recovery […]

oracle@anarexadatatest:/$ rman Recovery Manager: Release 11.2.0.3.0 – Production on Mon Jan 26 14:38:44 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connect target /; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-12001: could not open channel default RMAN-10008: could not create channel context RMAN-10002: ORACLE error: […]

SELECT username, account_status, expiry_date FROM dba_users WHERE username = ‘DCS_APP’; ——————————————- USERNAME ACCOUNT_STATUS EXPIRY_DATE TEST EXPIRED 22-JAN-15 11:31:50 get the existing password SELECT DBMS_METADATA.get_ddl (‘USER’, ‘DCS_APP’) FROM DUAL; ——————————————- CREATE USER “DCS_APP” IDENTIFIED BY VALUES ‘S:79B1417837DCF0FBFACEFB10D7DBDC7B7EA63CC986036567BDCBA144B940;7A0F2B316C212D67’ DEFAULT TABLESPACE “USERS” TEMPORARY TABLESPACE “TEMP” PASSWORD EXPIRE and ALTER USER “DCS_APP” IDENTIFIED BY VALUES ‘S:79B1417837DCF0FBFACEFB10D7DBDC7B7EA63CC986036567BDCBA144B940;7A0F2B316C212D67’; chek status again […]

Alert log: Errors in file /u01/app/oracle/diag/rdbms/ANARDB/ANARDB/trace/ANARDB_j000_6201.trc: ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SQ_SQL_SW_45″ ORA-13605: The specified task or object SYS_AUTO_SQL_TUNING_TASK does not exist for the current user. ORA-06512: at “SYS.PRVT_ADVISOR”, line 2735 ORA-06512: at “SYS.DBMS_ADVISOR”, line 241 ORA-06512: at “SYS.DBMS_SQLTUNE”, line 821 Solution: bash-3.2$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.3.0 Production on Thu […]

bash-3.2$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 22 09:24:24 2015 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select name,open_mode from gv$database; NAME OPEN_MODE ——— ——————– […]

Error : Tue Jan 20 23:10:31 2015 Process 0x0x6e422dd28 appears to be hung in Auto SQL Tuning task Current time = 1421781030, process death time = 1421781001 Attempting to kill process 0x0x6e422dd28 with OS pid = 22795 OSD kill succeeded for process 0x6e422dd28 Solution: The explanation is that the AUTO SQL TUNING TASK has been […]

$ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate

$ORACLE_HOME/bin/emca -deconfig dbcontrol db

If we put into schema names to this command, we can deal with ORA-14047 error. This error raise when we put schema name in front of the last_table_name.  ALTER TABLE CLAML01.EPRPE2015 RENAME TO CLAML01.EPRPE; >>> RAISES ORA-14047 ERROR Solution: alter table hr.[prev_table_name] rename to [last_table_name] >> CORRECT ONE For example SQL> ALTER TABLE CLAML01.EPRPE2015 RENAME […]

When I have starting today EXEC DBMS_STATS.gather_index_stats I see problem in below SQL> EXEC DBMS_STATS.gather_index_stats(‘OC_PYM’, ‘IX_PYM_INV_INVOICE_01’); BEGIN DBMS_STATS.gather_index_stats(‘OC_PYM’, ‘IX_PYM_INV_INVOICE_01’); END; * ERROR at line 1 ORA-20000: index “OC_PYM”.”IX_PYM_INV_INVOICE_01″ or partition of such index is in unusable state ORA-06512: at “SYS.DBMS_STATS”, line 18361 ORA-06512: at “SYS.DBMS_STATS”, line 18402 ORA-06512: at line 1 The Solution You need […]

exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>’SYSMAN.MGMT_NOTIFY_QTABLE’,force=>TRUE); REM Drop the sysman account and management objects: SHUTDOWN IMMEDIATE; STARTUP RESTRICT; EXEC sysman.emd_maintenance.remove_em_dbms_jobs; EXEC sysman.setEMUserContext(”,5); REVOKE dba FROM sysman; DECLARE CURSOR c1 IS SELECT owner, synonym_name name FROM dba_synonyms WHERE table_owner = ‘SYSMAN’; BEGIN FOR r1 IN c1 LOOP IF r1.owner = ‘PUBLIC’ THEN EXECUTE IMMEDIATE ‘DROP PUBLIC SYNONYM ‘||r1.name; ELSE EXECUTE […]

One of the best parts about my job is working with Oracle ACES. They are loads of fun, interesting, and know so much more about Oracle technologies than I ever will. One of the worst parts is not having the time to give them the recognition they deserve. I won’t be able to remedy that […]

# cal -y { Displays current year 2015 Calendar }