This blog is about my first installation of Oracle 12c(12.1.0.1.0) on Windows8 and a possible bug I was facing. I have created a Service Request at Oracle Support and they are trying to reproduce with different constallations of Oracle Database software and Windows OS versions. SR 3-7725167161 : Installing 2nd database with connection to 1st … [Read more...]
DOUG Kaffemøde – Excel tools til Oracle E-Business Suite
Torsdag den 29/8/2013 kl. 14.30 - 16.30 afholder Dansk Oracle User Group (DOUG) et "kaffemøde" hos Oracle i Ballerup. Der vil være et indlæg af Preben Keil, hvor han viser to produkter, som kan tage data ud og ind af Oracle E-Business Suite vha. MS Excel. Det er jo velkendt, at rigtig mange EBS slutbrugere kan lide at arbejde med MS Excel :-) … [Read more...]
Oracle12c R1 RDBMS New Features: Creating pluggable database within an existing container database
One of the important new features in Oracle12c RDBMS is the concept of container databases (CDB) containing several pluggable databases (PDB). This enables customers to easily consolidate databases and will be an important feature for a Cloud database (12c, c = Cloud). The overhead in system resource usage will be reduced as the PDBs will share … [Read more...]
Case: Oracle Dataguard switchover test
Recently, we migrated a large customers database environments to new databases on new hardware. The new setup consists of a cold failover Linux Cluster, which is located in the preferred production site, and two Dataguard(standby) databases in a remote DR site. Oracle 11gR2 Grid Infrastructure is used as basis for ASM diskgroups and for … [Read more...]
Oracle RAT – an easy way of proving how performance will be after an upgrade/change
An often overlooked feature of Oracle is Real Application Testing, called RAT. RAT is by far the best way of testing the impact of changes to the database (not applications). This can be anything from upgrading to new hardware, upgrading the database release, adjusting database parameters, creating new optimizer statistics, adding indexes, … [Read more...]
Unpleasent ORA-600 [kfdJoin3] caused by FCO/HDD replacement on ODA V1 with OAK 2.5.0
After several HDDs were replaced in a FCO (Field Change Operation) by Oracle Support on two ODAs, we ran into an unpleasent ORA-600 [kfdJoin3], which resulted in ASM disk groups not mounting, thereby causing the CRS stack to not startup properly. … [Read more...]
Oracle Database Appliance X3-2 Introduced by Oracle
Oracle introduced the new Database Appliance X3-2 March 5, 2013 and it brings some exciting specs and usability that has been greatly anticipated from the community. It further changes the scene from "RAC-in-a-box" to "Virtual Machines in-a-box".. … [Read more...]
Blue Gecko Attending AWS Cloud Conference
Tuesday november 27, 28 & 30 Amazon Web Services will host "AWS re: Invent", their first global customer and partner conference in Las Vegas, USA. "AWS re: Invent" will feature deep technical content on popular cloud use cases, new AWS services, cloud migration best practices, architecting for scale, operating at high availability and making cloud … [Read more...]
Conditional PL/SQL compilation
Conditional PL/SQL compilation. Note the $IF, $THEN, $ELSIF and $END directives. Create or replace procedure selective_directives is begin $IF DBMS_DB_VERSION.VER_LE_10_1 $THEN dbms_output.put_line('I'm on a Database 10 release 1'); $ELSEIF DBMS_DB_VERSION.VER_LE_10_2 $THEN dbms_output.put_line('I'm on a Database 10 release 2'); $ELSEIF … [Read more...]
OurSQL Episode 57: Eventual Discovery part 2
This week we have feedback about Gazzang - Gazzang is using encryptfs for their encryption. According to their launchpad project page at https://launchpad.net/ecryptfs, "eCryptfs is a POSIX-compliant enterprise-class stacked cryptographic filesystem for Linux". The main topic is the 2nd part of events: What events log and where the event logs … [Read more...]
OurSQL Episode 56: Eventual Discovery part 1
This week is all about events - events in MySQL, and calls for papers for 2012 conferences. Percona Live MySQL Conference & Expo call for papers opens soon. http://www.percona.com/live/mysql-conference-2012/ A session matrix for all of the MySQL sessions at Oracle OpenWorld is at http://bit.ly/oow11mysql. MySQL Community Reception (free, no … [Read more...]
About MySQL storage engines and replication
I know most articles are more about DBA issues, however, being a MySQL DBA means that you have several hats that you can where– data architect, application developer, MySQL source developer, and often good old fashioned DBA. I recently had an interesting problem with a particular project I was working on that required the MySQL source code … [Read more...]
OurSQL Episode 55: MySQL Data Encryption
OSCon Data and OSCon videos The Technocation youtube playlist, as of the time of this publishing has 18 videos, mostly from OSCon Data, is at http://www.youtube.com/playlist?list=PLE0AEC3980A198DA0 The O'Reilly YouTube playlist, as of the time of this publishing has 84 videos, from OSCon, OSCon Data and OScon Java, is at … [Read more...]
Finding non-default configuration settings in SQL Server
In our Remote DBA practice, we frequently perform comprehensive system reviews for our customers on their database services. Among the things we always check for are non-default settings for the database software. We want to validate that any non-default setting is set that way for a good reason, and that any setting that is default really should … [Read more...]
DBD::mysql 4.020 Released
I’m pleased to announce the release of DBD::mysql, the MySQL Perl client, 4.020. The release has several great fixes provided by the community, and in particular from Masahiro Chiba, who fixed several issues pertaining to prepared statement support as well as UTF8 support, something that I myself have had a difficult time fixing and … [Read more...]
- « Previous Page
- 1
- 2
- 3
- 4
- …
- 13
- Next Page »