ORA-27034: maximum length of ORACLE_SID exceeded

Cause : too mayn charatcers int he ORALCE_SID tsring

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

renamet he ORALCE_SID ot a strnig of u pto them aximumn umber fo charatcers spceified ofr yours ystem

update : 19-08-2017

ORA-27034 - maximum length of ORACLE_SID exceeded
ORA-27034 - maximum length of ORACLE_SID exceeded

  • ora-28117 : integrity constraint violated - parent record not found
  • ora-25207 : enqueue failed, queue string.string is disabled from enqueueing
  • ora-36612 : (XSLMS01) invalid OLAP message number: value
  • ora-12333 : database (link name string) is not mounted
  • ora-13355 : SDO_ORDINATE_ARRAY not grouped by number of dimensions specified
  • ora-38717 : Invalid DUMP FLASHBACK option.
  • ora-03275 : duplicate DEALLOCATE option specification
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-07267 : spwat: invalid process number.
  • ora-13350 : two or more rings of a complex polygon touch
  • ora-30344 : number of child cols different from number of parent level cols
  • ora-03244 : No free space found to place the control information
  • ora-32634 : automatic order MODEL evaluation does not converge
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-13182 : failed to read element string.string.string
  • ora-02358 : internal error fetching attribute string
  • ora-13854 : Tracing for service(module/action) string on instance string is not enabled
  • ora-06431 : ssaio: Invalid Block number
  • ora-12638 : Credential retrieval failed
  • ora-06905 : CMX: connect error
  • ora-23301 : mixed use of deferred rpc destination modes
  • ora-26532 : replication parallel push simulated site failure
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-25176 : storage specification not permitted for primary key
  • ora-30017 : segment 'string' is not supported in string Undo Management mode
  • ora-21615 : an OTS (named or simple) instance failed
  • ora-37141 : (XSSQLMDQ01) Invalid host variable syntax for MDQUERY procedure.
  • ora-16124 : transaction string string string is waiting on another transaction
  • ora-22927 : invalid LOB locator specified
  • 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.