A new feature automatically synchronizes password files across Oracle Data Guard configurations. When the passwords of SYS, SYSDG, and so on, are changed, the password file at the primary database is updated and then the changes are propagated to all standby databases in the configuration. As we can see in the example above. As soon…
Oracle 12.2 is finally released on premise and for that reason I would like to share some of my experiences with testing the new Features. First I would like to write about a small new feature, which would be very useful for all DBAs. Now SQL*Plus can keep history of the commands executed, and let you see…
Recently i had a discussion with a customer how to use preupgrd.sql which is per default installed in $ORACLE_HOME/rdbms/admin. The right answer is, don`t use this SQL Script. If you want to upgrade a database to 12.1.0.2 you should use the most recent version of preupgrd.sql which is avaible from MOS Note: How to Download…
Oracle has released a new MOS Note (Doc ID 2027072.1) which is describing the future of the Oracle Standard Edition. Beginning with 12.1.0.2 the Standard Edition (SE) and the Standard Edition One (SEO) are replaced with the new Standard Edition 2 (SE2). SE2 will run on Systems up to 2 Sockets, this is not different from…
Before Version 12.1.0.2 whenever a container database was started all the pluggable databases associated with container database remains in MOUNT state. The workaround was to write a database startup trigger to open PDB during container startup. A Basic example can found on MOS Note: 1594901.1 12c Pluggable Database is closed on restart of Computer If…
When create a Diskgroup the ASM diskname is created per default for you. The name of the disk typically looks like Diskgroupname an some Digits. First check your current diskname. SQL>col name format a12 SQL>col path format a30 SQL>SELECT name, path FROM v$asm_disk WHERE group_number = (SELECT group_number FROM v$asm_diskgroup WHERE name = ‚DG_DATA‘); NAME PATH…
One of the most expensive operation a Oracle Database can do, is to read the data from the disk. On the other side, read a block from the memory is one of the goals in Database Performance Tuning. In the past Oracle has introduced some feature that can help the DBA to prevent Disk Reads (for example…
In this post i want to show how to upgrade the RMAN Catalog to 12.1.0.2. If you try to upgrade the catalog only with the „upgrade catalog“ command you will get a error message like this. [oracle@server1 admin]$ rman target / catalog=rman/welcome1@db12se Recovery Manager: Release 12.1.0.2.0 – Production on Fri Aug 15 11:33:57 2014 Copyright…
In this short post i want to talk about same notable changes beginning with 12.1.0.2. Enterprise Edition is now a requiered if you want to install a database for restricted use. For example if you are using Standard Edtion for RMAN Repository then you must first upgrade this database to Enterprise Edition befor you upgrade…
In this post I want to describe the steps needed to upgrade a PDB from 12.1.0.1 to 12.1.0.2 using the unplug and plugin method. There is also a way where you can make a full CDB upgrade, but this is not the focus of this post. Enviornment: source CDB 12.1.0.1 => ECDB1 source PDB 12.1.0.1…
Peter`s DBA Blog 