CarajanDB Experten-Blog

  • All
  • General
  • Oracle
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
Uncategorized

Standard Edition 2

No Standard Edition and Standard Edition One anymore! In the Oracle MOS Note 2027072.1 Oracle announces that from Oracle 12c 12.1.0.2 on there won’t be a Standard Edition and Standard Edition One anymore, but only a “Standard Edition 2” that is limited on servers with two sockets. However the Standard Edition 2 contains Oracle RAC for two nodes maximum. How the licensing will look like and what consequences this brings to upcoming upgrades or migrations remains to be seen. We keep you posted! Addition from July 8th 2015: All Information regarding Standard Edition 2 was deleted from the MOS website!

Standard Edition 2 Blogbeitrag lesen »

By • • 1 minute of reading
Uncategorized

Non-CDB Deprecated

1

Cite: “The non-CDB architecture is deprecated in Oracle Database 12c, and may be desupported and unavailable in a later Oracle Database release. Oracle recommends use of the CDB architecture.” (Oracle 12c Database Upgrade Guide, Chapter 8.1.1). What does that mean?

Non-CDB Deprecated Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Data Guard Flashback

Redundant data saving is usual for almost every database nowadays, and it does not matter if it is a RAID-1 (mirroring) or RAID-5 or anything like that. Nevertheless critical databases must be saved by a copy. This is why: By corruption of data the mirroring could be damaged as well. A data backup is not sufficient, because the restore would take too long in case of an error. Logical mistakes ([inlinecode]DROP[/inlinecode] or [inlinecode]TRUNCATE TABLE[/inlinecode]) could not be recognized or eliminated by a disk mirroring. To create such a copy there are at least two different methods: Creating an identical copy

Data Guard Flashback Blogbeitrag lesen »

By • • 6 minutes of reading
Oracle

Oracle 12c Unified Auditing – Part 2

Bild1

Unified Auditing was introduced with Oracle 12c 12.1.0.1 and one idea is to combine standard auditing (AUD$) with fine grained auditing (FGA_LOG$). AUD$ and FGA_LOG$ still exists and if you like you can use your existing and well accepted auditing procedures. Some documents stated that the same auditing which was introduced with Oracle 11g is still running but that’s not one hundred percent true. If you don’t change the standard database setup the “old” AUD$ table exist but will stay empty in contrast to 11g. A new partitioned table with a somewhat cryptic name (CLI_SWP$2dc5e8db$1$1) is populated in the schema

Oracle 12c Unified Auditing – Part 2 Blogbeitrag lesen »

By • • 4 minutes of reading
Scroll to Top