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

[ŚLIPEK Krzysztof]

Hello,

Problem with DB resolved - I've recreated invalid synonyms and recompiled EVR_T type body.

 

Best regards,

Chris

 

>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/20121120/8394167f/attachment.htm>