Fix RMAN-04014 ORA-07446: sdnfy: bad value '…/bdump' '…/udump'

Error Description:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 12/25/2011 01:05:21
RMAN-04014: startup failed: ORA-07446: sdnfy: bad value
'/oracle/app/oracle/product/db_1/prod/udump' for parameter user_dump_dest.

Solution Description:
Solution#1

The directory mentioned for user_dump_dest parameter is not a valid one. Please check the directory exist or not with proper read and write privilege.
You will have to modify the user_dump_dest initialization parameter with proper directory name and do the startup.

Solution#2
Even if you specified the correct directory for the user_dump_dust parameter with proper read, write privilege and still you are getting the following error. Then it looks like a Oracle bug 6079571 and it is fixed in Oracle release 11.1. Download the proper pathch from oracle metalink and apply.

ORA-12801:error signaled in parallel query server P001,
ORA-7446:sdnfy: bad value '.../bdump' for parameter
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google