José Valerio Oracle Technology

Dispro RMAN Training

11.06.2009 · Posted in Personal

Thanks guys, I really enjoyed all the training. In the picture from left to right Carlos, José, Javier and Gustavo. Download orignal picture from here. ...

Comments Off

See you later TELECOM

11.05.2009 · Posted in Personal

What can I say?, I have two new friends now, by the way Fernando, I wished you to be able to have the place that you deserve. Thank you dear Luis for the possibility, I will always be very grateful, A lot of luck in your career. ...

RAC Parallel – Part One

10.26.2009 · Posted in 10g R1, 10g R2, 11g R1, 11g R2, RAC, Scripts, Tip

Parallel in standalone Databases The parallel options invoke multiple processes to utilize spare system resources to reduce the time required to complete tasks or jobs. The parallel options do not reduce the amount of resources required by the processing; rather, they spread the processing burden across multiple CPUs. In order to get the most benefit ...

Comments Off

What’s New in TimesTen 11g SQL ?

10.14.2009 · Posted in TimesTen

Finally… packages and  store procedures, what a change !!! Enhacements Access Control PL/SQL support Oracle In-Memory Database Cache (IMDB Cache) Asynchronous materialized views RETURNING … INTO clause ROWID data type Duplicate parameter names Bitmap indexes Set operators in subqueries Enhanced “:” parameter markers Multiline C-style comments View and sequence names http://download.oracle.com/docs/cd/E13085_01/doc/timesten.1121/e13070/whatsnew.htm#insertedID11 ...

Comments Off

How to configure APEX in 11g R2?

10.14.2009 · Posted in 11g R2, RDBMS, Tip

The most easy way to start using APEX it is just using the embedded PL/SQL gateway, it provides Oracle Database with Web Server and infrastructure to create dynamic and fast applications. The Embedded PL/SQL gateway runs in XML DB HTTP Server in Oracle Database and includes core features of the good and knew mod_plsql (apache ...

Comments Off

Cluster Database “Status Pending” Grid Control 5

09.15.2009 · Posted in GC 10.2.0.5, Grid Control

Cleaning up Cluster and Cluster Databases “Status Pending” states in Grid Control 10.2.0.5.0 1. Download EMDiagKit from Oracle Note: 421053.1 2. Install it on your repository server, you will need SYSMAN password. 3. Remove the cluster target and cluster database targets from console. > Go to Setup > Management Services and Repository > Click deleted ...

How to write “How To” documents

09.13.2009 · Posted in OS, OpenSolaris

Writing How-To’s “Dedicated to Argentina OpenSolaris User Group” Open publication – Free publishing – More OpenSolaris (Text version) Introduction The main purpose for this document is to provide a clear guide about how to create a good document in the group. It’s very important to transmit the knowledge correctly to others who will follow up ...

Comments Off

11g Release 2 Released for Linux !!!

09.01.2009 · Posted in 11g R2

Welcome 11.2.0.1.0 ! I strong believe this will be a great release ,  I tested this version one year ago in California  in the beta phase. http://www.oracle.com/technology/software/products/database/index.html Cheers Oracle! J ...

Comments Off

Oracle change Certification Testing Vendor

08.27.2009 · Posted in Certifications

Starting from September 25, 2009, Oracle Certification Exams will no longer be offered through Prometric. Oracle University is currently in discussion with a new testing vendor to finalize a new partnership. Oracle expects to make an announcement in early September that will include new registration steps for candidates after September 25, 2009. Candidates will continue using ...

Comments Off

cjq0 – Jobs are not running or stop running

08.26.2009 · Posted in 10g R1, 10g R2, RDBMS, Tip

Sometimes Oracle job background demon hangs or stops working. In this situation all the scheduled jobs will never  run again until you kill the process or just bounce your database. Take a look to your trace files dir probably you’ll find traces confirming this issue. Before starts please check the init parameter job_queue_processes, should be ...

Comments Off
Copy Protected by Chetan's WP-CopyProtect.