martes, 30 de julio de 2013

SPFILE

SQL> CREATE pfile='/tmp/initRAC.ora' FROM spfile;

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.

Many of the most difficult Oracle problems to fix usually are due to some environmental issue or change. It was working yesterday, now it's not, what's different. I use the RDA for a comprehensive environment report. But you'll have to wait a bit, it's not exactly speedy. :-)  
You can download it from MetaLink - Doc ID: 314422.1

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
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

12 eBooks gratuitos de Microsoft que no te pueden faltar.

12 eBooks gratuitos de Microsoft que no te pueden faltar.


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';