ORA-08460: invalid environment clause in environment parameter

Cause : The environment parameter passed to a UTL_PG conversion routine contained an unsupported or invalid environment clause. Only the CURRENCY SIGN and the DECIMAL-POINT IS COMMA environment clauses are supported.

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

Correct the environment parameter.

update : 20-09-2017
ORA-08460

ORA-08460 - invalid environment clause in environment parameter
ORA-08460 - invalid environment clause in environment parameter

  • ora-30135 : OCI Thread operation fails
  • ora-01553 : MAXEXTENTS must be no smaller than the string extents currently allocated
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-00232 : snapshot control file is nonexistent, corrupt, or unreadable
  • ora-02269 : key column cannot be of LONG datatype
  • ora-06791 : TLI Driver: poll returned error event
  • ora-01601 : illegal bucket size in clause "string" of string
  • ora-10244 : make tranids in error msgs print as 0.0.0 (for testing)
  • ora-13442 : GeoRaster metadata SRS error
  • ora-32807 : message system link string already exists
  • ora-01681 : max # extents (string) reached in LOB segment in tablespace string
  • ora-30154 : The memory address given as buffer for OCIFileRead/Write is invalid
  • ora-13143 : invalid POLYGON window definition
  • ora-25290 : Cannot complete operation on queue string with existing messages
  • ora-19558 : error de-allocating device
  • ora-26091 : requested direct path operation not supported
  • ora-37082 : Invalid percent
  • ora-30563 : outer join operator (+) not allowed in select-list
  • ora-07281 : slsget: times error, unable to get cpu time.
  • ora-14644 : table is not subpartitioned by Hash method
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-22916 : cannot do an exact FETCH on a query with Nested cursors
  • ora-24234 : unable to get source of string "string"."string", insufficient privileges or does not exist
  • ora-13607 : The specified task or object string already exists
  • ora-24081 : compatible parameter needs to be string or greater
  • ora-31533 : only one change set (string) is allowed in change source
  • ora-32582 : table function with left correlation to a table cannot also be left outer-joined to the table
  • ora-24377 : invalid OCI function code
  • ora-39086 : cannot retrieve job information
  • ora-06912 : CMX: write error in datarq
  • 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.