Bug 464927
| Summary: | Database error while Importing from 9i to 10g database on test-db-3 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Preethi Thomas <pthomas> | ||||||||||
| Component: | Upgrades | Assignee: | Michael Mráka <mmraka> | ||||||||||
| Status: | CLOSED NOTABUG | QA Contact: | Brandon Perkins <bperkins> | ||||||||||
| Severity: | medium | Docs Contact: | |||||||||||
| Priority: | medium | ||||||||||||
| Version: | 520 | CC: | bbuckingham, ssalevan, tscherf, whayutin | ||||||||||
| Target Milestone: | --- | ||||||||||||
| Target Release: | --- | ||||||||||||
| Hardware: | All | ||||||||||||
| OS: | Linux | ||||||||||||
| Whiteboard: | |||||||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||||||
| Doc Text: | Story Points: | --- | |||||||||||
| Clone Of: | Environment: | ||||||||||||
| Last Closed: | 2008-10-03 02:53:06 UTC | Type: | --- | ||||||||||
| Regression: | --- | Mount Type: | --- | ||||||||||
| Documentation: | --- | CRM: | |||||||||||
| Verified Versions: | Category: | --- | |||||||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||||||
| Embargoed: | |||||||||||||
| Attachments: |
|
||||||||||||
Created attachment 318600 [details]
Import log from test-db-3
I've seen similar issues with the following scenario:
511 Sat running on x86_64, 9i external db
||
\/
520 Sat running on x86_64, 10g external db
Errors occur during DB import, schema upgrade, and, ultimately, Satellite re-activation. I'm attaching the logs from each process to give further insight into the problems.
Created attachment 318601 [details]
9i->10g 511->520 schema upgrade log
Created attachment 318603 [details]
Satellite Reactivation output from stdout
Created attachment 319056 [details]
Log from a 511->520 schema upgrade performed on an i386 box
Preethi ran into similar schema upgrade problems to my own when testing the following scenario:
511 i386 Satellite, external 9i db
||
\/
520 i386 Satellite, external 10g db
Thus, I've attached the output from that process to this comment.
So on two upgrades from 4.2.2 external -> 5.20 external on rlx-2-20 and rlx-2-18 I also received the above error in oracle. However the upgrade was successful in both cases. I would not consider this bug blocking. FYI, ignore my comments, as they have been branched off into a new bug, BZ# 465312. closing. increasing temp tablespace took care of the error. SQL> alter database tempfile '/opt/apps/oracle/data/10.2.0/preethi/temp_01.dbf' resize 1000M; |
Description of problem: Database error while Importing from 9i to 10g database on test-db-3 Version-Release number of selected component (if applicable): 5.2 How reproducible: Steps to Reproduce: 1. Export 5.1 external database from test-db-1 2. Import to the 10g database test-db-3 3. Actual results: . importing table "RHNPACKAGECHANGELOG" 1273332 rows imported IMP-00017: following statement failed with ORACLE error 1652: "CREATE UNIQUE INDEX "RHN_PKG_CL_PID_N_TXT_TIME_UQ" ON "RHNPACKAGECHANGELOG"" " ("PACKAGE_ID" , "NAME" , "TEXT" , "TIME" ) PCTFREE 10 INITRANS 32 MAXTRAN" "S 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GROUPS 1) TABLESPACE "DA" "TA_TBS" NOLOGGING" IMP-00003: ORACLE error 1652 encountered ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TBS Expected results: No errors Additional info: