Monthly Archives: January 2015

Rman backup list


SET LINES 110 SET PAGES 20 COLUMN “Start Data” FOR a20 COLUMN “End Date” FOR a20 COLUMN “Time Minute” FORMAT a15 COLUMN status FORMAT a11 COLUMN input_bytes_display FORMAT a10 COLUMN output_bytes_display FORMAT a10 TITLE CENTER RMAN_Backup_List_REPORT SKIP 2 SELECT TO_CHAR (start_time, ‘YYYY.MM.DD HH24:MI:SS’) “Start Data”, TO_CHAR (end_time, ‘YYYY.MM.DD HH24:MI:SS’) “End Date”, TO_CHAR (ROUND ( (end_time […]

Oracle GoldenGate


Oracle GoldenGate from Anar Godjaev

Redo Log files Migration from disk “+DATA01” to “+DATA02”


Redo Log Files Migration from Disk from Anar Godjaev

ASM DiskGroup Migration from “+DATA01” to “+DATA02”


Asm disk group migration from from Anar Godjaev

RMAN-03009: failure of Control File and SPFILE Autobackup command on


oracle@bakuexa1dbadm01:~$ export ORACLE_SID=MISDEV1 oracle@bakuexa1dbadm01:~$ echo $ORACLE_SID MISDEV1 oracle@bakuexa1dbadm01:~$ 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: MISDEV (DBID=247039367) RMAN> list backup of database; using target database control file instead of recovery […]

RMAN-10002: ORACLE error: ORA-15021: parameter “remote_dependencies_mode” is not valid in asm instance


oracle@bakuexa1dbadm01:/$ 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: […]

Re-open expired oracle database account without change password


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 […]

ORA-13605: The specified task or object SYS_AUTO_SQL_TUNING_TASK does not exist for the current user.


Alert log: Errors in file /u01/app/oracle/diag/rdbms/azkktst/AZKKTST/trace/AZKKTST_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 […]

ORA-19752: block change tracking is already enabled


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 ——— ——————– […]

Process appears to be hung in Auto SQL Tuning task


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 […]

How to RE-CREATE DBConsole using EMCA? (files and repository using a single command)


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

How to DROP DBConsole configuration files using EMCA (leave repository intact) ?


$ORACLE_HOME/bin/emca -deconfig dbcontrol db

ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations


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 […]

ORA-20000: index “OC_PYM”.”IX_PYM_INV_INVOICE_01″ or partition of such index is in unusable state


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 […]

How to manually remove dbconsole repository


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 […]

Most Active Systems ACES of 2014


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 […]

displays a simple calendar


# cal -y { Displays current year 2015 Calendar }

Move a partitioned table from one tablespace to another tablespaces


select ‘ALTER TABLE ‘||TABLE_OWNER ||’.’||table_name||’ MOVE PARTITION ‘||partition_name||’ TABLESPACE tbs_NEW PARALLEL(DEGREE 4) NOLOGGING;’ from dba_tab_partitions where TABLESPACE_NAME = ‘tablespace_old’;