2015

Uncategorized

Oracle inMemory – First experiences

With Oracle 12.1.0.2 the brand new database option named inMemory has been introduced. There are many blogs and articles out in the field so I don’t want to go in to much detail of the main concept. To me “inmemory” sounds a little obvious because whenever we are working with the Oracle database most of our data should be in Memory – right? But there is another naming for it: Column store. So it stores the data in columns instead of rows? Due to the Oracle documentation this isn’t true because “The columnar format exists only in memory (Concepts Guide)”.

Oracle inMemory – First experiences Blogbeitrag lesen »

By • • 8 minutes of reading
Uncategorized

Optimized Multitentant Database Configuration

pic 1

Talking to customers about Multitenant database several of them complained that you need to install all database features regardless if you have them licensed or if you really need them. Using the Oracle Database Configuration assistant, you will find that it is not possible to deselect any of the database components. But is this a problem?

Optimized Multitentant Database Configuration Blogbeitrag lesen »

By • • 2 minutes of reading
Oracle

Data Guard Protection Modes

pic

The availability and consistency of the Standby Database changed evermore throughout the last years and by that the loss of transactions decreased till 0 transactions. Originally only the archived Redolog files were transmitted to the Standby side and loaded there. By this the loss of transactions was in scale of one redolog file. With the 9i version Oracle then introduced the Standby Redologs, so transactions could now be transmitted right from the Online Redologs into the Standby Redologs and loaded immediately. So the loss of transactions was only a few transactions. With the 10g version then the LNS process was

Data Guard Protection Modes Blogbeitrag lesen »

By • • 3 minutes of reading
Uncategorized

OEL 7 Preperation for Oracle 12c

Since Standard Edition 2 is available by now and I already described in my previous blog how easy it is, to set up a database, the question comes up, how to install SE2 on Oracle Enterprise Linux Version 7. Who already worked with OEL 6, will notice when switching to OEL 7, that quite a bit has happened. You’ll be searching the old [inlinecode]/etc/init.d[/inlinecode] in vain, as now the startup of daemons and programs is managed by the command [inlinecode]systemctl[/inlinecode]. By this the commands [inlinecode]service[/inlinecode] and [inlinecode]chkconfig[/inlinecode] are dropped – however I’d like to mention that there are quite a

OEL 7 Preperation for Oracle 12c Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Standard Edition 2 – Second version

2043.image001

Standard Edition 2 (SE2) Available Time has come. As already announced in July and rejected few days later (see Blog https://www.carajandb.com/en/blogs/blog-jahrends-en/230-standard-edition-2-en) on September 1st Oracle releases Standard Edition 2 as version 12.1.0.2 (Download at http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html).

Standard Edition 2 – Second version Blogbeitrag lesen »

By • • 4 minutes of reading
Oracle

Oracle 12c Datapatch

With Oracle 12c the SQL commands belonging to one patch are not installed by [inlinecode]catbundle.sql[/inlinecode]but by the “datapatch” tool, which is located in the OPatch directory. Other than [inlinecode]catbundle.sql[/inlinecode] datapatch checks before if the requirement for the installation are met and if it is actually necessary running those SQL commands. It is also being checked if the database is in upgrade mode. The result of the “SQL Apply” can queried in the view [inlinecode]dba_registry_sqlpatch[/inlinecode], i.e. like this: SQL> SELECT patch_id, version, status, bundle_id, bundle_series FROM dba_registry_sqlpatch;

Oracle 12c Datapatch Blogbeitrag lesen »

By • • 3 minutes of reading
Oracle

Oracle 12c DBUA and Datapatch

upgrade12c 1

Meanwhile all customers applying Oracle databases should work on switching their database to Oracle 12c. While for Standard Edition Users there still is the restriction that only version 12.1.0.1 is available, Enterprise Edition Users can apply version 12.1.0.2. It is matter of course that besides the Basic release the current PSU (Patch Set Unit) is loaded. Performing an installation last week as part of a project, I noticed a small but important commit: If you perform the Upgrade from 11g to 12c with the dbua (Database Upgrade Assistant), the command datapatch is not performed automatically (even though the documentation says

Oracle 12c DBUA and Datapatch Blogbeitrag lesen »

By • • 3 minutes of reading
Oracle

Move Partitions between Tables

You might wonder why you should move a partition from one table to another but actually there are several reasons. The following one came up in a session I had with a customer who wants to archive “old” data. The actual data is partitioned (INTERVAL) and initially his idea was to move the rows to the archive table with INSERT AS SELECT. The archive table has to stay for a minimum of 10 years but is very seldom used. As there are global indexes on the current table with about 300 million rows we couldn’t simply keep the old data

Move Partitions between Tables Blogbeitrag lesen »

By • • 5 minutes of reading
Oracle

Caution, 12c Oracle Home User cannot be changed!

01 Oracle LRM-00109

Be careful when installing Oracle 12c on Windows. The first stumbling block, the Oracle Home User could produce a lot of trouble for you later. If you are used to running your Instance and Listener with an extra Account for Exports to Windows Shares, NAS devices or RMAN Backups to external storages for example with Avamar, a toughtless click at software installation could destroy all your work and efforts. It only remains to set up everything from scratch because the once selected user is not changeable.

Caution, 12c Oracle Home User cannot be changed! Blogbeitrag lesen »

By • • 3 minutes of reading
Scroll to Top