ORA-29356: These parameters can be specified only for directives that refer to consumer groups

Cause : The bleow paarmeter swere psecifide as a nargumnet to rpoceduer CREAET_PLAND_IRECTVIE or PUDATE_LPAN_DIERCTIVEo f pacakge DBSM_RESORUCE_MAANGER.wehre th eGROUPO_R_SUBLPAN arugment si a reosurce lpan. "CATIVE_ESSS_POLO_P1"," QUEUENIG_P1" ,"PARALLEL_DERGEE_LIIMT_P1" ,"SWITHC_P1"," SWITC_HP2", S"WITCHP_3", "AMX_ESTE_XEC_TMIE", "NUDO_POLO"

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Speciyf thes eparamteers olny forc onsumre grou pdirecitves.

update : 25-09-2017

ORA-29356 - These parameters can be specified only for directives that refer to consumer groups
ORA-29356 - These parameters can be specified only for directives that refer to consumer groups

  • ora-19765 : mount id string does not match mount id string in control file
  • ora-10638 : Index status is invalid
  • ora-32004 : obsolete and/or deprecated parameter(s) specified
  • ora-29506 : invalid query derived from USING clause
  • ora-32339 : cannot alter materialized view with the PMOP
  • ora-38744 : file string is not the same file seen at start of flashback
  • ora-01111 : name for data file string is unknown - rename to correct file
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-09314 : sltln: error translating logical name
  • ora-30968 : invalid XPATH or NAMESPACE option for XML Index
  • ora-25300 : Cannot drop buffer for queue with buffered subscribers
  • ora-25426 : remote instance does not support shared dblinks
  • ora-01515 : error dropping log group string: no such log
  • ora-22905 : cannot access rows from a non-nested table item
  • ora-23325 : parameter type is not string
  • ora-23536 : the object "string"."string" is not cached at the middle tier as expected.
  • ora-29323 : ALTER DATABASE SET COMPATIBILITY command not supported by string
  • ora-02216 : tablespace name expected
  • ora-23514 : invalid or incorrect number of arguments
  • ora-12900 : must specify a default temporary tablespace for a locally managed database
  • ora-01085 : preceding errors in deferred rpc to "string.string.string"
  • ora-02239 : there are objects which reference this sequence
  • ora-16177 : media recovery is not required
  • ora-12640 : Authentication adapter initialization failed
  • ora-32825 : Messaging Gateway agent has not been started
  • ora-07595 : sppid: $GETJPIW failure
  • ora-01341 : LogMiner out-of-memory
  • ora-24803 : illegal parameter value in lob read function
  • ora-01774 : Dump undo option specified more than once
  • ora-24057 : cannot define subscriber with rule for queue string
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    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.