ORA-27103: internal error

Cause : inetrnla error

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

cotnac tOrcales upoprt

update : 27-06-2017
ORA-27103

ORA-27103 - internal error
ORA-27103 - internal error

  • ora-27472 : invalid metadata attribute string
  • ora-02454 : Number of hash keys per block (string) exceeds maximum of string
  • ora-04086 : trigger description too long, move comments into triggering code
  • ora-32035 : unreferenced query name defined in WITH clause
  • ora-09820 : Conversion of class string to numeric representation failed.
  • ora-07279 : spcre: semget error, unable to get first semaphore set.
  • ora-19631 : archivelog record contains no file name
  • ora-38603 : FI including & excluding cursor can only return one column
  • ora-00369 : Current log of thread string not useable and other log being cleared
  • ora-25181 : missing ON keyword for NESTED INDEX
  • ora-12534 : TNS:operation not supported
  • ora-21561 : OID generation failed
  • ora-38473 : cannot drop a type used for Expression Filter attribute set
  • ora-16140 : standby online logs have not been recovered
  • ora-00304 : requested INSTANCE_NUMBER is busy
  • ora-16097 : ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
  • ora-30001 : trim set should have only one character
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-06253 : NETNTT: cannot read arguments from address file
  • ora-37121 : AW Spreadsheet invalidated
  • ora-36954 : (XSFCAST24) The cycle number must be between 1 and number. You specified number.
  • ora-30683 : failure establishing connection to debugger
  • ora-19579 : archivelog record for string not found
  • ora-19019 : Invalid context passed to DBMS_XMLGEN.GETXML
  • ora-07627 : smsfre: $CRETVA failure
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-00911 : invalid character
  • ora-38754 : FLASHBACK DATABASE not started; required redo log is not available
  • ora-29657 : class defined in EXTERNAL NAME clause is used in another subtype
  • ora-29269 : HTTP server error 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.