Oracle 12c architecture

July 1st, 2013

Oracle Database 12c Architecture Overview


Oracle 12c Database New Features – Pluggable Database – Video 1


Oracle Database 12c Multitenant Architecture Overview


Oracle Database 12c

June 26th, 2013

Learn all about it: http://apex.oracle.com/pls/apex/f?p=44785:141:0:::141:P141_PAGE_ID,P141_SECTION_ID:6,18 from Oracle Database 12c Learning Library

Take a look at Mike Dietrichs blog and their White Paper about Upgrade to Oracle Database 12c.

Also take a look at Upgrade, Migrate and Consolidate to Oracle Database 12c with over 500 slides covering:

  • The brand new Parallel Upgrade including new Pre/Post-Upgrade-Fix-Ups
  • The new Full Transportable Export/Import Feature
  • Obviously Oracle Multitenant, which got talked about a lot as Pluggable Databases or Container Databases before
  • Plenty of new parameters, cool and very helpful features and much more …
  • Download the slides Upgrade, Migrate and Consolidate to Oracle Database 12c

(Information is respectfully taken from https://blogs.oracle.com/UPGRADE/entry/finally_oracle_database_12c_is)

Yeah, it’s time for some more testing: Oracle Database 12c Release 1 (12.1.0.1.0) is available :-)

12

[root@box ~]# /software/oraInventory/orainstRoot.sh
Changing permissions of /software/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
...
12-1
12-3

oracle@box ]$ rlwrap sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Jun 27 00:49:26 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>

Database instance crash with xdb? ORA-00600: internal error code, arguments: [4881], [], [], [], [], [], [], []

February 26th, 2013

It seems there is a bug that can cause an ORA-00600: internal error code, arguments: [4881], [], [], [], [], [], [], []

Seems to happen once in a while when you have your database configured with ftp and/or http and your user(s) try to login but fail on the credentials.

Now, there was already a patch 12329328 available for HP-UX Itanium, 10.2.0.5 (extended support!) but for Linux x86-64, 11.2.0.3.0 and 11.2.0.3.4 they were released recently. The bug is supposed to be fixed in the upcoming 11.2.0.4 too.

Also see Note: ORA-600 [4881] When Using FTP Client To Connect To The XDB Database Repository [ID 1530585.1]

Upgrade OEM 12 agents after OMS upgrade from 12.1.0.1.0 to 12.1.0.2.0

November 16th, 2012

We’ve run into the situation that we had to find a way to upgrade our 12.1.0.1.0 agents after a successful upgrade of OMS, from 12.1.0.1.0 to 12.1.0.2.0. Why? We have set up our own way of agent deployment.

Therefor, it was necessary to set the password for our oracle user on all nodes. I retrieved the relevant nodes that contain the agents by issuing:

/path/to/oracle/mid02/oms/bin/emcli get_targets|grep 3872|grep P

where “P” stands for our production environment.

After retrieving the list I used the node information to 1) create and run a script to set the password, after 2) agent upgrades from OEM12c (Setup > Manage Cloud Control > Upgrade Agents) run 3) root.sh where applicable and last but not least 4) remove the password again, assuming the agent runs under oracle:

ssh -q -o “StrictHostKeyChecking no” dba_user@host.domain.nl “sudo echo $PASSWORD | sudo passwd oracle –stdin”

Assuming that dba_user can passwordless ssh to all the relevant nodes.

Same goes for the root.sh script:

ssh -q -o “StrictHostKeyChecking no” dba_user@host.domain.nl “sudo /path/to/oracle/agent12c/core/12.1.0.2.0/root.sh”

and for the password removal, obviously:

ssh -q -o “StrictHostKeyChecking no” dba_user@host.domain.nl “sudo passwd -d oracle”

News in the world

October 30th, 2012



RMAN (10gR2) duplicate fails due to ORA-01276 – follow up

October 25th, 2012

The ORA-01276 is caused by a bug (4309649), ref. note ID 1454534.1.
Oracle tries to use the REUSE option and, even without the *.control_files= option set (in a spfile configuration), it hits the bug, resulting in ORA-01276.

Oracle suggests as stated workaround: “If duplicate RMAN command fails with spfile, then use init.ora for the duplicate database instance.” The bug is fixed in 11g.

After testing myself I learned that, when using OMF, duplication indeed only is succesfull without the control_files reference in the pfile.

RMAN (10gR2) duplicate fails due to ORA-01276

May 14th, 2012

Hi,

So, what’s happening?

I am running a RMAN duplicate.
Auxiliary instance has spfile with
*.control_files=’/path/to/<SID>/controlfile/o1_mf_6nw2wfke_.ctl’,'/backup_path/to/<SID>/controlfile/o1_mf_9ns7wsq2_.ctl’#Oracle managed file
Oracle runs into ORA-01276: Cannot add file /backup_path/to/<SID>/controlfile/o1_mf_9ns7wsq2_.ctl. File has an Oracle Managed Files file name.

Workaround for now is to manually create pfile, delete control_file entries and create spfile. Then run a create controlfile script and recover manually.

This happens right after RMAN finishes restoring:
<SID>: restore complete, elapsed time: 06:51:41 Finished restore at 14-MAY-12 sql statement: CREATE CONTROLFILE REUSE SET DATABASE “<SID>” RESETLOGS ARCHIVELOG
released channel: C1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/14/2012 05:48:38
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
ORA-01276: Cannot add file /backup_path/to/<SID>/controlfile/o1_mf_9ns7wsq2_.ctl. File has an Oracle Managed Files file name.

Now, I would assume that, given the fact that Oracle places omf names in the spfile with the remark #Oracle managed file, it should be able to recognize that and work around it.

Do I really have to manually alter an pfile to delete the *.control_files= option, recreate spfile, startup nomount and start my duplicate?

Please comment on this if you have suggestions, thanks!

Oracle 11g, size option for /dev/shm in fstab is being ignored

May 2nd, 2012

So, playing around with an 11 database on oel6. Sweet! But, whatever I tried, I couldn’t get the /dev/shm mounted after boot. Thanks to a search on the Internet I ran into a topic in OTN Discussion Forums.

It states that there probably is a bug (https://www.redhat.com/archives/rhelv6-list/2011-February/msg00081.html).

Adding it appropriately to you fstab and adding the command /bin/mount -o remount /dev/shm in /etc/rc.d/rc.local will solve your problem.

Secure Your Database in a Single Day by Arup Nanda

April 25th, 2012

What:
http://collaborate12.com/ (IOUG, OAUG, Quest)
When:
April 22-26, 2012
Where:
Mandalay Bay Convention Center
Las Vegas, Nevada, USA

#876 – Security Boot Camp: Secure Your Database in a Single Day

Date:
Tuesday, April 24
10:45 am – 11:45 am

Location:
Palm D

Product Line:
Applicable to All

Tracks:
Database, Manageability, Security, Risk and Compliance

Description:
What does it take to make the database secure, to comply with regulations and mandates like SOX and PCI? You may be amazed to know that by taking some simple steps you can perform in a single day, you can attain 60% of the requirements and make your database a secure place, as you will see in this session with demos, examples and code samples to take home.

Arup: thanks for sharing :-)

Presentation
Scripts

iPhone doesn’t push notifications on 3G anymore

April 10th, 2012

Hi,

A long time ago I ran into the problem that I didn’t receive any push notifications anymore when my iPhone was connected to the internet through 3G. Once it was connected through wifi there was no problem.

So, I didn’t get any Facebook, iMessages, Whatsapp, etc.

Googling from time to time to find a solution. Finally, I found an Apple forum where someone gave the solution:

Go to Settings –> General –> Profiles

As you see, the Profile is called Test. In my case is was a profile with a certificate from the previous provider (I switch providers, a while ago).

This was the problem! All I had to do was delete the profile with the certificate from the previous provider and from that moment I was able to receive push notification on 3G again! Yay!!!