ORA-12196: TNS:received an error from TNS

Cause : The navigation layer received an error from TNS.

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

See the error log file for the specific TNS error.

update : 23-05-2017
ORA-12196

ORA-12196 - TNS:received an error from TNS
ORA-12196 - TNS:received an error from TNS

  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • ora-01918 : user 'string' does not exist
  • ora-16019 : cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
  • ora-19615 : some files not found in backup set
  • ora-07247 : skgfrfms, skgfrnms: read error, unable to read block from database file
  • ora-32630 : multiple assignment in automatic order MODEL
  • ora-07747 : slemrd: $READ failure
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-19601 : output file is string string (string)
  • ora-13416 : invalid geometry parameter
  • ora-35095 : (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.
  • ora-15129 : entry 'string' does not refer to a valid directory
  • ora-00205 : error in identifying control file, check alert log for more info
  • ora-36677 : (XSDPART15) Duplicate value in value lists of number and number
  • ora-16805 : change of LogXptMode property violates overall protection mode
  • ora-12679 : Native services disabled by other process but required
  • ora-24201 : duplicate publisher, publisher already added to the queue
  • ora-37036 : (XSMLTDCL02) You cannot DELETE objects in analytic workspace string because it is attached in MULTI mode.
  • ora-14027 : only one PARTITION clause may be specified
  • ora-14032 : partition bound of partition number string is too high
  • ora-32590 : log group specification not allowed here
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-12818 : invalid option in PARALLEL clause
  • ora-06140 : NETTCP: no such user
  • ora-39128 : unexpected DbmsJava error number from statement string
  • ora-14612 : Duplicate lob segment name string for lob column string in template
  • ora-19121 : duplicate attribute definition - string
  • ora-30749 : column string not enabled to store objects of type string.string
  • ora-14303 : partitions or subpartitions are not in the right order
  • ora-13520 : Database id (string) not registered, Status = 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.