| Large number of trace file generation in Bdump [message #454785] |
Fri, 07 May 2010 07:27  |
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
|
Member |
|
|
Hi Experts,
We are facing one issue on one of the database.
The database is generating large trace files(14000) from last two days. That consumes around 15G space on the disk.
And the content of the trace files is not having any meaningful message that help me to debug:
cat /apps/oracle/admin/fs90uat/bdump/fs90uat_p050_23966.trc
*** TRACE DUMP CONTINUES IN FILE /apps/oracle/admin/fs90uat/bdump/fs90uat_p050_23966.trc ***
Dump file /apps/oracle/admin/fs90uat/bdump/fs90uat_p050_23966.trc
*** TRACE DUMP CONTINUED FROM FILE /apps/oracle/admin/fs90uat/bdump/fs90uat_p050_23966.trc ***
... (Many lines with above message)
The alert log is having one repeated error yesterday:
Thu May 6 22:00:03 2010
Errors in file /apps/oracle/admin/fs90uat/bdump/fs90uat_j000_11811.trc:
ORA-12012: error on auto execute of job 2647927
ORA-04063: ORA-04063: package body "ORACLE_OCM.MGMT_DB_LL_METRICS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ORACLE_OCM.MGMT_DB_LL_METRICS"
ORA-06512: at line 1
The corresponding trace file is having:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /apps/oracle/product/10.2.0/db_1
System name: SunOS
Node name: corpqadb30
Release: 5.10
Version: Generic_142900-03
Machine: sun4u
Instance name: fs90uat
Redo thread mounted by this instance: 1
Oracle process number: 278
Unix process pid: 11811, image: oracle@corpqadb30 (J000)
*** ACTION NAME:(MGMT_CONFIG_JOB_1) 2010-05-06 22:00:03.657
*** MODULE NAME:(DBMS_SCHEDULER) 2010-05-06 22:00:03.657
*** SERVICE NAME:(SYS$USERS) 2010-05-06 22:00:03.657
*** CLIENT ID:() 2010-05-06 22:00:03.657
*** SESSION ID:(357.55849) 2010-05-06 22:00:03.657
*** 2010-05-06 22:00:03.657
ORA-12012: error on auto execute of job 2647927
ORA-04063: ORA-04063: package body "ORACLE_OCM.MGMT_DB_LL_METRICS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ORACLE_OCM.MGMT_DB_LL_METRICS"
ORA-06512: at line 1
has errors
Can you please help me out.
Any advice is really appreciated.
Regards
Lalit
|
|
|
|
|
|
| Re: Large number of trace file generation in Bdump [message #455308 is a reply to message #454785] |
Tue, 11 May 2010 01:55  |
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
|
Member |
|
|
Hi Michel,
I applied the suggestions by grating the below privileges to OCM:
(Referred the link :
http://download.oracle.com/docs/cd/B28359_01/install.111/b28251/deinstall_ocm.htm)
To resolve these errors, you must grant the missing EXECUTE privilege to the ORACLE_OCM user.
For database versions 10g and later, grant EXECUTE privileges on the UTL_FILE and DBMS_SCHEDULER packages to the ORACLE_OCM user by entering the following SQL*PLUS commands:
SQL> grant execute on UTL_FILE to oracle_ocm;
SQL> grant execute on DBMS_SCHEDULER to oracle_ocm;
SQL> ALTER PACKAGE oracle_ocm.MGMT_DB_LL_METRICS compile;
SQL> ALTER PACKAGE oracle_ocm.mgmt_config compile;
But the number of trace files still continue to generate in the OS with same message.
Regards
Lalit
[Updated on: Tue, 11 May 2010 06:40] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
