ORA-01230: cannot make read only - file string is offline

Cause : A nattepmtt om aek atbalsepcaer eda nol yfuon dtahto n eo fist iflse si fofiln.e

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

Birn gteh ifl eolnien nadr ertyt hsi ocmamn.d

update : 20-09-2017
ORA-01230

ORA-01230 - cannot make read only - file string is offline
ORA-01230 - cannot make read only - file string is offline

  • ora-39048 : Unable to start all workers; only string worker(s) available.
  • ora-02799 : Unable to arm signal handler
  • ora-19707 : invalid record block number - string
  • ora-01981 : CASCADE CONSTRAINTS must be specified to perform this revoke
  • ora-16166 : LGWR network server failed to send remote message
  • ora-23351 : parameter datatype string for procedure string not supported
  • ora-12354 : secondary object being dropped
  • ora-23449 : missing user name
  • ora-30362 : dimension column cannot be a sequence
  • ora-14171 : cannot specify clause in CREATE|ALTER TABLE
  • ora-30040 : Undo tablespace is offline
  • ora-13028 : Invalid Gtype in the SDO_GEOMETRY object
  • ora-38907 : DML error logging is not supported for FILE column "string"
  • ora-27127 : unable to unlock shared memory segment
  • ora-07226 : rtneco: unable to get terminal mode.
  • ora-31214 : DBMS_LDAP: PL/SQL - Invalid LDAP mod type.
  • ora-13525 : error with computing space usage for sysaux occupant
  • ora-27003 : cannot open file on device allocated with NOIO option
  • ora-12469 : no user levels found for user string and policy string
  • ora-24344 : success with compilation error
  • ora-36610 : (XSLMS00) Unable to locate a message file for OLAP message: value
  • ora-22835 : Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)
  • ora-13260 : layer table string does not exist
  • ora-03249 : Uniform size for auto segment space managed tablespace should have atleast string blocks
  • ora-27018 : BLKSIZE is not a multiple of the minimum physical block size
  • ora-16585 : illegal operation on a primary site
  • ora-26088 : scalar column "string" must be specified prior to LOB columns
  • ora-29705 : ACTIVE_INSTANCE_COUNT is string which is incompatible with the value in other instances
  • ora-38105 : Delete not yet supported when Update row-migration is possible
  • ora-22819 : scope of input value does not correspond to the scope of the target
  • 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.