Knowledge Center Database Administration
Ook dit jaar, namelijk op dinsdag 14 Juni, organiseert AMIS de ODTUG Preview. Het jaarlijkse congres van de ODTUG, de Oracle Development Tools Users Group, vind dit jaar plaats in Longbeach, California van 26 tot en met 30 juni. Het is niet voor iedereen weggelegd om daar naar toe te gaan. AMIS biedt, alweer voor het vijfde achtereenvolgende jaar, aan geÃ¯nteresseerden de kans om een selectie van de presentaties die daar te zien zijn bij te wonen. Een aantal Europese sprekers zal tijdens de AMIS ODTUG preview presentatie laten zien die ook in de Verenigde Staten worden gehouden. Tijdens de AMIS ODTUG Preview zullen er drie keer drie parallelle sessies worden gehouden met verschillende onderwerpen zoals APEX, database development, ADF, JHeadstart en SOA.
Programma:Tijd Track 1 Track 2 Track 3 16:30 Welkom en Registratie 17:00 XFILES, the APEX 4 Version: The Truth is in There…Marco Gralike & Roel Hartman ADF Developers – Make the Database Work for YouLucas Jellema Pipelined Table FunctionsPatrick Barel 18:00 Dinner 19:00 APEX Face/Off – Designing a GUI with APEX Templates and ThemesChristian Rokitta BPMN: The New Silver Bullet?Lonneke Dikmans Building Highly More >
I’ve been using RAC (10gR2) for years now and I was wondering how RAC One Node differs from RAC. That’s why I used a few ‘old’ RAC servers that we had ‘laying’ around to install a RAC One Node Cluster. I also used that cluster to get some hands on experience with ASM but that is not the topic for this post, so I will not go into that further.
I assume that installing the software is a breeze for everyone who has some experience with RAC and who has read the manual so I will not go into that as well. Once you have fulfilled the prerequisites it’s a matter of next, next, finish. (more…)
One of our customers had this request: Can you make a backup of my development database that I can use to restore ( the same database ) to a couple of months back in time?
This customer uses Standard Edition [ SE ]Â 11gR1 database on Windows, and has a backup regime where tape backups older than 6 weeks(!) are reused for new backups. Online backups to disk are used, but are only useful for a recovery to at most 7 days back in time.
My first idea was to just take a cold backup to disk, and use this backup to restore. But this isn’t very elegant, and quite hard to automate. I decided to investigate the 11g possibilities of setting a restorepoint within an archival backup, and using this restorepoint to “flashback” the database back in time. Note that I can’t use the real flashback technology because Oracle Enterprise Edition [ EE ] is the only version that supports flashback.
A few years ago I was lucky to be able to start working for a client that has Oracle RAC clusters. There we encountered lot’s of interesting issues, and one of them was that several client applications couldn’t seem to connect to the RAC cluster whenever a service was failed over to an other instance then the default.
The network environment was a bit different then I was used to work with. There are three domains in use: - domainA for the RAC and other servers, - domainB for the desktop pc’s and laptops - domainC for the citrix farm and the applications hosted there
The tnsnames.ora for domainB and domainC contained an entry like:
Its almost Christmas and the end of this 2010 year and I keep wondering what will happen, Oracle wise, in 2011. I have, had, my idea’s about what might happen, will happen, if I would be Mr. Larry Ellison. Being “in the trade”, a Oracle geek, since 1993, I have seen some movements like, “the raw iron project”, Mr. Ellison buying nCube, Oracle Powerbrowser, the Oracle network computer, the arrival of InterOffice, Collaboration Suite, Beehive, buying data connector and security service and product companies, building Oracle Fusion from scratch. Most impressive are those fully optimized hardware machines like Exadata and ExaLogic, and the supporting OS Oracle Linux. But hold your horses wasn’t Oracle the “data company”…
Does Oracle still fit in the internet age? Stuff is going fast. ROI, Time to Market are most important. If you miss the change, the new trend, it can kill your company almost instantly (iPhone, Android, Oops: Symbian…). Whatever you think of Oracle, Mr. Ellison’s strategies, IMHO I think that he has vision but sometimes is to fast regarding its implementation. Just like “Google Wave”, you can have a hell of a app/idea, but if it is too early, no one will jump after More >
A lot is happening here at Oracle Open World, more than my brain can master right now. Exalogic, ZFS storage, Unbreakable Enterprise Linux, Fusion Apps (finally), Oracle VM for Solaris, etc… Some of those topics aren’t that important for me and/or my customers right now, because they are just out of reach like, for example Exalogic. I read that a full box setup will go for just over 1.000.000 US$ so that is a setup I won’t be managing for a while. On the other hand from an Oracle perspective this is the logic next step to make to provide a solid complete solution from apps layer down to the hardware layer providing a boxed solution for Oracle’s most demanding customers regarding performance, best of breed and availability.
It has very good technology features in there of which I hope it will be open for us “general” database consumers in the near future. One of those Exadata features I would really like to get my hands on would be the in memory index functionality, if not only that it fits perfect with the way I handle XML data, that is “content” based. An other feature would be, for instance, those storage cell optimizations. Anyway, until now, when trying to enable them, it More >