Feed aggregator

Multi-tenant Database notes

Hans Forbrich - Fri, 2013-09-20 11:52
We are in the ACE Director briefing on Friday morning with Penny Avril and people from her team.  Good to see her again!

There are some VERY interesting things coming up - look for the announcements in Larry's keynote on Sunday, and various presentations throughout the week.

---

We did discuss the Multi-tenant database.  One thing was clarified about the licensing, and this is actually written in the Licensing document at http://www.oracle.com/pls/db121/homepage

As of 12cR1, you have 3 modes to install the database:

- Pre-12c mode - 1 (or more) instance for one database;
- Single tenant - available for SE1, SE, EE and PE at no additional charge*
- Multi-tenant - available as an extra-cost option for EE only

* First entry in the table at http://docs.oracle.com/cd/E16655_01/license.121/e17614/editions.htm states:

"Extra cost option for up to 252 pluggable databases. The multitenant architecture with one pluggable database (single tenant) is available in all editions."

While somewhat ambiguous, we did get confirmation that "available in all editions" means no additional fee for 1 tenant.  

(As always - final word is only from Oracle ... "I read it on the internet" is never a good legal defense.)

--------

Update:  APEX is installed by default into the Seed PDB, and the Root PDB.  That can be changed - it can be removed from the Seed, and it can be removed from the Root.  This gives several potential configurations.
 




(Note to self: check on the impact of removing, specifically re: EM Express.)

If installing a PDB, especially importing from an 11gR2, there could be a challenge. 
Categories: DBA Blogs

Strange...

Bas Klaassen - Fri, 2013-09-20 09:31
I was checking Oracle 12c again, because of a beta exam end of october, and noticed something strange. This time I decided to install 12c Grid software first to use the 12c ASM for the 12c database. After installing ASM, I tried to check the disks available in ASM... [oracle@localhost ~]$ . oraenvORACLE_SID = [oracle] ? +ASMThe Oracle base has been set to /opt/oracle[oracle@localhost ~]$ Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1
Categories: APPS Blogs

Presentation links

Catherine Devlin - Thu, 2013-09-19 18:59

I have just had a VERY. Busy. Week. (In a good way!) I've promised the world many talk materials, so:

As for Postgres Open, I absolutely loved it! So happy I finally got to go. I am proud to say that I was the very first to buy my admission for 2014! Hope to blog more about that later...

ACE Director Briefing - Thursday Morning

Hans Forbrich - Thu, 2013-09-19 15:06
ACE Director Briefings have started.

Pretty good attendance - about 75-80 of us from around the world.   Great time renewing old acquaintances and friendships, and meeting new ACE Directors.

We've had a very interesting morning of briefings.  Today is the day for Fusion Middleware and Cloud discussions.  So far we've heard about

- WebLogic Server, Coherence
- BI and EPM
- SOA suite, BPEL, Service Bus, and integration
- ... As A Service

There will be a lot of interesting announcements at Open World this year, but so far they've reminded us that we are under NDA for the details.

During the BI session, I was reminded that the new BI Suite Sample for 11.1.1.7 is available in VM form at http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html
Categories: DBA Blogs

Oracle Open World - the final stretch

Hans Forbrich - Thu, 2013-09-19 09:20
This is the 'week before' Oracle Open World.  The final stretch on the way to announcements, social and business networking, too much activity, sore feet ...

I arrived on Sunday to deliver the Oracle University "Oracle VM Administration: Oracle VM Server for x86" (2nd Ed) course, based on OracleVM 3.2.  I have to say this is one of the best tech courses in the Oracle course catalog - rates right up there with the "Oracle 11g: RAC and Grid Infrastructure Administration Accelerated".  Interestingly, two attendees were from Sweden - this gave them a chance to arrive early and adjust to the time zone.

In my spare time, I got 3 machines ready to loan out during RAC Attack at Open World.  Check out http://www.racattack.org

Arrived at Sofitel yesterday (Wednesday) in the early evening.  Already met up with a number of ACE Directors - Edward Roske, Cary Milsap, Mark Rittmann, Alex Gorbachev, Marcus Eisling, Arup Nanda, and many more ... Tanel Poder is in the booth next to me having breakfast.

In 10 minutes, I'm off to the ACE Director's briefing.  More as time goes on.
Categories: DBA Blogs

BI Publisher Trial Edition News

Tim Dexter - Wed, 2013-09-18 17:11

Whoooo hoooo! Theres finally a new version of the BI Publisher Trial Edition available for download from OTN.

http://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html

11.1.1.7.1 is the imaginative release name. Nevermind your iOS7's get some blazingly fast BIP '.7.1'!

I'll be digging into some of the new features in the coming weeks!

Categories: BI & Warehousing

SQL Developer: add a "child tables" tab to table definition

Tony Andrews - Wed, 2013-09-18 12:10
I always like to extend SQL Developer's table definition by adding a tab that shows the "child tables" for each table - i.e. the tables that have a foreign key to the table in context. I have lost count of how many times I have started work at a new environment or on a new PC and had to set this up from scratch, so thought I'd document it here for next time! First, create a file containing Tony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.com6http://tonyandrews.blogspot.com/2013/09/sql-developer-add-child-tables-tab-to.html

Setup OUD and ODSM, and OVD/OID with ODSM

Frank van Bortel - Wed, 2013-09-18 09:12
ODSM and ODSM? The version of ODSM, suitable for OUD will *not* serve OVD or OID, it is as simple as that. In fact, Oracle spends a whole chapter on installing the lot. I did follow this, but sometimes you want to explore different routes. OUD and ODSM I have described the installation and configuration of these components in a previous entry. There's one update; for this entry I used Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.com0

BBC and web accelerators don't mix

Robert Baillie - Wed, 2013-09-18 02:53
Do you have a problem with the BBC website? Even though you're based in the UK it seems to have a lot of adverts for American companies on it? And it's not that you don't like American companies, it's just that you've already paid your licence fee and that means that you shouldn't have to see any adverts at all.Even worse than that, because it thinks you're not in the UK, it won't let you access any of the iPlayer content! At some point in the last few weeks that started to happen to me on my Android (Nexus 10, no less) tablet. Thankfully I managed to solve it. A quick scan of the BBC help seemed to just direct me to my ISP (they may route you through foreign / non-UK servers - I knew this wouldn't be true as my desktop works OK, and it doesn't sound like BT). A quick mail to them seemed to confirm my fears - no problem there. A mail to the BBC was never going to be much use. I don't blame them, they have a lot of people to deal with and none of them pay a subscription fee that's...

BBC and web accelerators don't mix

Rob Baillie - Wed, 2013-09-18 02:52
Do you have a problem with the BBC website? Even though you're based in the UK it seems to have a lot of adverts for American companies on it? And it's not that you don't like American companies, it's just that you've already paid your licence fee and that means that you shouldn't have to see any adverts at all.
Even worse than that, because it thinks you're not in the UK, it won't let you access any of the iPlayer content!

At some point in the last few weeks that started to happen to me on my Android (Nexus 10, no less) tablet. Thankfully I managed to solve it.

A quick scan of the BBC help seemed to just direct me to my ISP (they may route you through foreign / non-UK servers - I knew this wouldn't be true as my desktop works OK, and it doesn't sound like BT). A quick mail to them seemed to confirm my fears - no problem there.

A mail to the BBC was never going to be much use. I don't blame them, they have a lot of people to deal with and none of them pay a subscription fee that's optional. It makes no economic sense for them to have a good technical help line.

Any way, after a lot of Google searching for phrases like:
  • The BBC thinks I'm not in the UK when I am.
  • iPlayer thinks I'm not in the UK.
  • iPlayer won't serve me any content.
  • BBC has adverts on it.

And many other variations on the theme, I decided to go back to the BBC site and give it one last go.

On one of their help pages I spotted a pretty throwaway comment about web accelerators causing problems sometimes. Knowing that Google's a little too clever for its own good sometimes this seemed like a good avenue to check.

It turns out that this was the problem, and it's really easy to solve.

In Chrome (on Android 4.3 anyway) go to:
  • Settings
  • Advanced
  • Bandwidth management
  • Reduce data usage
  • Then in the tip right corner, flick the switch to off.

That simple.

Basically, if this is switched on then a lot of content isn't served from its source. Rather you get it from Google instead - it gets it from the source, simplifies it, re-compresses it and then sends it to you so that you can get a modest 20% saving on your download sizes.

The result is pretty much as the BBC describes it, your internet content is routed through non-UK servers. It's just that it's not down to your ISP doing, it's Google.

So, hopefully, when you get that dreaded "BBC says I'm not in the UK" feeling, your Google search will bring you here and you'll solve the problem in a fraction the time it took me!

APEX OOW 2013 Schedule and Developer Challenge

David Peake - Tue, 2013-09-17 15:52
For all of you attending Oracle OpenWorld 2013 then you should check out http://apex.oracle.com/oow.
This application will run on both desktop and mobile*
{* The mobile application requires you to sign with your OTN credentials. The desktop application only requires logging in when you enter the challenge}


OTN APEX Developer Challenge

This year, in conjunction with OTN, we are proud to be running a developer challenge.
Entrants will be required to build a mobile application using Application Express.

The challenge starts at 3:00 pm PDT on Monday of OOW in the OTN Lounge (Moscone South). Official Rules and specifics of the challenge will be released at that time and entrants will be allowed to sign-up for the challenge. Entrants have until Tuesday 7:00 pm PDT to complete their submission. Then at 3:00 pm on Wednesday the winners will be announced in the OTN Lounge.

You could win one of three Amazon gift cards!
Simply go to http://apex.oracle.com/oow to learn more (and to enter once the challenge begins).

Last year OTN and Oracle Social Network ran a similar type challenge. Top honors went to two people well known in the APEX community, Martin Giffy D'Souza and Dimitri Gielis.

OOW Calendar and Schedule

This same site also lists all of the Application Express sessions, and related sessions, you may have overlooked in the official OOW Content Catalog. As with the last several years there will also be an APEX Meetup which of course is listed in the schedule complete with the address.

Oracle Open World

Bex Huff - Tue, 2013-09-17 12:09

UPDATE: Oracle Open World is almost upon us! I will be giving 3 talks this year... there was some confusion about Sunday, but this schedule is now final:

UGF9799 Displaying Enterprise Content in Oracle WebCenter Sites
Sunday, 9/22, 8:00 - 9:00 @ Moscone West - 3018

With the latest version of Oracle WebCenter, you can easily surface documents and Web content stored in Oracle WebCenter Content in Oracle WebCenter Sites. There are many integration options, from single images and rendered HTML to an entire Website. Attend this session to learn how to use them and which option is right for you.

UGF9900 - The Top 10 Web App Vulnerabilities and Securing Them with Oracle ADF
Sunday 9/22, 11:45 - 12:45 @ Moscone West room 2003

Cross-site scripting, SQL injection, and request forgery are just some of the major vulnerabilities every Web application developer needs to know about. Attend this session to learn about the Open Web Application Security Project (OWASP) Top 10 security vulnerabilities and how to avoid them by using Oracle Application Development Framework (Oracle ADF) and other Oracle technologies.

CON6876 - Displaying Enterprise Content in Oracle WebCenter Sites
Tuesday 9/24, 15:45 - 16:45 @ Moscone West room 2012

An encore performance of my Sunday talk of the same name...

The first and third ones I will be presenting with Tony Field from Function1, and giving a demo of the new WebCenter Sites/Content integration that was recently released with WebCenter 11.1.1.8. I'm very excited about the 11.1.1.8 release, and will be blogging my overview of it after Open World... when all the dust settles!

read more

Categories: Fusion Middleware

#OOW13

Chet Justice - Mon, 2013-09-16 21:41
I'm going to be busy.

Here's my list of events:

  • Saturday
    • I arrive in San Francisco on Saturday around 1 PM. If you're arriving at around the same time, let me know, we can share a cab into the city.
    • Beer. After arriving I plan on finding a very cold Pliny the Elder. Or three.
    • ODTUG Dinner. I'm crashing this one. It's Board members only to my knowledge and until someone says I cannot go (especially if fueled by more than one Pliny the Elder), I'm going.
  • Sunday
    • Open World Bridge Run. Not sure if I can make it, but I'm going to try. I'm presenting at 10:15 so it will be a tough decision.
    • 10:30 to 11:30. Thinking Clearly About Performance. Somehow I managed to con Cary Millsap into a duet of sorts. I have him convinced it is the other way around. Either way, it should be fun (I am not nervous!).
    • 2:15 to 4:30, Software Development in the Oracle Ecosystem, Part I and Part II. I'm moderating the aforementioned Mr. Millsap, Sten Vesterli, Markus Eisele and Jerry Brenner (My first boss was scheduled to speak as well, but he had a last minute change of plans, jerk).
    • Oracle ACE Dinner. Evening.
    • Post Oracle ACE Dinner drinks...wherever the night takes me.
  • Monday
    • Oracle OpenWorld - San Francisco Bay Swim - Part II, 7:30 AM. We had almost 20 last year, 33 have signed up (on the page anyway) this year. Come along. Cool t-shirts too, sponsored by Oracle Technology Network and designed by Lauren Prezby.



      Let's not forget the swim caps! Sponsored by the encouragable Bjoern Rost of The portrix group (he's like me, afraid of capital letters) (designed by Lauren Prezby).

    • Oaktable World. You'll most likely catch me here after the swim and before the...
    • Wear Your ORACLENERD Gear Day, 3 PM to 4:30 PM. We'll be taking a group photo around 4:30 PM. If you can't make it for that, come by when you can and get a picture with me. You know I like that sh...stuff. You don't have a shirt/hat/sticker/random-item? OTN Lounge is giving away one hundred cool red t-shirts (Lauren Prezby, again).



      This picture is coinciding with the APEX Developer Challenge which goes from 3 - 7:30 that afternoon/evening. I might even give it a go (fueled, hopefully, by Pliny the Elder).
  • Tuesday
Somewhere in there I'll get a chance to breathe. I'll also attend some sessions, hopefully.
Categories: BI & Warehousing

RAC Attack at Oracle Open World

Hans Forbrich - Sun, 2013-09-15 20:53
This year, one of my main Open World activities will be to participate as a RAC Attack Ninja.

RAC Attack is a program initiated by Jeremy Schneider, Dan Norris and Parto Jalili at the IOUG Collaborate 2008 conference as a result of a classroom full of unattended PCs (long story, great ending)

Quoting from the RAC Attack web site at http://racattack.org :

"RAC Attack is a free curriculum and platform for hands-on learning labs related to Oracle RAC (cluster database). We believe that the best way to learn about RAC is with a lot of hands-on experience."

This year the RAC Attack team - we call ourselves RAC Attack Ninjas - will be hosting a campground in the OTN Lounge on Tuesday and Wednesday from 10-2.

People who have their own laptop can download the Oracle VirtualBox (http://virtualbox.org), Oracle Linux (https://edelivery.oracle.com/linux) and Oracle Database 12c for Linux (http://download.oracle.com) and we will help them install Oracle Database 12c and a 2-node RAC cluster.

This year, Exit Certified (Oracle University partner who provides a lot of RAC training) and DELL (Oracle partner who sells a lot of hardware used with RAC) have sponsored some equipment for people who want to attend, but don't want to use their own laptops.

If you are interested in learning more about RAC, maybe installing it on your laptop, then come along to the RAC Attack sessions during OOW. Get more details from the Facebook page for each of the two days.
There is also a Google+ page.

If you are coming to install RAC, you might want to read through this.

Categories: DBA Blogs

Countdown to Oracle Open World

Hans Forbrich - Sun, 2013-09-15 20:38
Oracle Open World - the annual festival during which Oracle employees, pundits, reporters, supporters, and customers try to overwhelm San Francisco with bodies, information, and just general fun - is about to begin. 

My itinerary, generally speaking (as I usually allow a lot of flexibility):

1) I'm already in San Francisco - teaching the Oracle University course on OracleVM until Wednesday. 

On Wednesday evening, I'll be heading to the Sofitel where many of the ACE Directors meet up before the ACED Briefing.

That's when we get to see Vikki and Lillian, the wonderful ladies who herd the cats known as Oracle ACEs. 

2) ACE Director Briefing, Thursday and Friday

In the years since I was fortunate enough to be selected a ACE Director, I have tried to attend all the ACE Director Briefings - presentations by Oracle management and product management to let us know (under NDA) what is coming up.  Of course, with the NDA, we are not allowed to talk about anything until Larry spills the beans, but at least we will have had a chance to mull things over before the beans do get spilled. 

Since Tim Hall can not be at the briefing this year, a number of us ACEDs will be blogging extra, trying to keep him up to date without violating the NDA. 

3) RAC Attack pre-meeting on Sunday, and possibly another on Saturday.

4) Kickoff on Sunday

Things officially start on Sunday with the various user group and specialty sessions, which inevitablyt have a great amount of info, followed by The Kickoff.  If things hold true to previous years, Larry will throw the gauntlet and give us a glimpse of what new announcements will be made and why we should listen.

5) ACE Dinner on Sunday

One of the ACE highlights at OOW it the ACE Dinner on Sunday evening.  I enjoy catching up with my fellow ACEs from around the world, and meeting the new faces who joined the ranks.

6) Monday-Thursday is going to be filled to the brim with all sorts of activities, traveling to and fro, and blogging about it.

7) RAC Attack

I'll be at RAC Attack both Tuesday and Wednesday.  Facebook pages at

8) Enterprise Manager CAB on Friday

I've been very fortunate to be selected as a Customer Advisory Board attendee for the Oracle Enterprise Manager Cloud Control.  This is an opportunity to provide feedback to the inner circle of the product team, as well as to learn about future directions of products.

Most products, and even major features, have CABs.  I encourage all customers to consider getting involved.

Categories: DBA Blogs

Call for papers – Turkish Hadoop Users Meeting

H.Tonguç Yılmaz - Sun, 2013-09-15 07:08
This December we will be meeting, the call for papers period will be finishing at the end of this month, you can follow the meeting details from the LinkedIn group.  

Tightening Security with SELECT ANY DICTIONARY in Oracle 12c

alt.oracle - Thu, 2013-09-12 08:37
Developers and users sometimes request the SELECT ANY DICTIONARY system privilege to enable them to view various data dictionary tables.  This may be fine for querying DBA_TABLES, etc, but the Oracle data dictionary contains a LOT of information.  Some of the views/tables are compromising from a security standpoint.  One of Oracle’s legendary gaffs in version 9i displayed cleartext passwords for database links in SYS.LINK$.  Yikes.  In version 12c, Oracle has locked down this type of access even further.  Here’s an example from version 11g.

SQL> create user altdotoracle identified by altdotoracle;

User created.

SQL> grant create session, select any dictionary to altdotoracle;

Grant succeeded.

SQL> conn altdotoracle/altdotoracle

SQL> select name, password from sys.user$ where password is not null;

NAME                           PASSWORD
------------------------------ ------------------------------
SYS                            AAJ125C9483Q017
SYSTEM                         W45825DFFFD37SE
OUTLN                          WW24Z1N6A8ED2E1
ALTDOTORACLE                   73NH15SG3Q2364W

Armed with these password hashes, password cracking tools can be used to compare these values to common dictionary passwords.  When a match is found on a non-complex password, your password is cracked.  (Don’t wear yourself out trying to crack the hashes above, I obfuscated them)  SELECT ANY DICTIONARY no longer allows access to dictionary objects like USER$, ENC$ and DEFAULT_PWD$. Let’s try it.

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> create user altdotoracle identified by altdotoracle;

User created.

SQL> grant create session, select any dictionary to altdotoracle;

Grant succeeded.

SQL> conn altdotoracle/altdotoracle
Connected.

SQL> select name, password from sys.user$ where password is not null;
select name, password from sys.user$ where password is not null
                               *
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> select * from sys.enc$;
select * from sys.enc$
                  *
ERROR at line 1:
ORA-01031: insufficient privileges


SQL> select * from sys.default_pwd$;
select * from sys.default_pwd$
                  *
ERROR at line 1:
ORA-01031: insufficient privileges
Categories: DBA Blogs

Kscope13 Top Speaker Award

Tim Tow - Thu, 2013-09-12 07:36
I thought I would post a quick picture of the award I earned at Kscope13 as one of the Top 5 Speakers at Kscope13 for my presentation entitled "Introducing the Outline Extractor NG (Next Generation)".   The Next Generation Outline Extractor is a complete rewrite of the popular Outline Extractor.  The original extractor was written in VB which hasn't been supported by Microsoft for many years; the new extractor is written in Java.  You can download my slides, and the next generation outline extractor, from our website at http://www.appliedolap.com/downloads.

I was honored to earn the award which is based on some secret formula combining feedback scores from attendees and number of attendees.  I did have a couple of hundred or so attendees at my presentation which, in my opinion, speaks to the popularity of the outline extractor and not to the popularity of me having anything to say... <BigGrin>

Here is a picture of the nice award sent by ODTUG.


Categories: BI & Warehousing

ORA-02248 - brilliant

Frank van Bortel - Thu, 2013-09-12 06:09
Brilliant explanation, RTFM made polite. [oracle@local ~]$ oerr ora 2248 02248, 00000, "invalid option for ALTER SESSION" // *Cause: Obvious. // *Action: see SQL Language Manual for legal options. Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.com0

Oracle Open World 2013 - attending & presenting

Syed Jaffar - Thu, 2013-09-12 02:36
Most of us knew Oracle Open World 2013 event is fast approaching and the event will kick start in a few days time. I haven't talked much about the OOW13 event of late, therefore, I am sharing my plans over here.

  • attending Oracle ACE Directors briefing scheduled on 19-20 Sept 2013 at Oracle HQ
  • participating and speaking in the following two Expert panel sessions 
      • Session ID: UGF9774
        Session Title: Oracle RAC SIG Meeting: Expert Panel
        Venue / Room: Moscone West - 3004
        Date and Time: 9/22/13, 15:30 - 16:30
If you are coming to OOW13, you are most welcome and I will be glad to see you in my sessions.

I can't guarantee though I will try to bring all authors of 'Expert Oracle RAC 12c'  book together for an unofficial book singing event at the book shop.

Stay tuned for more updates!!

Good luck and look forward seeing you at OOW13.



Jaffar

Pages

Subscribe to Oracle FAQ aggregator