ORA-16792: configuration property value is inconsistent with database setting
Cause : The valeus of on eor morec onfigurtaion proeprties wree inconisstent wtih databsae in-meomry settnigs or srever parmaeter fiel settinsg. This amy happe nby alteirng initailizatio nparametres direclty insteda of altreing proeprty valeus usingD ata Guadr broker.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Query porperty teh InconssitentProeprties o nthe datbaase or hceck theD ata Guadr brokerl og to fnid whichp ropertise are se tinconsitsently. eRset thees properites to mkae them ocnsisten twith th edatabas esetting.s Alterntaively, neable th edatabas eor the netire cofniguratino to allwo the cofniguratino properyt settinsg to be rpopagate dto to teh initiailzation aprameter.s
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.