:

RSS11g

ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0

If you experience the following error messsage when starting up your database, try changing the “COMPATIBLE” parameter to a 5 digit one. For example, I was running Oracle 11g and originally the COMPATIBLE parameter was set to 11.2.0. I changed it to 11.2.0.3.0, attempted another STARTUP MOUNT command and it worked without a problem. SQL> […]

Continue Reading

ORA-31154 Invalid XML Document

The Problem During an 11g DB upgrade I got this error: ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-31154: invalid XML document ORA-19202: Error occurred in XML processing LSX-00020: unknown type “string” ORA-06512: at “XDB.DBMS_XDB”, line 528 ORA-06512: at line 55 The Cause Not quite sure… The Solution Use Metalink […]

Continue Reading

Change Password in Oracle 11g – Password Column Empty

In Oracle 10g it was possible to select the encrypted password from the DBA_USERS view so that you could effectively hack into someones account and then change the password back without them knowing. The way to do this was as follows: SELECT username, password FROM DBA_USERS WHERE username LIKE ‘SECRET%’; Once you have the password […]

Continue Reading

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 […]

Continue Reading

ORA-38880: Cannot advance compatibility from 10.2.0.4.0 to 11.2.0.2.0 due to guaranteed restore points

The Problem I had created a guaranteed restore point in my 10g, 10.2.0.4, database with the idea that I would have a fail back plan should anything go wrong with the upgrade process to 11g. After creating the restore point, running the necessary pre-upgrade checks and changes and then starting up the DB in upgrade […]

Continue Reading

Symbol file oraclsra11.SYM does not match binary

The Problem I installed and patched Oracle 11.2.0.1 to patchset version 5 which was the latest one out at the time. The install went without error and I upgraded several of my databases to start using the new software. I then received a call from a developer who was getting the following error message when […]

Continue Reading

Resource Manager Plan After 11g Upgrade

This is critical information for any Oracle DBA looking to upgrade their 10g database to 11g. It concerns a new default resource manager plan which is enabled after you have upgraded your database from 10g to 11g. The name of the plan is called something like “SCHEDULER: DEFAULT_MAINTENANCE_PLAN”. This will show up if you run […]

Continue Reading

11g Install File Not Found

11g Install File Not Found

The Problem I was installing the Oracle database 11g software. I had extracted the software from two zip files which were downloaded from Metalink. Two folders were created. When running the installation via the GUI, I received the error messages below, in addition to many other similar messages. File not found D:\Oracle\product\11.2\owb\external\oc4j_applications\applications\WFMLRSVCApp.ear D:\Oracle\product\11.2\oc4j\j2ee\oc4j_applications\applications\WFMLRSVCApp.ear D:\Oracle\product\11.2\owb\external\oc4j_applications\applications\WFMGRApp.ear D:\Oracle\product\11.2\owb\external\oc4j_applications\applications\WFMGRApp.ear […]

Continue Reading

ORA-28002: the password will expire within 7 days

ORA-28002: the password will expire within 7 days

The Problem I was working on a project to upgrade our databases from 10g to 11g so we rolled it to one of our TEST environments in order to identify any problems. After some time using it, we came across an ORA-28002 error message. The following error is the full error shown to the user: […]

Continue Reading