"Escribo conforme voy viviendo. El trabajo emana de mí en un flujo no diferenciado y continuo." Alfonso Reyes (1889-1959) Escritor y poeta mexicano.
martes, 30 de julio de 2013
lunes, 22 de julio de 2013
Crear tabla en MySQL para que acepte las minúsculas y mayúsculas en la llave primaria o bien en los campos que se definan.
Ejemplo de cómo generar la tabla en MySQL para que acepte las minúsculas y mayúsculas en la llave primaria o bien en los campos que se definan:
/*
CREATE TABLE ingreso.tmp2 (
matricula VARCHAR(60) COLLATE utf8_bin NOT NULL default '',
serial VARCHAR(16) COLLATE utf8_bin NULL default'',
PRIMARY KEY (matricula)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ;
*/
Mysql, index, texto download, ejecución
Mysql, index, texto download, ejecución, muestra primeros registros de una tabla
1.- Emite datos de una tabla en texto para portabilidad:
SELECT * FROM esquema.tabla1
INTO OUTFILE "/var/lib/mysql/ingreso/tmp/tabla_1336_210.txt"
FIELDS TERMINATED BY '||' ;
2.- Carga datos:
\. /var/lib/mysql/ingreso/tmp/tablatexto_TMP_A1.sql
3.- Muestra los indices de una tabla, por esquema en dos formas en su sintaxis:
mysql> SHOW INDEX FROM mytable FROM mydb;
mysql> SHOW INDEX FROM mydb.mytable ;
4.- Muestra los primeros 15 registros de una tabla:
mysql> SELECT * FROM esquema.tabla where periodo= 'A' limit 15;
6.- En oracle se cambia un date a otro formato que lo acepte MySQL.
To_Char(fecha_creacion, 'YYYY-MM-DD') AS fecha_creacion ,
To_Char(fecha_ult_modificacion, 'YYYY-MM-DD') AS fecha_ult_modificacion ,
miércoles, 26 de junio de 2013
Oracle Agente de diagnóstico remoto (RDA) de utilidad
Oracle Agente de diagnóstico remoto (RDA) de utilidad
Oracle Remote Diagnostics Agent (RDA) is used primarily by Oracle Support. I've found that this information is very useful and have used to debug issues in my environment. It is a useful utility to me for particular situations.
The utility ships a readme.txt file for both WIndows and Unix that will help get you started. Rather than discuss everything about RDA and analyze the output it provides, I suggest you give it a whirl. Click on this link and you can view the RDA output.
Steps and Commands:
UNIX / LINUX
|
WINDOWS
| |
Unzip Files
|
use Unix/Linux utility
|
use any Windows utility
|
Instructions
|
README_Unix.txt/README_Linux.txt
|
README_Windows.txt
|
Verify Installation
|
rda.sh -cv
|
rda.cmd -cv
|
Run Setup
|
rda.sh -S or rda.pl -S
|
rda.cmd -S or rda.pl -S
|
Run RDA
|
rda.sh -v or rda.pl -v
|
rda.cmd -v
|
To view RDA
|
Open RDA_INDEX.htm from the RDA output directory
| |
Connection to Database:
Open command prompt.
cmd> set ORACLE_SID=mydb
cmd> sqlplus / as sysdba
cmd> sqlplus / as sysdba
And you will be connected to the database.
Oracle Remote Diagnostic Agent (RDA) Report Generation:
Note: I am generating RDA Report on Windows for this article.
Unzip Files:
Unzip the downloaded RDA Utility to a directory ( Here E:/rda ).
Read Instructions:
Go to the directory, where we have unzipped the files and we can read the instructions given in the "Readme_O/S.txt" file.
Verify Installation:
Open command prompt and navigate to the RDA directory.
cmd> rda.cmd -cv
Run Setup:
Open command prompt and navigate to the RDA directory.
cmd> rda.cmd -S
The script continues on for many more pages as part of the configuration. Choose the options according to your Report need.
Run RDA:
Open command prompt and navigate to the RDA directory.
cmd> rda.cmd -v
View RDA Report:
Open "RDA__index.htm" from the RDA output directory to view the report.
Our RDA Report has been generated.
RMAN show all command
RMAN show all command
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
http://dbaoracledba.blogspot.mx/2012/06/rman-show-all-command.html
martes, 25 de junio de 2013
How to remove a line/parameter from spfile?
How to remove a line/parameter from spfile?
alter system reset parameter scope=spfile sid='nodename';
Example:
alter system reset undo_tablespace scope=spfile sid='NODE11';
Example:
alter system reset undo_tablespace scope=spfile sid='NODE11';
Suscribirse a:
Entradas (Atom)