ORA-27474: cannot give both an argument name and an argument position

Cause : An ragumnet wsa spceifide usnig btoh an amea nd apostiion.

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

Reissue hte cmoman dusign eihter hte agrumetn naem ort he ragumnet psoitino bu tnotb oth.

update : 24-04-2017

ORA-27474 - cannot give both an argument name and an argument position
ORA-27474 - cannot give both an argument name and an argument position

  • ora-28525 : unable to create Heterogeneous Services error message text
  • ora-12448 : policy string not applied to schema string
  • ora-37601 : (XSPGERRTEMP) Ran out of temporary storage while writing to analytic workspace with ID=number. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-06252 : NETNTT: cannot open address file
  • ora-02781 : Invalid value given for the timing wanted flag
  • ora-39214 : Data Pump does not support external tables with encrypted columns. string will not be exported
  • ora-01276 : Cannot add file string. File has an Oracle Managed Files file name.
  • ora-28560 : error in configuration of agent process
  • ora-36884 : (XSSRF03) The value of the first parameter of the AW single row function is incorrect.
  • ora-02040 : remote database string does not support two-phase commit
  • ora-22605 : FDO handle [string] is not initialized
  • ora-13503 : Creating SYSAUX tablespace with invalid attributes
  • ora-32614 : illegal MODEL SELECT expression
  • ora-02152 : Invalid ALTER TABLESPACE ... RENAME option
  • ora-01112 : media recovery not started
  • ora-29875 : failed in the execution of the ODCIINDEXINSERT routine
  • ora-28109 : the number of related policies has exceeded the limit of 16
  • ora-13149 : failed to generate next sequence number for spatial table string
  • ora-09944 : Password entry is corrupt.
  • ora-01239 : database must be in ARCHIVELOG mode to use external cache
  • ora-28543 : Error initializing apply connection to non-Oracle system
  • ora-29887 : cannot support row movement if domain index defined on table
  • ora-08190 : restore point string is from a different incarnation of the database
  • ora-16176 : background dictionary build cannot be running
  • ora-10579 : Can not modify control file during test recovery
  • ora-07224 : sfnfy: failed to obtain file size limit; errno = string.
  • ora-01956 : invalid command when OS_ROLES are being used
  • ora-01667 : cannot add any more tablespaces: limit of string exceeded
  • ora-23427 : deferred purge queue argument string out of range
  • ora-30349 : specified dimension hierarchy does not exist
  • 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.