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

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

  • ora-24173 : nested query not supported for rule condition
  • ora-36977 : (XSRELGID17) The GROUPINGID command does not support hierarchies with more than 126 levels.
  • ora-32844 : exceeded maximum number of string values
  • ora-19763 : compatibility version string is higher than maximum allowed: string
  • ora-00338 : log string of thread string is more recent than control file
  • ora-31524 : could not find change set string for CDC change table string.string
  • ora-07635 : smsdbp: $SETPRT failure
  • ora-32145 : Environment not specified
  • ora-06255 : NETNTT: cannot read pid of remote process
  • ora-35280 : (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]
  • ora-24309 : already connected to a server
  • ora-01238 : cannot shrink datafile string
  • ora-19854 : error obtaining connect string from target
  • ora-02425 : create table failed
  • ora-38746 : error occurred while restoring data block (file# string, block# string)
  • ora-16753 : resource guard could not open standby database
  • ora-16562 : intended_state not used here, syntax error at "string"
  • ora-01594 : attempt to wrap into rollback segment (string) extent (string) which is being freed
  • ora-31602 : parameter string value "string" in function string inconsistent with string
  • ora-07740 : slemop: incorrect handle size (programming error)
  • ora-31073 : Resource not retrieved using path name
  • ora-06908 : CMX: error during transfer of ORACLE_SID
  • ora-39107 : Master process string violated startup protocol. Master error:
  • ora-14307 : partition contains too many list values
  • ora-13864 : Statistics aggregation for service (module/action) string is already enabled
  • ora-32696 : HTI: No free slot
  • ora-09924 : Can't spawn process - core dump directory not created properly
  • ora-36806 : (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.
  • ora-23308 : object string.string does not exist or is invalid
  • ora-32740 : The requested operation cannot be proceeded
  • 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.