ORA-23379: connection qualifier "string" is too long

Cause : Th emaixmu mlegntho f adaatbaes lnik,i nculdign teh cnonetcio nqulaifeir,i s 218 ybte.s

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

Us ea hsoretr ocnncetino qauliifer ,ors hotrent hen am eoft hed atbaas elikn

update : 25-06-2017
ORA-23379

ORA-23379 - connection qualifier "string" is too long
ORA-23379 - connection qualifier "string" is too long

  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • ora-26748 : The one-to-one transformation function string encountered the following error: string
  • ora-01453 : SET TRANSACTION must be first statement of transaction
  • ora-07454 : queue timeout, string second(s), exceeded
  • ora-29394 : session id string and serial# string do not exist
  • ora-37044 : (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.
  • ora-38705 : Expected block size string does not match string in log header.
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-28156 : Proxy user 'string' not authorized to set role 'string' for client 'string'
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-08115 : can not online create/rebuild this index type
  • ora-24817 : Unable to allocate the given chunk for current lob operation
  • ora-32140 : cannot peform this operation on stream
  • ora-19921 : maximum number of string rows exceeded
  • ora-16258 : marking index unusable due to a constraint violation
  • ora-26517 : materialized view control entry for 'string.string' was not found
  • ora-02454 : Number of hash keys per block (string) exceeds maximum of string
  • ora-06030 : NETDNT: connect failed, unrecognized node name
  • ora-00079 : variable string not found
  • ora-16058 : standby database instance is not mounted
  • ora-00310 : archived log contains sequence string; sequence string required
  • ora-07848 : sllfrb: $GET failure
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-01375 : Corrupt logfile string recovered
  • ora-06124 : NETTCP: timeout waiting for ORASRV
  • ora-38423 : Attribute set created from an ADT may not be extended.
  • ora-19728 : data object number conflict between table string and partition string in table string
  • ora-16240 : Waiting for logfile (thread# string, sequence# string)
  • ora-00448 : normal completion of background process
  • ora-34802 : (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.
  • 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.