ORA-12197: TNS:keyword-value resolution error

Cause : Teh anvgiaito nlyae rrceevie da nerro rwihl etyrign ot olo ku pav aulef o rak ewyodr.

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

Cehc kteh ysnatxo ft h ecnoncetd ecsrpitro.

update : 20-07-2017
ORA-12197

ORA-12197 - TNS:keyword-value resolution error
ORA-12197 - TNS:keyword-value resolution error

  • ora-36270 : (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
  • ora-12547 : TNS:lost contact
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-16569 : Data Guard configuration is not enabled
  • ora-12994 : drop column option only allowed once in statement
  • ora-02447 : cannot defer a constraint that is not deferrable
  • ora-02344 : cannot revoke execute on a type with table dependents
  • ora-07270 : spalck: setitimer error, unable to set interval timer.
  • ora-32613 : not a MODEL cell
  • ora-02048 : attempt to begin distributed transaction without logging on
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-02804 : Allocation of memory failed for log file name
  • ora-12842 : Cursor invalidated during parallel execution
  • ora-00282 : UPI string call not supported, use ALTER DATABASE RECOVER
  • ora-33267 : (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it
  • ora-14620 : DEFAULT subpartition already exists
  • ora-33009 : (XSAGDNGLPREC) In AGGMAP workspace object, PRECOMPUTE may only be specified either for the entire AGGMAP or for individual RELATION statements.
  • ora-39029 : worker string with process name "string" prematurely terminated
  • ora-30739 : cannot drop a table that has subtables
  • ora-01970 : You must specify a database name for CREATE CONTROLFILE
  • ora-29554 : unhandled Java out of memory condition
  • ora-13485 : error occurred during compression or decompression: string
  • ora-38201 : assert if pin during flush
  • ora-01516 : nonexistent log file, datafile, or tempfile "string"
  • ora-27074 : unable to determine limit for open files
  • ora-15180 : Could not open dynamic library string, error [string]
  • ora-01597 : cannot alter system rollback segment online or offline
  • ora-19902 : incarnation key string not found
  • ora-13504 : No SYSAUX datafile clause specified
  • ora-19904 : test recovery not allowed for datafile 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.