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 : 24-05-2017
ORA-27034

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

  • ora-12317 : logon to database (link name string) denied
  • ora-40251 : no support vectors were found
  • ora-25327 : Array size is invalid
  • ora-09281 : sllfop: error opening file
  • ora-13483 : insufficient memory for the specified GeoRaster data
  • ora-39040 : Schema expression "string" must identify exactly one schema.
  • ora-39200 : Link name "string" is invalid.
  • ora-12014 : table 'string' does not contain a primary key constraint
  • ora-22613 : buflen does not match the size of the scalar
  • ora-33214 : (CINSERT02) The workspace object dimension is too large.
  • ora-28165 : proxy 'string' may not specify password-protected role 'string' for client 'string'
  • ora-01102 : cannot mount database in EXCLUSIVE mode
  • ora-16136 : Managed Standby Recovery not active
  • ora-16535 : CRS is preventing execution of a broker operation
  • ora-29263 : HTTP protocol error
  • ora-16159 : Cannot change protected standby destination attributes
  • ora-19286 : XP0017 - unable to resolve call to function - string
  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-29362 : plan directive string, string does not exist
  • ora-12230 : TNS:Severe Network error occurred in making this connection
  • ora-01632 : max # extents (string) reached in index string.string
  • ora-26021 : index string.string partition string loaded successfully with string keys
  • ora-26045 : REF column string expects string arguments; found string.
  • ora-13157 : Oracle error ORAstring encountered while string
  • ora-13181 : unable to determine length of column string_SDOINDEX.SDO_CODE
  • ora-27000 : skgfqsbi: failed to initialize storage subsystem (SBT) layer
  • ora-24161 : name string does not exist in the name value pair list
  • ora-24754 : cannot start new transaction with an active transaction
  • ora-01704 : string literal too long
  • ora-02071 : error initializing capabilities for remote database 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.