:

Oracle Database 11g Information

Here at ORA00600.com we like to try and bring you the latest information from within the database community. We put up solutions to error messages we come across and configuration issues we encounter.

Before you even get started with Oracle database 11g, you may come across an error while attempting to install the Oracle software where you get a File not found error. This is on a Windows environment.

As I’m sure that most of you will be doing an upgrade from a previous version of Oracle, it’s important to make sure that upgrade process goes smoothly. In an upgrade from 10.2.0.4 to 11.2.0.1 there were several invalid SYS objects.

Once I had 11.2.0.1 up and running I discovered that there was yet another bug! This time the problem was that there was a very high version count due to a bind mismatch.

Prior to upgrading the Oracle database from version 10.2.0.4 to 11g, I had many procedures which were used to carry out maintenance operations at various times of the day. One such package was not working on the upgraded 11g database. When attempting to execute the package I received the error ORA-24247: network access denied by access control list (ACL). This was related to the new fine grained auditing feature in Oracle 11g.

It’s also very important to consider any default behaviour changes which are present in a new release of the Oracle software. After just a short time of using our upgraded database we came across a warning message ORA-28002: the password will expire within 7 days which we noticed on DEV before rolling to PROD, luckily.

During your upgrade process you may have decided to use the Oracle flashback technology in order to safeguard against any errors while you were upgrading the database. I had the same idea! But, unfortunately, I ran across the ORA-38880: Cannot advance compatibility from 10.2.0.4.0 to 11.2.0.2.0 due to guaranteed restore points error while attempting to do this.

I hope that the information on this page has been informative and that the articles I have written will benefit you when installing, configuring and using your new Oracle 11g database.

Like it, share it...

Category: 11g


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *