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 : 26-06-2017

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

  • ora-30654 : missing DEFAULT keyword
  • ora-02313 : object type contains non-queryable type string attribute
  • ora-14138 : An unexpected error encountered during drop table operation
  • ora-31110 : Action failed as resource string is locked by name
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-09772 : osnpmetbrkmsg: message from host had incorrect message type
  • ora-12044 : invalid CREATE MATERIALIZED VIEW LOG option
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-12087 : online redefinition not allowed on tables owned by "string"
  • ora-37142 : (XSSQLMDQ02) Invalid host variable data type for MDQUERY procedure: string expected.
  • ora-24436 : Invalid statement Handle.
  • ora-38494 : column in the table alias and an attribute have matching names
  • ora-09858 : sfngat: the input file name is not in the OMF format
  • ora-02084 : database name is missing a component
  • ora-02077 : selects of long columns must be from co-located tables
  • ora-38764 : flashback not started; datafile string enabled threads are different
  • ora-02009 : the size specified for a file must not be zero
  • ora-31212 : DBMS_LDAP: PL/SQL - Invalid LDAP mod_array.
  • ora-02339 : invalid column specification
  • ora-38303 : invalid option for PURGE TABLESPACE
  • ora-37014 : (XSACQUIRE_ACQUIRED) Object workspace object is already acquired.
  • ora-24810 : attempting to write more data than indicated
  • ora-38483 : invalid FUNCTION/PACKAGE/TYPE name: "string"
  • ora-01650 : unable to extend rollback segment string by string in tablespace string
  • ora-15170 : cannot add entry 'string' in directory 'string'
  • ora-16796 : one or more properties could not be imported from the database
  • ora-26669 : parameter string inconsistent with parameter string
  • ora-07534 : scginq: $getlki unexpected return on lockid string
  • ora-22918 : specified column or attribute is not a VARRAY type
  • 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.