Archive

Archive for the ‘bug’ Category

Oracle Enterprise Manager: Reports Failed Jobs is empty

June 2, 2011 5 comments

We are using Oracle Application Server 10g Release 2 (10.1.2.3.0), and we have several reports that has failed and we can’t see them on the Reports Failed Jobs Queue.

Searching across metalink I found this document ID: No Reports Jobs Listed In Enterprise Manager “Failed Jobs”, Even Though Several Jobs Have Failed [ID 387541.1].
saying it’s a bug (Bug:6750007 “SOMETIMES, JOBS LINKS IN REPORTS SERVER EM WEB PAGE NO MORE WORK”)

As the doc says, there’s no solution for this bug. The workaround is:

1) Stop Reports Server
2) Rename .dat file (located in $ORACLE_HOME/reports/server directory)
3) Start Reports Server

But this will cause the loss of all the report server history and all the scheduled jobs for the particular report server. If you have scheduled jobs you’ll have to reeschedule them again.

 

Advertisements
Categories: bug, oracle Tags: , ,

Using delicious with Firefox 4.x

I’ve upgraded to firefox 4 and a lot of extensions has become unavailable.

One of them is delicious bookmarks. To get it work again, follow this steps:

  • Select Help > Troubleshooting information
  • On this new tab, click on the button to open the Profile Directory.
  • Navigate to the extensions folder and Inside that should be another folder named “{2fa4ed95-0317-4c6a-a74c-5f3e3912c1f9}”. Inside this is a file called install.rdf
  • Edit install.rdf.
  • Find the line which looks like this:
em:maxVersion="4.0b3pre" />
  • Update this to:
em:maxVersion="4.0.1" />
  • Enter your version of Firefox (in my case 4.0.1).
  • Save the file and restart Firefox.

Extracted from http://support.delicious.com/forum/comments.php?DiscussionID=6201

Categories: bug, firefox Tags: , ,

Youtube hangs firefox on ubuntu 10.10 64 bits

January 14, 2011 Leave a comment

Well, it’s really flash plugin that hangs my FF on ubuntu 10.10 64 bits

I’ve installed flash-aid as a firefox plugin from http://www.webgapps.org/addons/flash-aid and now it works fine.

Categories: bug, firefox, ubuntu Tags: , , ,

ORA-0600 after migrating to oracle 10.2.0.4 (bug 4730372)

December 13, 2010 Leave a comment

I’ve recently migrated an application from oracle 9.2.0.8 to 10.2.0.4 and now I’m getting an ORA-0600 in the alert log:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kkqtfixfro:1: No outer-joined ta], [], [], [], [], [], [], []

The SQL statement (intentionally obfuscated) is this:

SELECT
 (SELECT mcl
 FROM mce, mmo
 WHERE fcn = cci(+)
 AND ccn = mcn(+)
 ) AS mcl,
 fcn,
 pct,
 (SELECT COUNT(*)
 FROM mii
 WHERE iia = 'S'
 AND TO_CHAR(idi,'YYYYMMDD') >= TO_CHAR(:1,'YYYYMMDD')
 AND TO_CHAR(idi,'YYYYMMDD') <= TO_CHAR(:2,'YYYYMMDD')
 ) AS tl,
 COUNT(*) AS COUNT
FROM
 (SELECT pct,
 fcn,
 ici
 FROM mii,
 mft,
 mas,
 mpa,
 mmo
 WHERE ici = acd
 AND ici = fcd
 AND mci = pct
 AND mgg = 'S'
 AND iia = 'S'
 AND TO_CHAR(idi,'YYYYMMDD') >= TO_CHAR(:3,'YYYYMMDD')
 AND TO_CHAR(idi,'YYYYMMDD') <= TO_CHAR(:4,'YYYYMMDD')
 AND acp = pci
 AND ava = 'S'
 AND ars = '+'
 GROUP BY pct,
 fcn,
 ici
 ORDER BY pct,
 fcn,
 ici
 )
WHERE 0 = 1
GROUP BY fcn,
 pct
ORDER BY mcl,
 fcn,
 pct;

In Metalink I’ve found this error is similar to bug 4730372.

As I cannot migrate to oracle 11.2.0.1 yet, I tried in my development environment the workaround proposed:

SQL> alter session set "_simple_view_merging" = false;

As this workaround worked for me, I altered the system instead, because our users cannot issue alter session commands in their applications:

SQL> alter system set "_simple_view_merging" = false scope=both;

As I’ve red in other posts, this is a bug of oracle 10, as it worked fine in oracle 9. See a similar bug with this parameter in http://hemantoracledba.blogspot.com/2008/05/ever-heard-of-simpleviewmerging.html

Categories: bug, oracle Tags: