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 )

 

 846 views last month,  1 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply