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

Expire Oracle User Password in Few Minutes Using Profile Resouces PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME

Values for the parameters PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME can be in number of days or can be in hours or minutes. You can specify the hours or minuts in decimal values.

In below mentioned example I am going to expire the login in 4 minutes (2 mins PASSWORD_LIFE_TIME and 2 mins PASSWORD_GRACE_TIME). In this example I mentioned a number 1440 which is equivalent for 24hr*60Min*1day.

ORA-28011: the account will expire soon; change your password now

If you are getting a error/warning message (ORA-28011) while connecting to oracle user which means that the particular user password life time is over and it is running on the password grace period.

After the grace period time the password will expire and it will ask for new password.

How to Disconnect or Expire the Idle Oracle 10g 11g Sesssions Automatically Using Profile IDLE_TIME Resouce

In many times we wanted to implement the automatic session expiry for the idle session in the databases which are having huge number of user session. Suppose if you wanted to expire the Oracle sessions which are idle more than 3 minutes.

Step 1. Create new profile with IDLE_TIME parameter as 3.

DBMS_SCHEDULER. Create_job Fails with ORA-06512 ORA-27486: insufficient privileges

Error Description:

ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 376
ORA-06512: at line 2
27486. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to perform a scheduler operation without the

How to Add / Install Syntax Highlighter for Scripts in Blogger Post – SQL, Java, Python, HTML etc

Step 1: Changes to the blogger script.

Open Blogger-> Design -> Edit HTML

Search for </head> tag

Add the following code Jut above the </head> tag

a.   Green Color Codes are mandatory

Fix Oracle 10g 11g Data Pump IMPDP Failed withORA-39002 ORA-06512 ORA-39070 ORA-29283: invalid file operation

Error Description:

Oracle datapump impdp fails with following error.

impdp dumpfile=exp_TAB_28122011.dmp directory=DATA_PUMP_DIR logfile=exp_TAB_28122011_imp.log job_name=EXP ignore=y

Import: Release 11.2.0.2.0 - Production on Wed Dec 28 06:19:40 2011