Oracle 11gR2

/Tag: Oracle 11gR2

Oracle Error Troubleshooting (11g r2 tested) – part 08

By |2017-07-07T19:45:08+00:00abril 29th, 2017|Categories: DBA, Oracle, Oracle Troubleshooting|Tags: , , |

Continuamos con la seria de posts sobre: Oracle  Error Troubleshooting, y como solucionarlos: Posts Relacionados 01 – https://itegram.com/2017/01/16/oracle-troubleshooting-11g-r2-tested-part-01/ 02 – https://itegram.com/2017/01/30/oracle-troubleshooting-11g-r2-tested-part-02/ 03 – https://itegram.com/2017/01/30/oracle-troubleshooting-11g-r2-tested-part-03/ 04 –  http://itegram.com/2017/03/10/oracle-troubleshooting-11g-r2-tested-part-04/ 05 – http://itegram.com/2017/04/27/oracle-error-troubleshooting-11g-r2-tested-part-05/ 06 – http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-06/ 07 –  http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-07/ Y links a diversos posts sobre Oracle: https://itegram.wordpress.com/2017/01/13/indice-posts-sobre-oracle/ Errores encontrados en este documento rman: can’t open target ora-01033:oracle initialization or shutdown in progress ORA-00376, ORA-01110, [...]

Oracle Error Troubleshooting (11g r2 tested) – part 07

By |2017-11-15T14:55:14+00:00abril 29th, 2017|Categories: DBA, Oracle, Oracle Troubleshooting|Tags: , , |

Continuamos con la seria de posts sobre: Oracle  Error Troubleshooting, y como solucionarlos: Otras partes 01 – https://itegram.com/2017/01/16/oracle-troubleshooting-11g-r2-tested-part-01/ 02 – https://itegram.com/2017/01/30/oracle-troubleshooting-11g-r2-tested-part-02/ 03 – https://itegram.com/2017/01/30/oracle-troubleshooting-11g-r2-tested-part-03/ 04 – http://itegram.com/2017/03/10/oracle-troubleshooting-11g-r2-tested-part-04/ 05 – http://itegram.com/2017/04/27/oracle-error-troubleshooting-11g-r2-tested-part-05/ 06 – http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-06/ 08 – http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-08/ Y links a diversos posts sobre Oracle: https://itegram.com/2017/01/13/indice-posts-sobre-oracle/ Errores encontrados en este post Formato de archivelog en FRA ORA-31693 / [...]

Oracle Error Troubleshooting (11g r2 tested) – part 06

By |2017-04-30T00:29:50+00:00abril 29th, 2017|Categories: DBA, Oracle Troubleshooting|Tags: , |

Continuamos con la seria de posts: Oracle Error  Troubleshooting , y como solucionarlos: 01 – https://itegram.com/2017/01/16/oracle-troubleshooting-11g-r2-tested-part-01/ 02 – https://itegram.com/2017/01/30/oracle-troubleshooting-11g-r2-tested-part-02/ 03 – https://itegram.com/2017/01/30/oracle-troubleshooting-11g-r2-tested-part-03/ 04 – http://itegram.com/2017/03/10/oracle-troubleshooting-11g-r2-tested-part-04/ 05 – http://itegram.com/2017/04/27/oracle-error-troubleshooting-11g-r2-tested-part-05/ 07 – http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-07/ 08 – http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-08/ Otros posts sobre Oracle: https://itegram.com/2017/01/13/indice-posts-sobre-oracle/ Errores encontrados en este post RMAN-06023: no backup or copy of datafile 4 found to restore ORA-01203 – [...]

Oracle Error Troubleshooting (11g r2 tested) – part 05

By |2017-05-03T23:32:35+00:00abril 27th, 2017|Categories: DBA, Oracle Troubleshooting|Tags: , |

Continuamos con la seria de posts sobre: Oracle  Error Troubleshooting, y como solucionarlos: Otras partes 01 – https://itegram.com/2017/01/16/oracle-troubleshooting-11g-r2-tested-part-01/ 02 – https://itegram.com/2017/01/30/oracle-troubleshooting-11g-r2-tested-part-02/ 03 – https://itegram.com/2017/01/30/oracle-troubleshooting-11g-r2-tested-part-03/ 04 – http://itegram.com/2017/03/10/oracle-troubleshooting-11g-r2-tested-part-04/ 06 – http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-06/ 07 – http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-07/ 08 – http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-08/ Y links a diversos posts sobre Oracle: https://itegram.com/2017/01/13/indice-posts-sobre-oracle/ Errores encontrados en este post Achicar tablespace SYSTEM ORA-03206 ORA-00227: corrupt block [...]

Oracle Error Troubleshooting (11g r2 tested) – part 04

By |2017-04-30T00:27:23+00:00marzo 10th, 2017|Categories: DB, Oracle, Oracle Troubleshooting, Uncategorized|Tags: , |

Continuamos con la seria de posts sobre errores encontrados en Oracle, y como solucionarlos: Parte 04

Oracle – Datos, comandos para tener a mano.

By |2017-02-14T18:54:32+00:00febrero 14th, 2017|Categories: Oracle, Uncategorized|Tags: |

  [crayon-5d2f53096b95a584138449/] Diagnostic and alert files location SQL> select name, value from v$diag_info; Alert log $tail -50 /o/app/oracle/diag/rdbms/base/BASE/trace/alert_BASE.log $du -sh /o/app/oracle/diag/rdbms/base/BASE/trace/* | grep alert Enterprise agent $ORACLE_HOME/hostname_BASE/sysman/log/ $ORACLE_HOME/network/admin/tnsnames.ora Archive logs - production y standby PRODUCCION (ultima secuencia archivada) [crayon-5d2f53096b967803062035/] REPLICA (ultimo aplicado) [crayon-5d2f53096b96b174068255/] Archivelogs [crayon-5d2f53096b96e524450959/] Borrar archivelogs mas viejos que un dia [crayon-5d2f53096b972434009648/] Query to see [...]