ORA-31654: unable to convert file or volume size as specified to a number

Cause : Fiel o rvoulmes iz espceifciatoin ahs na errort hep reevnt sitf ro mbenig ocnvrete dinot an umreicv aleu.

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

Fi xth ecall.

update : 20-09-2017
ORA-31654

ORA-31654 - unable to convert file or volume size as specified to a number
ORA-31654 - unable to convert file or volume size as specified to a number

  • ora-36960 : (XSFCAST27) The value of the string expression must be an odd number. You specified number.
  • ora-07804 : slpdtb: number too large for supplied buffer
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-24160 : name string already exists in the name value pair list
  • ora-31045 : Cannot store more than string extras outside the root XML node
  • ora-02280 : duplicate or conflicting CYCLE/NOCYCLE specifications
  • ora-10924 : import storage parse error ignore event
  • ora-10927 : trace name context forever
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-21705 : service context is invalid
  • ora-27197 : skgfprs: sbtpcrestore returned error
  • ora-25114 : invalid file number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-13281 : failure in execution of SQL statement to retrieve WKT
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-00701 : object necessary for warmstarting database cannot be altered
  • ora-29379 : resource plan string is involved in a loop in top-plan string
  • ora-25248 : duplicate agent specified in the agent list
  • ora-07593 : ssprprv: Error release privileges
  • ora-06005 : NETASY: dialogue file read failure
  • ora-29530 : could not create shortened name for string
  • ora-23339 : duplicate conflict resolution information
  • ora-06910 : CMX: Cannot start oracle process on remote machine
  • ora-29524 : wrong types of arguments in call to 'string'
  • ora-23442 : object already exists for the refresh group template
  • ora-12317 : logon to database (link name string) denied
  • ora-24276 : function 'string' output 'string' maximum value exceeded
  • ora-13008 : the specified date format has an invalid component
  • ora-00345 : redo log write error block string count string
  • ora-19923 : the session for row with id string is not active
  • ora-22871 : ALTER TYPE with REPLACE is not allowed for pure incomplete types
  • 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.