Database Administration (MOSC)

MOSC Banner

Looking for 5632264 patch to upgrade database from 9.2.0.4 to 11.2.0.1

edited Aug 26, 2010 5:58PM in Database Administration (MOSC) 6 commentsAnswered
 Good day time. While upgrading i have problem with timezones.
I havent such tables or views in my database.

[oracle@srv01]$ sqlplus /NOLOG

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 13 12:37:46 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> connect as sysdba
Enter user-name: sys
Enter password:
Connected.
SQL> select tz_version from registry$database;
select tz_version from registry$database
                       *
ERROR at line 1:
ORA-00942: table or view does not exist

Database restored from full rman backup from another server with 9.2.0.4 database (working 24 hours 7 days a week).

Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center