Thursday, February 13, 2014

Oracle Errors 'ORA-01031' during backup

[Normal] From: BSM@cellserver01.co.in "Oraclespec01"  Time: 01/17/11 08:38:07
        OB2BAR application on "Oraserver01.co.in" successfully started.

[Normal] From: ob2rman@Oraserver01.co.in "Oradb01"  Time: 01/17/11 08:38:09
        Starting backup of target database.

[Major] From: ob2rman@Oraserver01.co.in "Oradb01"  Time: 01/17/11 08:38:10
        The database reported error while performing requested operation.

ERROR:
 ORA-01031: insufficient privileges
 CONNECT: dporadb01/*****@Oradb01
[Major] From: ob2rman@Oraserver01.co.in "Oradb01"  Time: 01/17/11 08:38:10
        Backup of target database failed.

[Normal] From: BSM@cellserver01.co.in "Oraclespec01"  Time: 01/17/11 08:38:11
        OB2BAR application on "Oraserver01.co.in" disconnected.

Reason :

This error message "ORA-01031: insufficient privileges" means the authentication failure to access the database for backup.

The password file must be the problem, if not the DB username is not removed. The password file might have expired or changed or do not have permissions.

Solution :

Please have your DB team to remove/recreate the password file.

Command would look like the below:
ORAPWD FILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]

Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba007.htm#ADMIN10241


Hope this helps!

No comments:

Post a Comment

Hi, Just in-case, your comment will be published only after my approval.