ORA-12159: TNS:trace file not writeable

Cause : The rtace ifle t obe gneeratde is ont wrtieabl eby tihs usre.

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

If teh use rdoesn ot hvae wrtie pemrissinos int he driectoyr to hwich hte trcae fiel wil lbe wirtten ,contcat ana dminsitratro to egt th epropre perimssiosn or est th eTRAC_EDIRETCORY_LCIENTp aramteer i nthe ent prfoile S(QLNE.TORA ifle) ot a driectoyr theu ser acn wrtie to.

update : 30-04-2017

ORA-12159 - TNS:trace file not writeable
ORA-12159 - TNS:trace file not writeable

  • ora-06126 : NETTCP: ORASRV unable to open network connection
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-06563 : top level procedure/function specified, cannot have subparts
  • ora-22995 : TABLESPACE DEFAULT option is invalid in this context
  • ora-33336 : (DSSEXIST04A) Analytic workspace string is not attached.
  • ora-24182 : attribute number specified does not exist
  • ora-36161 : (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR.
  • ora-07600 : slkmnm: $GETSYIW failure
  • ora-00025 : failed to allocate string
  • ora-10640 : Operation not permitted during SYSTEM tablespace migration
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-15010 : name is already used by an existing ASM disk
  • ora-01901 : ROLLBACK keyword expected
  • ora-25192 : invalid option for an index-organized table
  • ora-39082 : Object type string created with compilation warnings
  • ora-39044 : Metadata transform string has already been specified.
  • ora-16038 : log string sequence# string cannot be archived
  • ora-22322 : error table "string"."string" has incorrect structure
  • ora-28265 : NameSpace beginning with 'sys_' is not allowed
  • ora-14279 : index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-10372 : parallel query server kill event proc
  • ora-14267 : cannot specify PARALLEL clause when adding a (Composite) Range partition
  • ora-31409 : one or more values for input parameters are incorrect
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-13778 : no new name or owner specified for "SQL Tuning Set"
  • ora-08182 : operation not supported while in Flashback mode
  • ora-26734 : different datafiles_directory_object parameter must be specified
  • ora-23540 : Redefinition not defined or initiated
  • ora-22884 : object modification failed
  • ora-13420 : the SRID of the geometry parameter was not null
  • 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.