tag:blogger.com,1999:blog-43610422442778788322020-02-28T21:01:42.416-08:00Oracle DatabaseJaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-4361042244277878832.post-75107464450418226062015-01-24T17:42:00.000-08:002015-01-24T17:42:00.520-08:00Permisos en Linuxhttp://www.smaldone.com.ar/documentos/misdocs/tutorial-gnu-linux/index-8.html<br /><br />http://www.ite.educacion.es/formacion/materiales/85/cd/linux/m1/permisos_de_archivos_y_carpetas.html<br /><br />Jaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.com0tag:blogger.com,1999:blog-4361042244277878832.post-21615683980718947822013-04-08T13:13:00.001-07:002013-04-08T13:13:48.428-07:00Video de instalación de Oracle Linux<br />https://mega.co.nz/#F!4sQEVb4T!Mosjh3SaxWFd7waMPZuQgA<br /><div><br /></div>Jaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.com0tag:blogger.com,1999:blog-4361042244277878832.post-58240276905377745962013-02-09T15:13:00.001-08:002013-02-09T15:19:00.606-08:00Mantenimiento de las tablas de auditoria Base de datos Oracle<br />1. para verificar donde se almacena los registros de auditoria:<br /><br /><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">select parameter_value </span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">from DBA_AUDIT_MGMT_CONFIG_PARAMS</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">where parameter_name = 'DB AUDIT TABLESPACE';</span><br /><br />2. Si se desea mover estas tablas de auditoria a otro tablespace:<br /><br /><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">BEGIN</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION(</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;"> audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD,</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;"> audit_trail_location_value => ‘NOMBRE_TABLESPACE’);</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">END;</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">/</span><br /><br /><br />3. Para inicializar las tablas de auditoria se debe revisar el parámetro audit_trail_type(ejecutar con usuario SYS)<br /><br /><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">BEGIN</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">dbms_audit_mgmt.init_cleanup(</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>audit_trail_type => dbms_audit_mgmt.AUDIT_TRAIL_DB_STD,</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>default_cleanup_interval => 1);</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">END;</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">/</span><br /><br /><br />4. Para hacer mantenimiento a las tablas de auditoria: (ejecutar con usuario SYS)<br /><br /><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">BEGIN</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;"> audit_trail_type => SYS.DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD,</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;"> use_last_arch_timestamp => FALSE);</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">END;</span><br /><span style="background-color: orange; font-family: Courier New, Courier, monospace;">/</span><br /><br /><br /><br /><br /><br />* Informacion adicional<br />http://docs.oracle.com/cd/E11062_01/admin.1023/e11059/avadm_app_d_audit_mgmt.htm#BABIDGEA<br /><br /><br /><br />Jaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.com0tag:blogger.com,1999:blog-4361042244277878832.post-12612645588827167442012-09-22T11:13:00.000-07:002013-01-19T13:41:16.134-08:00Configurar RAW Devices<div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/-1Ks9P3nt5BQ/UF3_qvIAu7I/AAAAAAAAADM/I1cc4mvTG1g/s1600/01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-1Ks9P3nt5BQ/UF3_qvIAu7I/AAAAAAAAADM/I1cc4mvTG1g/s1600/01.png" /></a></div><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://3.bp.blogspot.com/-mRz8wVdKrPI/UF4ALuxu9SI/AAAAAAAAADU/0zsk4xb4wqE/s1600/02.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-mRz8wVdKrPI/UF4ALuxu9SI/AAAAAAAAADU/0zsk4xb4wqE/s400/02.png" height="150" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/-_0IXTn6S7dk/UF4AMREQ7UI/AAAAAAAAADc/fh3QXN5aAlA/s1600/03.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-_0IXTn6S7dk/UF4AMREQ7UI/AAAAAAAAADc/fh3QXN5aAlA/s400/03.png" height="345" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/-dSnQDKq7BN8/UF4AM1rXn_I/AAAAAAAAADk/5hqeiv21SOk/s1600/04.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-dSnQDKq7BN8/UF4AM1rXn_I/AAAAAAAAADk/5hqeiv21SOk/s400/04.png" height="316" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/-aRYA_ycJWdo/UF4ANyXi-MI/AAAAAAAAADs/h79qgvzeSD0/s1600/05.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-aRYA_ycJWdo/UF4ANyXi-MI/AAAAAAAAADs/h79qgvzeSD0/s400/05.png" height="390" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://3.bp.blogspot.com/-51LQh9xErMU/UF4AO_ovprI/AAAAAAAAAD0/5qyM9D2KAc4/s1600/06.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-51LQh9xErMU/UF4AO_ovprI/AAAAAAAAAD0/5qyM9D2KAc4/s400/06.png" height="124" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://3.bp.blogspot.com/-Sz75rwqOkC4/UF4APa9-H3I/AAAAAAAAAD8/lezslpRUVDE/s1600/07.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-Sz75rwqOkC4/UF4APa9-H3I/AAAAAAAAAD8/lezslpRUVDE/s400/07.png" height="74" width="400" /></a></div><br /><br />Jaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.com0tag:blogger.com,1999:blog-4361042244277878832.post-47491829545624599592012-09-22T08:58:00.000-07:002014-07-05T17:52:28.032-07:00Instalación de linux OL 5<br /><div style="font-family: Calibri; font-size: 11.0pt; margin-left: .375in; margin: 0in;">Environments</div><ul style="direction: ltr; margin-bottom: 0in; margin-left: .75in; margin-top: 0in; unicode-bidi: embed;" type="disc"><li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Calibri; font-size: 11.0pt;">Gnome</span></li></ul><div style="font-family: Calibri; font-size: 11.0pt; margin-left: .375in; margin: 0in;"><br /></div><div style="font-family: Calibri; font-size: 11.0pt; margin-left: .375in; margin: 0in;">Applications</div><ul style="direction: ltr; margin-bottom: 0in; margin-left: .75in; margin-top: 0in; unicode-bidi: embed;" type="disc"><li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Calibri; font-size: 11.0pt;">Editors</span></li><li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Calibri; font-size: 11.0pt;">Graphical internet</span></li><li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Calibri; font-size: 11.0pt;">Text-based internet</span></li></ul><span style="font-family: Calibri; font-size: 11pt;">Development</span><br /><ul style="direction: ltr; margin-bottom: 0in; margin-left: .375in; margin-top: 0in; unicode-bidi: embed;" type="disc"><li><span style="font-family: Calibri; font-size: 11pt;">Development libraries</span></li><li><span style="font-family: Calibri; font-size: 11pt;">Develoment tools</span></li><li><span style="font-family: Calibri; font-size: 11pt;">Java development</span></li><li><span style="font-family: Calibri; font-size: 11pt;">Legacy sw development</span></li><ul style="direction: ltr; margin-bottom: 0in; margin-left: .375in; margin-top: 0in; unicode-bidi: embed;" type="disc"></ul></ul><span style="font-family: Calibri; font-size: 11pt;">Servers</span><br /><ul style="direction: ltr; margin-bottom: 0in; margin-left: .375in; margin-top: 0in; unicode-bidi: embed;" type="disc"><li><span style="font-family: Calibri; font-size: 11pt;">Nada</span></li><ul style="direction: ltr; margin-bottom: 0in; margin-left: .375in; margin-top: 0in; unicode-bidi: embed;" type="disc"></ul></ul><span style="font-family: Calibri; font-size: 11pt;">Base System</span><br /><ul style="direction: ltr; margin-bottom: 0in; margin-left: .375in; margin-top: 0in; unicode-bidi: embed;" type="disc"><li><span style="font-family: Calibri; font-size: 11pt;">Administration tools</span></li><li><span style="font-family: Calibri; font-size: 11pt;">Base</span></li><li><span style="font-family: Calibri; font-size: 11pt;">Java</span></li><li><span style="font-family: Calibri; font-size: 11pt;">Legacy</span></li><li><span style="font-family: Calibri; font-size: 11pt;">System tools (sysstat-7)</span></li><li><span style="font-family: Calibri; font-size: 11pt;">X Windows System</span></li><ul style="direction: ltr; margin-bottom: 0in; margin-left: .375in; margin-top: 0in; unicode-bidi: embed;" type="disc"></ul></ul>Jaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.com0tag:blogger.com,1999:blog-4361042244277878832.post-35276038731885626682012-09-16T07:45:00.001-07:002012-09-16T07:45:29.325-07:00Oracle 11gr2 : Problemas con ASM y Cluster Synchronization Service<a href="http://www.oracleyyo.com/index.php/2010/04/19/oracle-11gr2-problemas-con-asm-y-cluster">http://www.oracleyyo.com/index.php/2010/04/19/oracle-11gr2-problemas-con-asm-y-cluster</a><br /><br /><br />Jaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.com0tag:blogger.com,1999:blog-4361042244277878832.post-91535185364933358492012-09-15T10:46:00.001-07:002012-09-15T10:46:35.797-07:00Tutorial de editor VI<a href="http://www.linuxhispano.net/2011/03/16/tutorial-de-vivim/">http://www.linuxhispano.net/2011/03/16/tutorial-de-vivim/</a><br /><br /><br />Jaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.com0tag:blogger.com,1999:blog-4361042244277878832.post-15971357727121392552012-09-15T09:54:00.004-07:002014-07-12T15:53:56.079-07:00Instalación de Oracle 11g R2 en OEL 5 32Bits<br />Pasos de instalación<br /><br /><b>1. creación de grupos y usuarios</b><br />groupadd oinstall<br />groupadd dba<br />groupadd oper<br />groupadd asmadmin<br />groupadd asmdba<br />groupadd asmoper<br /><br />useradd -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle<br /><br />passwd oracle<br /><br /><b>2. editar el archivo vi </b><b>/home/oracle/.bash_profile</b><br /><br />export PATH<br />export ORACLE_BASE=/u01/app/oracle<br />export ORACLE_SID=orcl<br />export ORACLE_UNQNAME=$ORACLE_SID<br />export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1<br />export PATH=$ORACLE_HOME/bin:$PATH<br /><br /><br /><b>3. crear</b><br /># carpetas y permisos<br />mkdir -p /u01/app/oracle<br />chown -R oracle:oinstall /u01/app<br />chmod -R 775 /u01/app<br /><br /><b>4. editar y agregar</b><br />vi /etc/sysctl.conf<br /><br />kernel.sem = 250 32000 100 128<br />kernel.shmall = 2097152<br />kernel.shmmax = 2147483648<br />kernel.shmmni = 4096<br />fs.suid_dumpable = 1<br />fs.aio-max-nr = 1048576<br />fs.file-max = 6815744<br />net.ipv4.ip_local_port_range = 9000 65500<br />net.core.rmem_default = 4194304<br />net.core.rmem_max = 4194304<br />net.core.wmem_default = 262144<br />net.core.wmem_max = 1048576<br /><br /><b>5. #Verificar</b><br />/sbin/sysctl -p<br /><br /><b>6. Editar y agregar</b><br />--------------------------<br />vi /etc/security/limits.conf<br /><br />oracle soft nproc 2047<br />oracle hard nproc 16384<br />oracle soft nofile 4096<br />oracle hard nofile 65536<br />oracle soft stack 10240<br /><br /><b>7. Instalar RPM faltantes</b><br /><br />para consultar los RPMs faltantes ejecutar:<br /><br />rpm -q binutils compat-libstdc++-296 elfutils-libelf elfutils-libelf-devel<br />rpm -q glibc glibc-common glibc-devel gcc gcc-c++ libaio-devel libaio<br />rpm -q libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel<br /><br /><b>* Estas son las librerias faltantes</b><br /><br />libaio-devel-0.3.105-2.i386.rpm<br />unixODBC-devel-2.2.11-<br />unixODBC-2.2.11-1.RHEL4.1<br /><br /><b>- Ejecutar estos comandos para instalar las ibrerias faltantes</b><br /><br />- rpm -ivh libaio-devel-0.3.106-5.i386.rpm<br /><br />- rpm -ivh unixODBC-2.2.11-10.el5.i386.rpm unixODBC-devel-2.2.11-10.el5.i386.rpm unixODBC-libs-2.2.11-10.el5.i386.rpm<br /><br /><b>8. Agregar 4 discos de 8GB a la maquina virtual</b><br />Detener el LINUX y agregar 4 discos de 8GB<br /><br />formatear los 4 discos con el comando fdisk<br /><br />fdisk -l<br />fdisk /dev/sdb<br />n<br />p<br />1<br />1<br />enter<br />w<br /><br /><b>* hacer lo mismo para las siguientes particiones</b><br />fdisk /dev/sdc <br />fdisk /dev/sdd <br />fdisk /dev/sde <br /><br /><b>9. Copiar los instaladores del GRID y la BD al servidor (pueder usar el WINSCP)</b><br /><br />* Conectarse al servidor con el usuario <b>oracle (ftp), </b>por defecto se copiaran en la<br /> carpeta <b>/home/oracle</b><br /><b><br /></b>- linux_11gR2_database_1of2.zip<br />- linux_11gR2_database_2of2.zip<br />- linux_11gR2_grid.zip<br /><br /><b>10. para desempaquetar los archivos ejecutar el comando</b><br /><br /> unzip linux_11gR2_grid.zip<br /><br /> unzip linux_11gR2_database_1of2.zip<br /> unzip linux_11gR2_database_2of2.zip<br /><br /><b>11. configurar raw devices</b><br />* ver entrada en el blog<br /><br /><b>12. instalar el grid (con usuario oracle). Debe estar en modo grafico.</b><br />/home/oracle<br />cd grid<br />./runInstaller<br /><br /><br /><br />Jaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.com1tag:blogger.com,1999:blog-4361042244277878832.post-27091274359627611472012-09-15T09:52:00.002-07:002012-09-15T09:52:25.508-07:00IntroducciónEstamos creando este blog con la finalidad de compartir conocimientos de la base de datos Oracle.Jaimehttp://www.blogger.com/profile/14676597761109161020noreply@blogger.com0