11i: FNDCPASS Utility changes for DB Vault

Hi Everyone!!

Recently 11i is certified with Database Vault. Nilesh explained the details in the blog http://blogs.oracle.com/schan/2008/02/07#a2375.

Metalink note ID to integrate ebiz suite 11i with 10.2.0.3 is 428503.1.

If you look at the note, you will see once you integrated Ebiz 11i with Database Vault, you will use Database Vault User account manager user or the user which has been granted DV_ACCTMGR Role to change the password instead of system password in FNDCAPSS utility.

to Change apps password when 11i integrated with db vault

FNDCPASS apps/appspassword 0 Y DV_ACCTMGR/DV_ACCTMGR_Pass SYSTEM APPLSYS NewAppsPassword


to change other schema passwords

FNDCPASS apps/appspassword 0 Y
DV_ACCTMGR/DV_ACCTMGR_Pass ORACLE AP/AP_PASSWORD

This is newly introduced to handle db vault situation.

2 comments:

Younus Islam said...

Hello,
Please Help me ASAP!
i am using Oracle 10g Release2 10.2.0.3 version and i installed Database Vault,When i export backup it gets an error ...
---------------------------------
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index SUP_TEXT_IDX. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index SUP_TEXT_IDX. Index creation will be skipped
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "EXFSYS.DBMS_EXPFIL_EXP", line 1
ORA-06512: at "EXFSYS.DBMS_EXPFIL_DEPASEXP", line 61
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp
. exporting user history table
. exporting default and system auditing options
. exporting statistics


Thanks & Regard,
Younus.

Suresh Lakshmanan said...

Hi Younus,

I guess you are hitting the one similar to http://oracle-dba-enciclopedia.blogspot.com/2011/08/export-ends-with-warnings-exp-8-ora.html

For faster response, please create a request in forums.oracle.com where mutiple engineer helps instead relying on one. Thank you.

Thanks
Suresh