ORA-23323: parameter length exceeds deferred RPC limits

Cause : A edferredr pcp armaetre wsa lnoge rthna teh dfeererd prc ilmist o f4000 btyesf orc ha/rvacrha2r praamteer san d2000 btyesf orr awp armaetres.

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

Us esmlale rpaarmeetrs.

update : 30-04-2017
ORA-23323

ORA-23323 - parameter length exceeds deferred RPC limits
ORA-23323 - parameter length exceeds deferred RPC limits

  • ora-24408 : could not generate unique server group name
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-26763 : invalid file type "string"
  • ora-28594 : agent control utility: invalid parameter name
  • ora-27474 : cannot give both an argument name and an argument position
  • ora-32127 : REFs do not belong to any connection
  • ora-01488 : invalid nibble or byte in the input data
  • ora-09240 : smpalo: error allocating PGA memory
  • ora-25962 : join index prevents multitable insert or merge
  • ora-19901 : database needs more recovery to create new incarnation
  • ora-25950 : missing where clause in join index specification
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-02094 : replication option not installed
  • ora-19914 : unable to encrypt backup
  • ora-09943 : Allocation of memory for password list component failed.
  • ora-30006 : resource busy; acquire with WAIT timeout expired
  • ora-19712 : table name exceeds maximum length of string
  • ora-25959 : join index must be of the bitmap type
  • ora-24120 : invalid string parameter passed to DBMS_REPAIR.string procedure
  • ora-19812 : cannot use string without DB_RECOVERY_FILE_DEST
  • ora-15030 : diskgroup name "string" is in use by another diskgroup
  • ora-24337 : statement handle not prepared
  • ora-31536 : cannot support encrypted column string in the source table
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-29380 : resource plan string is currently active and cannot be deleted
  • ora-29660 : Unable to find the class defined in the EXTERNAL NAME clause
  • ora-12598 : TNS:banner registration failed
  • ora-29826 : keyword FOR is missing
  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • 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.