[Spacewalk-list] Problem migrating Oracle backend from 10g XE to 11gR1 EE

[ŚLIPEK Krzysztof]

Hello,

I've tried to migrate SW 1.5 database from Oracle 10g XE to Oracle 11gR1 EE (32-bit) and have problem. I've made export and import of Spacewalk schema but there are 4 objects with invalid status:

 

select * from all_objects where status !='VALID';

 

SPACEWALK      CONTACT                           76466                    SYNONYM          12/11/19             12/11/19             2012-11-19:15:34:30                INVALID              N            N            N            1             

SPACEWALK      CUSTOMER                        76475                    SYNONYM          12/11/19             12/11/19             2012-11-19:15:34:30                INVALID              N            N            N            1             

SPACEWALK      HOST                                    76477                    SYNONYM          12/11/19             12/11/19             2012-11-19:15:34:30                INVALID              N            N            N            1             

SPACEWALK      EVR_T                                  75148                    TYPE BODY         12/11/19             12/11/19             2012-11-19:15:13:45                INVALID              N            N            N            2             

 

EVR_T details:

 

Schema               SPACEWALK

Name                   EVR_T

TypeCode           - not supported here!

# Attribs              3

# Methods         3

Predefined        No

Complete           Yes

Wrapped            No

Evolved               No

Final                      Yes

Instantiable       Yes

OID                        AB51ABBF74A8ABC4E040DD0A128E2754

 

Is Oracle 11g not supported with Spacewalk? Any help is greatly appreciated.

Thanks very much and best regards,

Chris.


----------------------------------------------------------------------
BNP Paribas Bank Polska SA z siedzibą w Warszawie przy ul. Suwak 3, zarejestrowany w Sądzie Rejonowym dla m. st. Warszawy, XIII Wydział Gospodarczy, KRS pod numerem 6421, NIP: 676-007-83-01, kapitał zakładowy 1 434 646 300 zł, w całości wpłacony.
BNP Paribas Bank Polska SA with its registered office in Warsaw at ul. Suwak 3, registered with the District Court for the capital city of Warsaw, XIII Commercial Division of the National Court Register (KRS) under No. 6421, VAT PL 6760078301, holding paid-up share capital of PLN 1,434,646,300.
BNP Paribas Bank Polska SA  disclaimer: http://www.bnpparibas.pl/legal/disclaimer.htm
----------------------------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20121119/3846d576/attachment.htm>