Archivo del Autor: carlosap

How To Unlock HR user in Oracle Database 12c

I have been asked several times about how one can unlock HR schema or user in oracle database 12c? In this blog I will try to answer your question along with some common errors which you may face during or after unlocking the HR schema in Oracle Database 12c. So let’s go ahead and see… Leer más »

usefull commands

list SQL> define DEFINE _DATE = «06/04/15» (CHAR) DEFINE _CONNECT_IDENTIFIER = «orcl» (CHAR) DEFINE _USER = «SYSTEM» (CHAR) DEFINE _PRIVILEGE = «» (CHAR) DEFINE _SQLPLUS_RELEASE = «1201000100» (CHAR) DEFINE _EDITOR = «Notepad» (CHAR) DEFINE _O_VERSION = «Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application… Leer más »

change language sqlplus

51 down vote accepted Try to set user.language and user.country properties in sqldeveloper.conf file located in sqldeveloper\bin\ folder. Sample for set french language: IncludeConfFile ../../ide/bin/ide.conf SetJavaHome D:\jdk1.6.0_25 AddVMOption -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true AddVMOption -Dsun.java2d.ddoffscreen=false AddVMOption -Dwindows.shell.font.languages= AddVMOption -Duser.language=fr AddVMOption -Duser.country=FR AddVMOption -XX:MaxPermSize=128M AddVMOption -Doracle.jdbc.mapDateToTimestamp=false IncludeConfFile sqldeveloper-nondebug.conf To switch off language try to remove its support by editing oracle.translated.locales… Leer más »

Alimentación antes de hacer ejercicio

Muchos atletas ponen mucho énfasis en la comida previa al evento creyendo que es el elemento clave para el rendimiento. Es importante recordar que los alimentos consumidos a lo largo de la semana de entrenamiento y los alimentos y líquidos consumidos durante el evento es igual de importante. El consumo de alimentos y líquidos antes… Leer más »

SQL Server–HOW-TO: quickly retrieve accurate row count for table

http://blogs.msdn.com/b/martijnh/archive/2010/07/15/sql-server-how-to-quickly-retrieve-accurate-row-count-for-table.aspx   Recently, I’ve been involved in a very interesting project in which we need to perform operations on a table containing 3,000,000,000+ rows. For some tooling, I needed a quick and reliable way to count the number of rows contained within this table. Performing a simple SELECT COUNT(*) FROM Transactions operation would do the… Leer más »

Suggested Max Memory Settings for SQL Server 2005/2008

Suggested Max Memory Settings for SQL Server 2005/2008 Posted on October 29, 2009 by Glenn Berry https://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/ It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subject to… Leer más »

error odbc mss dataserver

http://knowledgebase.progress.com/articles/Article/P132010 Progress Software Company Info Contact Us Worldwide Try Now Products Products Overview Corticon DataDirect DataDirect Connect Data Integration Suite Data Source OpenAccess SDK Other Modulus OpenEdge Pacific DataDirect Cloud Easyl Rollbase Solutions Solutions Overview Solution By Category Application Deployment Application Development Business Rules Management Data Connectivity Platform as a Service Self-Service Data Integration and… Leer más »

DBTool fails with juMsgProcessInit error

Short answer run dbtool with sudo,root, or admin privileges, it has to access shared memory Información Article Number 000010823 Environment Progress 9.1E OpenEdge 10.x All Supported Operating Systems Question/Problem Description DBTool fails with juMsgProcessInit error juMsgProcessInit failed 1 juMsgProcessInit failed 1 ERROR connecting 1 Clarifying Information Error Message Defect/Enhancement Number Cause This message is returned… Leer más »

the compound effect

It’s not the big things that add up in the end; it’s the hundreds, thousands, or millions of little things that separate the ordinary from the extraordinary.