Oracle Database 18.3.0 on SPARC Solaris is available

Usually I don’t post twice on a day, especially not on a Friday and not in the holiday season. But since last night, Aug 2, Oracle Database 18.3.0 on SPARC Solaris is available for download from OTN. Oracle Database 18.3.0 on SPARC Solaris is available You can download it from OTN: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html And I couldn’t find it on eDelivery – where I find only the 18.1.0 version. But I simply may be not clever enough to use the right search phrase (I used “Oracle Database” as “18” leads to something different). Further Information Oracle Database 18.3.0 on premises is available…

July 2018 Update, Revision, BP and PSU

Hurray, it’s patching day! I know, YOU did look forward to July 17, 2018 as it is patching day again. Last night we released the following Patches: July 2018 Update, Revision, BP and PSU. July 2018 Update, Revision, BP and PSU First of all, I’m doing the usual check for the alert and the risk matrix to see whether there’s are really important security patches included. For the risk matrix you’ll have to scrooooooooooolllll down quite a bit as the list of products is strictly alphabetically ordered: Critical Patch Update – July 2018 – Patch Advisory Risk Matrix for Oracle…

upobjxt.lst lists Oracle Supplied Objects

I blogged about upobjxt.lst lists Oracle Supplied Objects a while ago. But I thought it’s time to refresh this blog post a bit and adjust it to be more useful. upobjxt.lst displays the Oracle Supplied Objects since Oracle Database 12.1.0.1. upobjxt.lst lists Oracle Supplied Objects and Users You can access upobjxt.lst simply with an external table. Create a directory object: CREATE OR REPLACE DIRECTORY ext_tab_data AS ‘/u01/app/oracle/product/12.2.0.1/rdbms/admin/’; Define the external table to query it: CREATE TABLE oracle_supplied_obj_ext ( owner       VARCHAR2(31), name        VARCHAR2(127), placeholder VARCHAR2(20), object_type NUMBER ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY…

How to patch the Oracle Instant Client?

That’s an interesting question a customer raised the other day: How to patch the Oracle Instant Client? I silently assumed that there’s a new release of the Oracle Instant Client every quarter or at least when we deliver fixes which apply to the client as well. Hm … What is the Oracle Instant Client? First of all, the Oracle Instant Client is a pretty cool thing. It gets distributed via OTN as a simple download. You deploy it to your client machine, you set LD_LIBRARY_PATH (or PATH on Windows) and add a tnsnames file if necessary, you may add SQL*Plus…

Oracle Database certification on Microsoft Windows 10

The MOS Note: 1307195.1  about Certification Information for Oracle Database on Microsoft Windows x64 (64-bit) got updated right before the 2015 Christmas holidays with the official certification information for Oracle Database 12c on Microsoft Windows 10. And it says: Windows 10 O/S Information: RAC is not certified. The earliest release certified on Windows 10 is 12.1.0.2. –Mike Previous related blog posts from Aug 14, 2015: Oracle Databases and Microsoft Windows 10

What or who is JOX? And what happens if …

Are you worried because of the title of this blog post? Don’t worry … it will be about the Oracle database and not about miraculous additives. Months back I wrote about how to remove options from the Oracle database’s kernel by either using chopt or linking options off: Removing Options from the Oracle Database kernel in 12c Recently a very interesting case was logged in relation to a bug: A customer had linked off the JOX option from the database kernel. . What is JOX?  Well, do a quick search for “JOX” in the Oracle Documentation and you’ll get “zero results” (or you…

SAP on Oracle Database 12c now with Oracle In-Memory

On March 31, 2015 SAP has been certified to run on Oracle Database 12.1.0.2: SAP is now certified on Oracle Database 12.1.0.2 As of June 30, 2015, Oracle Database In-Memory is supported and certified for SAP environments for all SAP products based on SAP NetWeaver 7.x. on Unix/Linux, Windows and Oracle Engineered Systems platforms running Oracle Database 12c – in single instance and Oracle Oracle Real Application Clusters deployments. Oracle Database 12c is the database of choice for SAP customers based on In-Memory Technology which is fully supported for SAP BW and SAP OLTP applications. For requirements, restrictions, and implementation details…

SAP is now certified on Oracle Database 12.1.0.2

SAP certified Oracle Database 12.1.0.2 as of March 31, 2015! Yes, it’s true. Our colleagues in the Oracle/SAP/CompetenceCenter in Walldorf worked really hard to complete the certification for SAP with Oracle Database 12.1.0.2 But finally it happened. Actually it was announced long time before as planned. And it happened right in time. Please find the official documents here: SAP Service Marketplace ==> Products ==> Installation & Upgrade Guides ==> Database Upgrades (login required) ==> Oracle  Upgrade to Oracle Database 12c Release 1 (12.1): Windows Upgrade to Oracle Database 12c Release 1 (12.1): UNIX And here’s the link to the official announcement:…

Simplify your Migration from AIX to Solaris

There is a brand new white paper available that will be of interest to anybody contemplating a database and/or application migration from AIX to Solaris. Simplify the Migration of Oracle Database and Oracle Applications from AIX to Oracle Solaris gives a good description of the steps involved in planning and executing a migration project, along with the benefits you can expect to achieve and a solid example of migration using Oracle Data Pump, complete with scripted steps.

Behaviour Changes Oracle 8i to 11.2 + New Features Oracle 11.2 + refreshed Upgrade and Migration Slides

We have uploaded refreshed and new slide sets: Refreshed: Upgrade and Migration to Oracle Database 11.2 New: Oracle Database 11.2 New Features Overview New: Behaviour Changes between Oracle 8i and Oracle 11.2 Please note: This is not a 100% complete summary but it will give you a rough overview about parameter and dictionary changes from release to release plus a summary of documented behaviour changes. Sources were the release notes, the documentation, MOS notes and some others.

Hands-on with the Latest Oracle Technology

There is a new set of FREE hands-on workshops available that will give you a chance to work with Advanced Compression, Transparent Data Encryption, Real Application Testing, and GoldenGate without having to spend the time and resources to set up a test environment of your own. If you have a laptop, this is a great opportunity to actually use these options and see how they work for yourself. Titled Oracle Database 11g Upgrade Architecture Planning Workshops,  these events are being rolled out in cities across the country. The first four are in the western part of the US and Canada….

Oracle Database Express Edition 11g Release 2 is now available!

Many customers have asked over the past year whether we would be producing a newer version of the Oracle Database Express Edition, because it makes such a terrific starter database for students, developers, and DBAs. Well, the answer is Yes! As of today, Oracle Database Express Edition 11g Release 2 is available for download. As with the 10g release, this Express Edition is free of charge. To find more information about downloading the software and documentation, please visit the OTN page for Express Edition. Remember, you can always upgrade your database to Standard or Enterprise Edition if you outgrow the…

Database Registry: Component Dependencies

Recently I had to dig a bit into the component dependency topic as I was working with an Oracle Database 10.1.0.5 customer planning to upgrade to Oracle Database 11.2.0.2 with a limited downtime window. To achieve the given downtime window we planned to remove some unused components from the database. Example: Component Dependencies in Oracle Database 11.1 As you know already the time it’ll take to upgrade an Oracle database is mainly dependent on the number of installed components. If you’ll query DBA_REGISTRY (or the underlying REGISTRY$) you’ll spot all the installed (and usually configured) database components. And the more…

Will gathering fixed object stats reduce recompilation time post upgrade?

Interesting question, isn’t it? Will the time to recompile invalid objects post upgrade decreased once fixed object stats have been gathered? First of all fixed object stats on X$-tables won’t be gathered by default [This will change with Oracle 12c where it is part of the Auto Stats Gathering job]. X$ structures are undocumented. V$ views are build on top of them and should only be used even though it might be sometimes useful to access X$ tables such as X$BH (buffer headers – contains information describing the current contents of a piece of the buffer cache) sometimes directly. Anyway,…

Move to Locally Managed Tablespaces

As I’ve got asked during the workshop in Warsaw how to migrate Dictionary Managed to Locally Managed tablespaces here’s some additional information and an example. To find out if a tablespace is dictionary or locally managed you’d use this query: SQL> select TABLESPACE_NAME, EXTENT_MANAGEMENT from DBA_TABLESPACES; The procedure to migrate to locally managed tablespace is: SQL> EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL(‘tbs’); And the whole migration procedure would look like this: STARTUP RESTRICT EXCLUSIVE; EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL(‘TBS’); — do this for all tablespaces except SYSTEM, TEMP and SYSAUX DROP TABLESPACE TEMP; — necessary if there’s no “real” temp tablespace definded yet – see Note:160426.1 CREATE…

Blogs got migrated

Dear Readers, as you can see the blogs from blogs.oracle.com and the former SUN blogs got migrated last weekend. There was a content freeze the whole week before. And as you might already have found the design has changed a bit. But with the design change everything I did customize on the blog’s right column to download slides, access workshops dates or links to some other useful blogs has been erased completely. Even the “About” section hasn’t been migrated (which was a default template). I’d recommend that YOUR migration strategy is a bit more careful in your environments … actually…

Patches, Patch Sets, Patch Bundles, Bundled Patches …

Ouch … just realized that it has been a while since I posted a new topic on the blog. But actually the past weeks I was busy doing workshops, working with customers – and finally (yes!!) participating on an Exadata training class. Sitting there for 3 days, listening the instructor, playing around with the cell simulator and all the exercises was quite a nice change from the daily business. And I believe I’ve learnt something useful 🙂 Well, daily business, this brings me back to a topic which hit my inbox today again for the 2nd time in a few…

New hidden parameters in Oracle 11.2

We really welcome every external review of our slides. And also recommendations from customers visiting our workshops. So it happened to me more than a week ago that Marco Patzwahl, the owner of MuniqSoft GmbH, had a very lengthy train ride in Germany (as the engine drivers go on strike this week it could have become even worse) and nothing better to do than reviewing our slide set. And he had plenty of recommendations. Besides that he pointed us to something at least I was not aware of and added it to the slides: In patch set 11.2.0.2 a new…

Patch Set 11.2.0.2 for Win32 and Win64 now available

Oracle Database Patch Set 11.2.0.2 for Windows (Patch: 10098816) is now available for download from support.oracle.com: Oracle Database 11.2.0.2 Patch Set for Windows 32bit Oracle Database 11.2.0.2 Patch Set for Windows 64bit Please keep in mind: It’s a full install – you don’t have to download 11.2.0.1 first, you can start right with 11.2.0.2 You’ll get it just from support.oracle.com – no download from OTN or eDelivery as this is a patch set Installation will be done by default into a separate %ORACLE_HOME% .- and this is our strong recommendation. If you’d like to install into your existing 11.2.0.1 %ORACLE_HOME%…

Recap on Deinstall Routines

A few weeks ago I’Ve posted something about the deinstall utility as OUI doesn’t offer a “deinstall software” option anymore: How to deinstall “old” SW after 11.2.0.2 has been applied? And I’ve got some feedback (which is a good sign as it means that some of the content might be useful and will be read – and from the follow-up you see that we’ll read your comments and emails as well 🙂 ). Anyway, the feedback was either CRS deinstall does not work the right way or deinstall cleans up too many things. So Roy did follow up with our…