Oracle

/Oracle

Oracle Read Only User ó Usuario de Sólo Lectura

By |2017-08-15T17:42:56+00:00agosto 15th, 2017|Categories: DBA, Oracle|Tags: |

Oracle - Read Only User, o Usuario de Sólo Lectura En este post, vemos cómo crear un usuario Oracle Read Only ó de solo lectura. No es algo muy raro, pero no es algo que buscás y aparece rapidamente. Hay que buscar en la documentación o leer posts. Crear Usuario [oracle@oracleDB-testing dbs]$ sqlplus / as sysdba [...]

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 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-5d2f524c45e19471334445/] 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-5d2f524c45e22726015708/] REPLICA (ultimo aplicado) [crayon-5d2f524c45e26308774965/] Archivelogs [crayon-5d2f524c45e29499452455/] Borrar archivelogs mas viejos que un dia [crayon-5d2f524c45e2d833106391/] Query to see [...]

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

By |2017-04-30T00:25:43+00:00febrero 13th, 2017|Categories: DB, Oracle, Oracle Troubleshooting, Uncategorized|Tags: , |

Continuamos con la seria de posts sobre: 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/ 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/ 08 – http://itegram.com/2017/04/29/oracle-error-troubleshooting-11g-r2-tested-part-08/ Y links a diversos posts sobre Oracle: https://itegram.wordpress.com/2017/01/13/indice-posts-sobre-oracle/ Errores encontrados en este documento ORA-01940 – cannot drop a user that is currently connected [...]