ORA-47400: Command Rule violation for ALTER PROFILE on DEFAULT

I got ” ORA-47400: Command Rule violation for ALTER PROFILE on DEFAULT ”  error in Oracle database.

ORA-47400: Command Rule violation for ALTER PROFILE on DEFAULT

Details of error are as follows.

ORA-47400 Command Rule violation for string on string.

Cause: Ensure you have sufficient privileges for this operation retry the operation.

Action: An operation that was attempted failed due to a command rule violation.

In a Database Vault environment the ALTER PROFILE statement fails with ORA-47400 error:

SQL> ALTER PROFILE <profile_name> LIMIT password_life_time unlimited;

ALTER PROFILE <profile_name> LIMIT password_life_time unlimited
*
ERROR at line 1:
ORA-47400: Command Rule violation for ALTER PROFILE on DEFAULT

Command Rule violation for string on string.

This ORA-47400 is related to Ensure you have sufficient privileges for this operation retry the operation.

An operation that was attempted failed due to a command rule violation.

The user who has executed the ALTER PROFILE statement has not been granted with DV_OWNER role.

Connect to the database as one of the DV_OWNER users and retry the ALTER PROFILE command.

second case is as follows.

While cloning with using Hot Backup on Open Database which is introduced on Doc ID 760772.1, following error occurs at Step 13.

And control files are corrupted by the error.

ERROR
———————–
ApplyDatabase.log

—————————————————————
ADX Database Utility
—————————————————————

getConnectionUsingAppsJDBCConnector() –>
APPS_JDBC_URL=’null’
Trying to get connection using SID based connect descriptor
getConnection() –>
sDbHost    : <host>
sDbDomain  : <domain>
sDbPort    : <port>
sDbSid     : <SID>
sDbUser    : APPS
Trying to connect using SID…
getConnectionUsingSID() –>
JDBC URL: jdbc:oracle:thin:@<host>.<domain>:<port>:<SID>
Exception occurred: java.sql.SQLException: ORA-47400: Command Rule violation for CONNECT on LOGON

STEPS
———————–

The issue can be reproduced at will with the following steps:

1. Implement the steps by  Step 12 on Doc ID 760772.1.

2. Performs Step 13, then the error occurs.

Oracle Database Vault was enabled for test purpose.

1. Disable Vault.
   
2. Redo the cloning with Doc ID 760772.1 as control files are corrupted.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )