locutoriorama

  Ejemplo de "Database Incrementally Updated Backup" :   rman target "'/ as sysbackup'"     Run { RECOVER COPY OF DATABASE WITH TAG 'incr_update';  BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update' DATABASE;  }     LIST COPY OF DATABASE;  SELECT FILE#, STATUS, CREATION_TIME, COMPLETION_TIME, TAG, BLOCKS*BLOCK_SIZE/1024/1024 SIZE_MB, INCREMENTAL_LEVEL  FROM V$DATAFILE_COPY   WHERE DELETED ='NO' ORDER BY FILE#, RECID;

Para WinSxS: Dism.exe /online /Cleanup-Image /StartComponentCleanup Para c:\windows\installer: Net Stop msiserver /Y  Reg Add HKLM\Software\Policies\Microsoft\Windows\Installer /v MaxPatchCacheSize /t REG_DWORD /d 0 /f  RmDir /q /s %WINDIR%\Installer\$PatchCache$ Net Start msiserver /Y Net Stop msiserver /Y Reg Add HKLM\Software\Policies\Microsoft\Windows\Installer /v MaxPatchCacheSize /t REG_DWORD /d 10 /f Net Start msiserver /Y

Desinstalación Oracle 18.3.0 Generamos un response file: [oracle@suez 18.3.0]$ id uid=501(oracle) gid=502(oinstall) groups=502(oinstall),501(dba),503(asmdba),504(asmadmin) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 [oracle@suez 18.3.0]$ cd deinstall/ [oracle@suez deinstall]$ ./deinstall -checkonly Checking for required files and bootstrapping ... Please wait ... Location of logs /tmp/deinstall2018-07-26_03-39-35PM/logs/ ############ ORACLE DECONFIG TOOL START ############ ######################### DECONFIG CHECK OPERATION START ######################### ## [START] Install check configuration ## Checking for existence of the Oracle home location /u01/app/oracle/product/18.3.0 Oracle Home type selected for deinstall is: Oracle Single Instance Database Oracle Base selected for deinstall is: /u01/app/oracle Checking for existence of central inventory location /u01/app/oraInventory ## [END] Install check configuration ## ...

Instalación Oracle Database 18.3.0 StandAlone - Silent Ref: https://oracle-base.com/articles/misc/oui-silent-installations https://oracle-base.com/articles/18c/oracle-db-18c-installation-on-oracle-linux-6-and-7 Como usuario Oracle: mkdir –p /u01/app/oracle/product/18.3.0 cd /u01/app/oracle/product/18.3.0 unzip -q /home/oscar/Desktop/STAGE/BBDD/LINUX.X64_180000_db_home.zip # Silent mode. Utilizo el fichero de respuesta generado anteriormente: [oracle@suez 18.3.0]$ ./runInstaller -ignorePrereq -waitforcompletion -silent -responseFile /home/oracle/db_soft_standalone.rsp Launching Oracle Database Setup Wizard... [WARNING] [INS-13014] Target environment does not meet some optional requirements.    CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2018-07-26_05-39-06PM.log    ACTION: Identify the list of failed prerequisite checks from the log: installActions2018-07-26_05-39-06PM.log. Th...

select  name,decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1) Redundancy,REQUIRED_MIRROR_FREE_MB,   (total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Total_MB,   ((free_mb - REQUIRED_MIRROR_FREE_MB)/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Free_MB,   ((free_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1))/(total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)))*100 "%Free" from v$asm_diskgroup;

Falcon BMS 4.33 download

Oracle Database 12c: INTERACTIVE QUICK REFERENCE

En este script utilizo la vista dba_temp_free_space que está disponible a partir de la versión 11g de Oracle: SELECT a . tablespace_name , a . asignado , b . libre , c . contents , c . status FROM ( SELECT tablespace_name , SUM ( bytes )/ 1024 / 1024 AS asignado FROM dba_Data_files GROUP BY tablespace_name ) a , ( SELECT tablespace_name , SUM ( bytes )/ 1024 / 1024 AS libre FROM dba_free_space GROUP BY tablespace_name ) b , ( SELECT tablespace_name , contents , status FROM dba_tablespaces ) c WHERE a . tablespace_name = b . tablespace_name (+) AND a . tablespace_name = c . tablespace_name UNION ALL SELECT d . TABLESPACE_NAME , d . ALLOCATED_SPACE / 1024 / 1024 , d . FREE_SPACE / 1024 / 1024 , e . contents , e . status FROM dba_temp_free_space d , dba_tablespaces e WHERE d . tablespace_name = e . tablespace_name AND contents = 'TEMPORARY' ; Para la versión...

AWR Formatter, de Tyler Muth (https://tylermuth.wordpress.com/2011/04/20/awr-formatter/) y que se puede bajar de : http://dl.dropbox.com/u/4131944/AWR-Format/AWR-Format.crx Tiene problemas para ejecutarse en Croome, pero en el navegador Opera funciona! Solo hay que configurarlo así en las extensiones:

Instalación de cx_Oracle con WinPython-32bit-2.7.10.2 en Windows 7 64-bit ************************************************************************* 1º configurar winpython.ini: [debug] state = disabled [environment] ## Uncomment lines to override environment variables #PATH = #PYTHONPATH = #PYTHONSTARTUP = ORACLE_HOME=D:\BBVA\software\instantclient-basic-nt-12.1.0.2.0_32bits\instantclient_12_1 PATH=%PATH%;D:\BBVA\software\instantclient-basic-nt-12.1.0.2.0_32bits\instantclient_12_1 LD_LIBRARY_PATH=D:\BBVA\software\instantclient-basic-nt-12.1.0.2.0_32bits\instantclient_12_1 2º Bajarse de otn el instant client, incluyendo el *Instant Client Package - SDK: http://www.oracle.com/technetwork/topics/winsoft-085727.html instantclient-sdk-nt-12.1.0.2.0.zip 3º Abrir la consola cmd del winpython y ejecutar pip install cx_Oracle D:\BBVA\software\WinPython-32bit-2.7.10.2\python-2.7.10>sqlplus SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 15 20:16:47 2015 Copyr...

Tenemos una bbdd 11.2.0.1 con sid TEST1. En la misma máquina queremos duplicarla a TEST2 a partir de un backup con rman a disco. No tenemos catálogo de rman. Pasos ----- 1º Hacemos el backup full de TEST1 a disco. En este caso, TEST1 utiliza FRA, por lo que la ubicación del backup generado será el área de fra. 2º Crearmos las rutas de directorios para ubicar la base de datos TEST2. 3º Necesitamos un fichero de password para TEST2, lo podemos copiar de TEST1 y cambiar el nombre. 4º Necesitamos un init.ora para TEST2, con el parámetro db_name=TEST2 únicamente. 5º Levantamos la instancia TEST2 en nomount a partir del initTEST2.ora (TEST1 no hace falta que esté levantada) 6º Conectamos a RMAN con la TEST2 como auxiliary: rman auxiliary / 7º Ejecutamos el script de duplicado: DUPLICATE DATABASE TO TEST2 UNTIL TIME "TO_DATE('08/04/2015 11:39:20', 'DD/MM/YYYY HH24:MI:SS')" SPFILE set control_files='/u01/app/oracle/oradata/TEST2/control01.c...

RMAN 11GR2: DUPLICATE sin TARGET ni CATÁLOGO DE RECUPERACION Aplica a Oracle Database – EE – Version 11.2.0.1 y posteriors Objetivo: Duplicar base de datos sin conectar a la base de datos target (la base de datos origen, la que queremos duplicar), y sin catálogo de recuperación. Este tipo de duplicate sólo se puede realizar para backups en disco, no en cinta. Si fuera con catálogo de recuperación se podría hacer también para backups en cinta. Lo único que RMAN necesita es la localización de las backup pieces. Ejemplo: RMAN> DUPLICATE DATABASE TO dup11r2 UNTIL TIME "TO_DATE('29-MAY-2010 14:16:42','DD-MON-YYYYHH24:MI:SS')" SPFILE set control_files='D:\dup11r2\c1.ctl' set db_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2' set log_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2' BACKUP LOCATION 'D:\dup11r2'; El proceso involucrado en este tipo de duplicado: -Rman restaura e...

-- Ver quien bloquea por esperas pin   set lines 200 select p2raw , p2 / power ( 16 , 8 ) blocking_sid , p1 mutex_id , sid blocked_sid from v $ session where event like 'cursor:%' and state = 'WAITING' / --ver quien espera select * from v $ mutex_sleep /

col a for a20 col b for a20 col c for a20 col d for a20 col e for a20 col f for a20 col g for a20 col h for a20 select chr ( 27 )|| '[40m' || chr ( 27 )|| '[1;' || to_char ( rownum +29 )|| 'mTest' a , chr ( 27 )|| '[41m' || chr ( 27 )|| '[1;' || to_char ( rownum +29 )|| 'mTest' b , chr ( 27 )|| '[42m' || chr ( 27 )|| '[1;' || to_char ( rownum +29 )|| 'mTest' c , chr ( 27 )|| '[43m' || chr ( 27 )|| '[1;' || to_char ( rownum +29 )|| 'mTest' d , chr ( 27 )|| '[44m' || chr ( 27 )|| '[1;' || to_char ( rownum +29 )|| 'mTest' e , chr ( 27 )|| '[45m' || chr ( 27 )|| '[1;' || to_char ( rownum +29 )|| 'mTest' f , chr ( 27 )|| '[46m' || chr ( 27 )|| '[1;' || to_char ( rownum +29 )|| 'mTest' g , chr ( 27 )|| '[47m' || chr ( 27 )|| '[1;' |...

# Configuration file for dircolors, a utility to help you set the # LS_COLORS environment variable used by GNU ls with the --color option. # Copyright (C) 1996, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006 # Free Software Foundation, Inc. # Copying and distribution of this file, with or without modification, # are permitted provided the copyright notice and this notice are preserved. # # You can copy this file to .dir_colors in your $HOME directory to override # the system defaults. # Below, there should be one TERM entry for each termtype that is colorizable TERM Eterm TERM ansi TERM color-xterm TERM con132x25 TERM con132x30 TERM con132x43 TERM con132x60 TERM con80x25 TERM con80x28 TERM con80x30 TERM con80x43 TERM con80x50 TERM con80x60 TERM console TERM cygwin TERM dtterm TERM gnome TERM konsole TERM kterm TERM linux TERM linux-c TERM mach-color TERM mlterm TERM putty TERM rxvt TERM rxvt-cygwin TERM rxvt-cygwin-native TERM rxvt-unicode TERM s...

Instalar "most": merge most (es un paginador) Una vez instalado, añadir al ~/.bashrc la siguiente linea: export PAGER="/usr/bin/most"

Para instalar X-Plane 10 desde el DVD en Linux: Descargar el instalador de : aqui Descomprimir: root ~/builds # unzip X-Plane10InstallerLinux.zip Archive: X-Plane10InstallerLinux.zip inflating: X-Plane 10 Installer Linux Ejecutar el instalador: root ~/builds # ./"X-Plane 10 Installer Linux"

import platform profile = [ platform.architecture(), platform.dist(), platform.libc_ver(), platform.mac_ver(), platform.machine(), platform.node(), platform.platform(), platform.processor(), platform.python_build(), platform.python_compiler(), platform.python_version(), platform.system(), platform.uname(), platform.version() ] def main(): for item in profile: print (item) if __name__ == '__main__': main()

# ------------------------------------------------------------------------------ # FUNCTION #   Displays ASM diskgroup information, space usage. Displays usage by DISKS. #   Displays ongoing operations and list of files on diskgroup. # NOTES #   Developed for 11g Oracle Version. The entry must be in the /etc/oratab #   for ASM instance # # ------------------------------------------------------------------------------ TMP1=`grep -E '^\+' /etc/oratab` if [ -z $TMP1 ]; then   echo "Please check /etc/oratab file, there is no entry for ASM instance."   exit 1 fi ORACLE_HOME=`echo ${TMP1//\:/ } | awk {'print $2'}` ORACLE_SID=`echo ${TMP1//\:/ } | awk {'print $1'}` cd $ORACLE_HOME/bin dispinfo () {  echo "Use -d key to display usage by disks"  echo "Use -o key to display asm operations in progress (disk rebalancing)"  echo "Use -r key to display min, max and avergage free megabytes by diskgroups"  echo "Use -f  to list ...