Home » Developer & Programmer » Reports & Discoverer » Upgrading Oracle8i to Oracle Database 10g Enterprise Edition (Oracle Database 10g Enterprise Edition, Oracle8i)
Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656397] Wed, 05 October 2016 04:55 Go to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Hello everybody, Smile

I am trying to upgrade my database version from Oracle8i to Oracle Database 10g Enterprise Edition. All of my other reports are running except Monthly_Attendance_with_OT2 report. Can anybody find out why my this report is not running? I upload my rdf file.

here is my previous and current version of oracle

Previous version
SQL*Plus: Release 8.0.6.0.0 - Production on Wed Oct 5 15:39:26 2016

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option

Current version
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Oct 5 15:40:55 2016

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

Thnak's in advance. Cool
Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656417 is a reply to message #656397] Wed, 05 October 2016 10:24 Go to previous messageGo to next message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you getting an error message?

And why are you upgrading from an incredibly out of date version to a seriously out of date version?

I wouldn't bother upgrading to anything less than 11.2 at this point.
Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656419 is a reply to message #656397] Wed, 05 October 2016 10:35 Go to previous messageGo to next message
John Watson
Messages: 8387
Registered: January 2010
Location: Global Village
Senior Member
Your licensing situation also looks odd: 8i personal edition to 10g enterprise edition?
Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656436 is a reply to message #656419] Wed, 05 October 2016 21:25 Go to previous messageGo to next message
BlackSwan
Messages: 26745
Registered: January 2009
Location: SoCal
Senior Member
John Watson wrote on Wed, 05 October 2016 08:35
Your licensing situation also looks odd: 8i personal edition to 10g enterprise edition?
You assume facts that are not supported by any evidence; that OP is has any Oracle license.

It is a head scratcher why anyone would upgrade from one obsolete & unsupported Oracle version to another obsolete & unsupported version.
Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656443 is a reply to message #656397] Thu, 06 October 2016 01:19 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
/forum/fa/13276/0/

I found this error.
  • Attachment: orafaq.JPG
    (Size: 97.30KB, Downloaded 515 times)
Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656446 is a reply to message #656443] Thu, 06 October 2016 03:19 Go to previous messageGo to next message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
What happens if you do compile all in the report?
Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656447 is a reply to message #656446] Thu, 06 October 2016 03:28 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
When I compile it, again says to compile.
Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656455 is a reply to message #656447] Thu, 06 October 2016 05:00 Go to previous messageGo to next message
Littlefoot
Messages: 21608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure you understood what CM said; I believe he meant to say that you should compile all, i.e. <CTRL + SHIFT + K>. So, did you do that?
Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656501 is a reply to message #656455] Fri, 07 October 2016 23:57 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Yeh I tried compile all i.e. <CTRL + SHIFT + K> same result.
Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656526 is a reply to message #656501] Mon, 10 October 2016 03:49 Go to previous message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
Sounds like a bug, you may be best off just recreating the report from scratch with 10g report builder.
Previous Topic: Separate queries in one report with page filter
Next Topic: Excel file generation
Goto Forum:
  


Current Time: Mon Oct 19 17:26:42 CDT 2020