OraFAQ Forum: Server Administration » Getting error during upgrade to oracle 10.2.0.5

Home » RDBMS Server » Server Administration » Getting error during upgrade to oracle 10.2.0.5 (10.2.0.4 -> 10.2.0.5, RHEL5 - 64-bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting error during upgrade to oracle 10.2.0.5 [message #462469]

Thu, 24 June 2010 06:49

ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON

Member

Hello everyone,

I have upgraded my database from 10.2.0.4 to 10.2.0.5. however while upgrading database using DBUA I am getting this error.

table or view does not exist ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579 ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596 ORA-06512: at line 1

The WMSYS.OWM_MIG_PKG is warped package and I can't understand what it means. How can I understand what view or table is absent in my database?

Thanks,

[Updated on: Thu, 24 June 2010 06:51]

Report message to a moderator

Re: Getting error during upgrade to oracle 10.2.0.5 [message #462472 is a reply to message #462469]

Thu, 24 June 2010 06:57

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

What happens if you ignore the error and proceed?
Looks like a bug. Check metalink?

Report message to a moderator

Re: Getting error during upgrade to oracle 10.2.0.5 [message #462476 is a reply to message #462472]

Thu, 24 June 2010 07:11

ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON

Member

I've ignored this error and upgrade has been completed successfully.

Upgrade ResultsDatabase upgrade has been completed successfully, and the database is ready to use...
...........
..........
Information:Oracle ServerError ignored: ORA-00942: table or view does not exist ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579 ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596 ORA-06512: at line 1
.......
......

I haven't found more information in log files.

/upgrade> grep ORA-00942 *
Oracle_Server.log:ORA-00942: table or view does not exist
trace.log:[Thread-42] [16:46:51:44] [BasicStep.handleNonIgnorableError:431]  ORA-00942: table or view does not exist
UpgradeResults.html:<br>*Some information about the step is available.<br><font size=+1>Step Execution Information:</font><br><a NAME="Oracle Server"></a><b>Oracle Server</b><br><tt>Error ignored: ORA-00942: table or view does not exist

I've checked metalink and have found nothing about this error.

Report message to a moderator

Re: Getting error during upgrade to oracle 10.2.0.5 [message #462478 is a reply to message #462476]

Thu, 24 June 2010 07:15

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Now that upgrade is done, do your post upgrade process as documented / said in README.
Check for invalid objects (specifically for workspace manager) and if required, run the util scripts to create again.

Report message to a moderator

Re: Getting error during upgrade to oracle 10.2.0.5 [message #462483 is a reply to message #462478]

Thu, 24 June 2010 07:43

ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON

Member

Mahesh Rajendran wrote on Thu, 24 June 2010 16:15

Now that upgrade is done, do your post upgrade process as documented / said in README.
Check for invalid objects (specifically for workspace manager) and if required, run the util scripts to create again.

Thank you for attention to my problem. I don't have any invalid objects in WMSYS schema. I've compared tables and views of WMSYS user with tables and views of WMSYS user on another successfully upgraded database and have discovered that I didn't have 4 views

OWNER			       VIEW_NAME
------------------------------ ------------------------------
WMSYS			       AQ$WM$EVENT_QUEUE_TABLE
WMSYS			       AQ$WM$EVENT_QUEUE_TABLE_R
WMSYS			       AQ$WM$EVENT_QUEUE_TABLE_S
WMSYS			       AQ$_WM$EVENT_QUEUE_TABLE_F

and 7 tables

OWNER			       TABLE_NAME
------------------------------ ------------------------------
WMSYS			       AQ$_WM$EVENT_QUEUE_TABLE_G
WMSYS			       AQ$_WM$EVENT_QUEUE_TABLE_H
WMSYS			       AQ$_WM$EVENT_QUEUE_TABLE_I
WMSYS			       AQ$_WM$EVENT_QUEUE_TABLE_S
WMSYS			       AQ$_WM$EVENT_QUEUE_TABLE_T
WMSYS			       SYS_IOT_OVER_10261
WMSYS			       WM$EVENT_QUEUE_TABLE

.

should I create them? How can I create them?

Report message to a moderator

Re: Getting error during upgrade to oracle 10.2.0.5 [message #462500 is a reply to message #462483]

Thu, 24 June 2010 09:44

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Probably the other database is using AQ options.
Unless you are using workspace manager and AQ, you can ignore them.

Report message to a moderator

Re: Getting error during upgrade to oracle 10.2.0.5 [message #462592 is a reply to message #462500]

Fri, 25 June 2010 03:34

ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON

Member

According to the Oracle® Database Application Developer's Guide - Workspace Manager
10g Release 2 (10.2)documentation I've downgraded a Workspace Manager to 9.2.0.1.0 release:

> cd $ORACLE_HOME/rdbms/admin
> sqlplus / as sysdba

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP RESTRICT
SQL> SPOOL wm.log
SQL> @owme920.sq
SQL> @owmd920.plb

after that have upgraded again to 10.2.0.5.:

SQL> @owmupgrd.plb
SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;

I've compared objects again and have found no difference. Smile

Thank you again Mahesh Rajendran

Report message to a moderator

Previous Topic:	Problem with create index - Oracle 9i
Next Topic:	Stumped about an ORA-01683 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 10:36:07 CST 2024