Author Archives: anargodjaev

RMAN RECOVER TABLE Feature New to Oracle Database 12c (Point in Time TABLE RECOVERY Example)


% rman target sys/oracle@t12ccdb log recover_table5.log RMAN> RECOVER TABLE SMEDS.”RECTEST” OF PLUGGABLE DATABASE T12CPDB1 UNTIL SEQUENCE 64 thread 1 AUXILIARY DESTINATION ‘/testcases/rectbl’ REMAP TABLE ‘SMEDS’.’RECTEST’:’TEST4_RECTEST’; Starting recover at 21-JAN-13 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=16 device type=DISK RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time List of tablespaces expected to have UNDO […]

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr] on 11.2.0.4


Today when I started the DB , It refused to start with error ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]. Below is the workaround … [oracle@TEST ~]$ export ORACLE_SID=ANARDB [oracle@TEST ~]$ sqlplus Copyright (c) 1982, 2013, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System […]

Exadata cells memory checks


Oracle(R) Integrated Lights Out Manager Version 3.2.10.22.a r121452 Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved. Warning: HTTPS certificate is set to factory default. Hostname: exa1celadm01-ilom -> start /SP/console Are you sure you want to start /SP/console (y/n)? y Serial console started. To stop, type ESC ( exa1celadm01.kfsaz.local login: root Password: [root@exa1celadm01 ~]# […]

Exadata cell current temperature


Oracle(R) Integrated Lights Out Manager Version 3.2.10.22.a r121452 Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved. Warning: HTTPS certificate is set to factory default. Hostname: exa1celadm01-ilom -> start /SP/console Are you sure you want to start /SP/console (y/n)? y Serial console started. To stop, type ESC ( exa1celadm01.kfsaz.local login: root Password: [root@exa1celadm01 ~]# […]

Exadata cell CPU utilization


Oracle(R) Integrated Lights Out Manager Version 3.2.10.22.a r121452 Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved. Warning: HTTPS certificate is set to factory default. Hostname: exa1celadm01-ilom -> start /SP/console Are you sure you want to start /SP/console (y/n)? y Serial console started. To stop, type ESC ( exa1celadm01.kfsaz.local login: root Password: [root@exa1celadm01 ~]# […]

Exadata X4 change from X3


Exadata X4 change from X3

Exadata Storage Expansion Rack X4


Exadata Storage Expansion Rack X4

Exadata Storage Sever X4-2


Exadata Storage Sever X4-2

Exadata Database Machine X4-2


Exadata Database Machine X4-2

Exadata Storage Expansion Rack X3


Exadata Storage Expansion Rack X3

Exadata Storage Sever X3-2


Exadata Storage Sever X3-2

Exadata Storage Expansion Rack X2


Exadata Storage Expansion Rack X2

Exadata Storage Sever X2-2


Exadata Storage Sever X2-2

Exadata Database Machine X2-8


Exadata Database Machine X2-8

Exadata Database Machine X2-2


Exadata Database Machine X2-2

Pkg update Exadata


root@exadata02:~# cd /u01/staging/SOLARIS11.2/ root@exadata02:/u01/staging/SOLARIS11.2# ls -ltrh total 21828629 -rw-r–r– 1 root root 1.7G Aug 22 11:02 p19298012_1100_Solaris86-64_1of4.zip -rw-r–r– 1 root root 1.2G Aug 22 11:04 p21518848_1100_Solaris86-64_2of3.zip -rw-r–r– 1 root root 1.8G Aug 22 11:04 p19298012_1100_Solaris86-64_2of4.zip -rw-r–r– 1 root root 1.8G Aug 22 11:05 p19298012_1100_Solaris86-64_3of4.zip -rw-r–r– 1 root root 1.7G Aug 22 11:06 p19298012_1100_Solaris86-64_4of4.zip -rw-r–r– 1 […]

HOW to open database in restrict mode


bash-3.2$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 5 11:06:43 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 2.0583E+10 bytes Fixed Size 2168240 bytes Variable Size 5167385168 bytes Database Buffers 1.5368E+10 bytes Redo Buffers 45907968 […]

Uninstall XML Database: Oracle 11g


$ cd $ORACLE_HOME/rdbms/admin bash-4.1$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 25 09:20:00 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options […]

ORA-24248: XML DB extensible security not installed


bash-4.1$ cd $ORACLE_HOME/rdbms/admin bash-4.1$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 25 09:20:00 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options […]

CATPROC – Packages and Types Invalid in Dba_registry


Dba_registry shows ‘Packages and Types’ as invalid. How it can be validated. SQL> select comp_name, version, status from dba_registry; COMP_NAME VERSION STATUS —————————————- ———- ———- Oracle XML Database 10.2.0.1.0 VALID Oracle Database Catalog Views 10.2.0.1.0 VALID Oracle Database Packages and Types 10.2.0.1.0 INVALID JServer JAVA Virtual Machine 10.2.0.1.0 VALID Oracle XDK 10.2.0.1.0 VALID Oracle Database […]