Archive

Posts Tagged ‘bug’

Oracle Enterprise Manager: Reports Failed Jobs is empty

I have several failed reports, but I can’t see them on the 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]

Bug:6750007 “SOMETIMES, JOBS LINKS IN REPORTS SERVER EM WEB PAGE NO MORE WORK”

Metalink says that there is no fix for the bug. The workaround for this bug is as follows :

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

Please note that this modification will cause the loss of all the report server history and all the scheduled jobs for the particular report server. If necessary please get a list of all the scheduled jobs and reschedule them after removing the persistent file.

Advertisements
Categories: oracle Tags: , ,

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.

 

Categories: bug, oracle Tags: , ,

IBM Tivoli dsmj displays gray screen on ubuntu

August 17, 2010 Leave a comment

When I try to restore a file from dsmj I get this gray screen:

dsmj gray screen
The host machine is a Red Hat Enterprise Linux, and my client machine is Ubuntu 10.4.

I found this post that states is a java bug, and  now it works fine! (thanks axel77)

http://adsm.org/forum/showthread.php?17124-dsmj-not-working

Just type this:

export AWT_TOOLKIT=MToolkit
sudo dsmj

Categories: java, linux, tivoli, ubuntu Tags: , , ,

Drop a datafile in oracle 10g RAC with ASM

August 11, 2010 Leave a comment

By mistake, i added a datafile in an ASM+ at a wrong location.

ALTER TABLESPACE "TEST" ADD DATAFILE '+DG_MIKE_DATA1/mike_03.dbf' SIZE 1G

The correct ASM path would be ‘+DG_MIKE_DATA1/mike/datafile/mike_03.dbf’

Trying to solve the mistake, i took the datafile offline (not offline normal) using the Enterprise Manager console:

ALTER DATABASE DATAFILE '+DG_MIKE_DATA1/mike_03.dbf' OFFLINE;

When I tried to drop the datafile via sqlplus i get this:

SQL> ALTER TABLESPACE MIKE DROP DATAFILE '+DG_MIKE_DATA1/mike_03.dbf';
ERROR at line 1:
ORA-01113: file 76 needs media recovery
ORA-01110: data file 76:
'+DG_MIKE_DATA1/mike_03.dbf'

Thus, I’ve found this blog http://esemrick.blogspot.com/2006/03/recovery-of-offline-data-files.html and applied his knowledge to my mistake:

SQL> select status from v$datafile where file#=76;
STATUS
----------
RECOVER
SQL> recover datafile 76;

with all the suggested logs to take back offline the datafile:

SQL> select status from v$datafile where file#=76;
STATUS
----------
OFFLINE
SQL> alter database datafile 76 online;
SQL> alter tablespace TEST DROP DATAFILE 76;

And now I can re-create the datafile in it’s correct location:

ALTER TABLESPACE "TEST" ADD DATAFILE '+DG_MIKE_DATA1/mike/datafile/mike_03.dbf' SIZE 1G

[UPDATED 2010-08-17]

Be careful if you drop a datafile on your primary database (in my case a RAC database) and  you have a standby database (dataguard). Now I have the bug 5623467, “Corrupt redo from ALTER TABLESPACE DROP DATAFILE”, and I think the only workaround is to restore&recover the standby database from the primary database 😦

Categories: oracle Tags: , , , , , , ,