ORA-39714 - Upgrade Script Failed To Complete

Jun 14, 2010

while upgrading to 11.1.0.7 from 10.2.0.4 at the end we are facing this error

ORA-39714: upgrade script utlmmig.sql failed

*Cause: A normal database open was attempted, but the upgrade script utlmmig.sql failed to complete.

*Action: Use the UPGRADE option when opening the database and then run utlmmig.sql.

i ran the utlmmig.sql script and i am facing this issue

SQL> -- we also need to update the statistic
SQL> begin
2 dbms_stats.delete_table_stats('SYS', 'OBJ$MIG');
3 dbms_stats.delete_table_stats('SYS', 'USER$MIG');
4 dbms_Stats.gather_table_stats('SYS', 'OBJ$MIG', estimate_percent => 100,
5 method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY');
6 dbms_Stats.gather_table_stats('SYS', 'USER$MIG', estimate_percent => 100,
7 method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY');
8 end;
9 /
begin
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_STATS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
ORA-06512: at line 2

compiled the invalid objects using utlirp.sql and utlrp.sql but of no use..

View 6 Replies


ADVERTISEMENT

Application Express :: Upgrade Failed In Database From 10g To 11g

Jul 30, 2012

When we upgraded the database from 10g to 11g, Apex upgrade failed. Due to the failure, I removed the old schema and did a fresh install of Apex 4.1. It is working but we lost the applications from previous Apex.

What is the best strategy when you need both database and Apex upgrades? We are a Linux workshop, setting up Apex in Oracle Fusion Middleware 11g environment.

View 0 Replies View Related

RAC & Failsafe :: Failed To Upgrade Oracle Cluster Registry Configuration?

Sep 18, 2008

The installation of CRS is successfull & at end it ask to execute 2 scripts on both nodes i.e. orainstRoot.sh and root.sh

When the scripts are executed,the execution of orainstRoot.sh is successfull , but root.sh give following error:

[root@rac2host crs]# ./root.sh
WARNING: directory '/home/oracle/product' is not owned by root
WARNING: directory 'home/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.

[code]....

Is this concerned with permissions on OCR, Voting Disk.

the ./cluvy shows the cluster is valid.

View 1 Replies View Related

Application Express :: Failed To Load Background Images After Upgrade To 4.1.1 In Mozilla Firefox

Aug 27, 2012

I have recently upgraded our test APEX environment from 3.2.1 to 4.1.1.00.23. Everything went smoothly - I have only one small but annoying problem. In both administration and administration services some background graphics are not displayed. This issue occurs only under Mozilla Firefox (in MS IE it OK). The application frontend is OK in both browsers.

Under Firefox, I inspected the sourcecode in Firebug and the relative links to images. e.g.

background: url("../apex/builder/bg-region-darkblue-r.gif") no-repeat scroll

show message "Failed to load the given URL".

somehow related to the fact that our application is accessed via apache proxy. Because when I open the administration and/or administration services page in FF directly on the server, it displays correctly (incl. images).

But the network (Apache proxy) configuration is exactly the same as in the previous version of APEX where we had no problem. Something must have changed in the sourcecode of the new version.

View 3 Replies View Related

Upgrade :: Cross Platform Upgrade From Single Instance To RAC

Jun 26, 2013

I'm planning to upgrade a small database (~150GB) from 10.2.0.3 on windows 2003 23bit to 11.2.0.3 RAC on Linux 5.8.The database contains oracle spatial too. A suitable method and link to document to be followed. 

View 2 Replies View Related

Upgrade :: ORA-00904 / OBJ$EDITION / Invalid Identifier After Upgrade To 11.2.0.3

Nov 19, 2012

I recently performed an upgrade on a new server from oracle 10gr2 to oracle 11gr2 (11.2.0.3).

I take the rman backup from oracle 10g server and restore it on new server where I installed oracle 11gr2.

But on my previous oracle 10gr2 server I enabled the auditing. After doing successful upgrade now when I try to login with any user except sys I receive the following error:

SQL> conn scott/tiger
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier

I got the workaround by setting the parameter audit_trail=FALSE (Previous value was DB_EXTENDED) .But I want my auditing to be enabled as per y requirements.

View 1 Replies View Related

Upgrade :: Upgrade Patch For Enterprise Versus Standard 11.2.0.1

Sep 22, 2012

is the upgrade patch the same for standard edition and enterprise edition or there are two separate patches?

View 5 Replies View Related

Upgrade :: Reference Note IDs For Database Upgrade From 11.2.0.2. To 11.2.0.3.2

Oct 22, 2012

find reference note IDs for DB upgrade from 11.2.0.2 to 11.2.0.3.2, as I am finding only Exadata which I don't want but I want to find for Ebiz database, on OS - Solaris 10 9/10 s10s_u9wos_14a SPARC.

View 1 Replies View Related

Upgrade :: Oracle 11.2.0.3.0 Database Upgrade Changes DATA_PUMP_DIR

Jun 6, 2012

Along with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.Of the DB's we have upgraded the Data Pump Directory

Select * from dba_directories; (there are other commands to get this info as well).

I captured screens from the DBUA upgrades, but did not see an option to change this information.Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?

Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.

View 4 Replies View Related

Upgrade :: SYS Table Very Slow After 11g Database Upgrade?

Nov 7, 2012

All my sys tables are very slow after my database upgrade from 10.2.0.4 to 11.2.0.3 on AIX 6.1

For example
select * from ALL_TAB_COLUMNS; -- taking 19 seconds in 11.2.0.3 and few millisec in 10.2.0.4

I have deleted and updated fixed and dictionary table statistics , till I facing this issue

View 5 Replies View Related

Upgrade :: Patchset Number To Upgrade Oracle

Jun 14, 2012

Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?

View 1 Replies View Related

Upgrade :: Oracle Upgrade 11.1.0.7 To 11.2.0.3 - Compatible

Jul 19, 2013

I am going to upgrade database from 11.1.0.7 to 11.2.0.3

1) If compatible is set to 10.2.0 in 11.2.0.3, will it work ?
2) If compatible set to maximum level, will it affect our application ?
3) Whether any code related problem occurred after upgrading like PL/SQL codes ?

View 6 Replies View Related

Upgrade :: Oracle Database Upgrade

Mar 13, 2013

We are planning to upgrade our database from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi to Oracle Standard Edition 11g . We also have oracle apex installed on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi database with oracle apex 3.1

No our plan to upgrade the database and oracle apex to 4.2. Since Oracle Enterprise Edition is licensing is very expensive we though of buying standard edition and upgrade to this version.

can we upgrade the oracle database from enterprise edition to latest standard edition?

View 3 Replies View Related

Upgrade :: Database Upgrade From 9.2.0 To 11gr2

Aug 6, 2012

Iam doing some oracle database upgrade from 9.2.0 to 11gr2 . is it possible to upgrade directly from this 9i version to 11gr2 .

Version : 9.2.0 to 11gr2

View 4 Replies View Related

Upgrade :: Compatible Parameter During Upgrade

May 21, 2013

Why COMPATIBLE Parameter is important to be at a certain value before you UPGRADE(10.2.0.4 to 11.2.0.3) to 11g ?

View 2 Replies View Related

Upgrade :: Upgrade 11.2.0.2 To 11.2.0.3 On Linux Environment?

Mar 23, 2013

I try to upgrade 11.2.0.2 to 11.2.0.3 on Linux environment. I have to apply patch P1253900 before the upgrade per oracle doc.

however I got following conflict:

Verifying environment and performing prerequisite checks...
Checking skip_duplicate
Checking skip_subset

Conflicts/Supersets for each patch are:

Patch : 12539000
Conflict with 12827726
Conflict details:
/u01/app/grid/product/11.2.0/grid/lib/libserver11.a:/ksxp.o

Following patches have conflicts: [   12827726   12539000 ] Refer to My Oracle Support Note 1299688.1 for instructions on resolving patch conflicts.

I checked above oracle note, and did not say any resolution.

View 1 Replies View Related

RAC ASM Complete Shutdown And Startup

Jul 7, 2011

I need to take the certain logs on my 3-Node, 10gR2 RAC with ASM on Solaris 10.I have been asked to shutdown the database, nodeapps, listener, asm and crs and then restart crs. Below are t steps that I have prepared.

CODE
====Enable trace=========
ENABLE LEVEL 5 tracing-
./crsctl debug log crs allcomp:5
====Stop database, asm, listener, nodeapps finally crs===
1. STOP DATABASE
srvctl stop database -d DB_NAME
[code]....

View 2 Replies View Related

Workflow :: Activities Which Are Not COMPLETE

Jan 16, 2013

I'm trying to abort some workflow activities which are not 'COMPLETE' and then purge them. I'm using "WF_ENGINE.AbortProcess" to accomplish this task and then purge using "WF_PURGE.Total" to purge the activities. During this process, does any notifications fire?

View 2 Replies View Related

Complete The OCA In 10g For Oracle Administration

Aug 5, 2013

I have done IZ007 in 9i. Now I wanted to complete the OCA in 10g for Oracle Administration.  which exam I need to go for to complete 10g OCA.

View 1 Replies View Related

Private Strand Flush Not Complete

Feb 5, 2013

The "private strand flush not complete" is a "noise" error, and can be disregarded because it relates to internal cache redo file management.

However this "private strand flush cannot complete" error is sometimes accompanies by a hung database.

These are quotes from MR Burleson himself .

But can this be really ignored as it's also mentioned "hung database"

View 1 Replies View Related

SQL & PL/SQL :: Finding Queries That Took More Than 15 Secs To Complete?

Aug 31, 2010

how to find out queries that took more than 15 seconds to execute.

View 4 Replies View Related

SQL & PL/SQL :: How To Get Complete Structure Of Materialized View

Aug 27, 2010

I was trying to get the structure of mview through ALL_MVIEWS, but I was not getting the complete one.ORDER BY clause was missing.

how we can get the complete mview structure.

View 7 Replies View Related

Replication :: How To Monitor Complete Refresh

Oct 29, 2008

I am using basic replication in oracle 10.2.0.3. My materialized view object contains around 3 million records. Usually we are using FAST refresh but in my materialized view having some problem that’s the reason I am going to Complete refresh.

If I start complete refresh it will take 8-12 hours to complete refresh.

My Question is: During Complete refresh how to monitor complete refresh running or not except using

v$mvrefresh.

Is there any way to monitor complete refresh because suppose target database not available/network problem/ dead lock occur in my database. I can’t able to track refresh.

Even there is no notification in alert log.

View 1 Replies View Related

Performance Tuning :: Checkpoint Is Not Complete

Sep 15, 2005

I am running Oracle 9.2.0.1 on Solaris 9. On just about a daily basis we perform sqlldr loads that load on the order of 300000 rows. I frequently see in my alert log:

Checkpoint not complete
Current log# 5 seq# 176431

I have 5 redo logs each of 10M in size. If I check what is going on in v$log and correlate to the alert log when it throws the checkpoint error I always notice that I have one current log (which is good) and the rest are in a status of 'ACTIVE'. It seems that when this happens I get the checkpoint error.

What can I do to get rid of this checkpoint error? Should I increase the size of my redo logs? Is there a good way to go about estimating what size redo logs I should have?

View 6 Replies View Related

Upgrade :: 10.2.0.1 To 10.2.0.4 Upgrade 32bit

Jun 24, 2012

I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in lunux 32 bit . I faced the version incompatibilty error during patchset installation and hence ran the patchset installation with -ignoresysprereqs option.Now during the patchset installation i encountered the below error in in the install logfile.

INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:
INFO: /u01/app/oracle/product/10.2.0/bin/genclntsh
INFO: genclntsh: genclntsh: Could not locate /u01/app/oracle/product/10.2.0/network/admin/shrept.lst
[code]....

Need certified os and versions for oracle db 10gr2

View 2 Replies View Related

Upgrade :: Database Upgrade From 11.2.0.1 To 11.2.0.3

Jan 2, 2013

After many tries of upgrade'ing oracle I decided to make backup of my database and then remove 11.2.0.1 and install 11.2.0.3 to recover db. Unfortunately I am not sure how should I perform restoration.I backed up data by calling RMAN> backup database include current controlfile;

After that I moved files from fast_recovery_area and cleared my machine from current oracle release.I also did a copy of directories:

ORACLE_HOMEdbs
ORACLE_HOME
etworkadmin
ORACLE_HOMEowbinadmin
ORACLE_HOMEhostname_dbname
ORACLE_HOMEoc4jj2eeOC4J_DBConsole_hostname_dbname

View 8 Replies View Related

Upgrade :: Migration / Upgrade 10g / R2 To 11g / 2

Jul 6, 2012

I am looking for for exact steps for migration. The important question ist:

-- If we migrate from 10g to 11g, do we need addition (more) CPU's as currently we have?
-- Do wee need more powerful HW.

View 2 Replies View Related

Upgrade :: Oracle 10g To 11g Upgrade

Feb 21, 2013

I am trying to come up with a plan for an upgrade that is needed for a server I maintain. It is a Windows 2003 32bit running Oracle 10.2.0.3 on old Hardware. It also has two obscure 3rd party applications that are running on it that directly access the database. These applications are supported by off site consultants.

My initial plan was to Create a Windows 2008 R2 Virtual Server and install the same version of Oracle 10.2.0.3. Using Rman clone the database to the new server. Have the consultants come in and get the applications working. Once everything in the new environment seems to be working fine, run RMAN again and reclone the database to have all the latest data. Then at a later time upgrade the database to 11g 32bit. Virtually no downtime and we could spend all the time we needed getting the applications working and testing the new environment.

The plan is dead right of the bat though because I realize 10.2.0.3 is not supported by Windows 2008 R2. I really did not want to add an Oracle DB upgrade into the mix at the same time. Just because their are so many changes from the old environment to the new that I want to break this down into manageable chunks. And I can maybe get by with 1 day of down time.

So now I am looking at installing 11g on my Virtual Server, Clone the database, upgrade the database, have the consultants come in and get the applications working. All the while we are down. If we run into any problems, which you always do, it just completely blows the schedule.

View 1 Replies View Related

Upgrade :: Oracle Upgrade 10.2.0.5 Non-ASM 11.2.0.3 ASM?

Jun 29, 2012

I need to upgrade our current system 10.2.0.5 (non Asm) to 11.2.0.3(ASM) on the same host.

So a few options : install ASM on current 10.2.0.5, create volumes etc and shift DB into ASM

upgrade to 11.2.0.3 GI - standalone

upgrade DB to 11.2.0.3

install 11.2.0.3 GI, configure ASM and run against 10.2.0.5

DB upgrade DB to 11.2.0.3

The DB upgrade has to come last I've been told.

View 1 Replies View Related

SQL & PL/SQL :: How Make Complete Schema Public Synonym

Apr 15, 2013

how to make the complete schema public synonym, instead of creating public synonym object by object.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved