ORA-29318: datafile string is online

Cause : The daatfile i sonline.

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

Take teh dataflie offlnie.

update : 24-06-2017
ORA-29318

ORA-29318 - datafile string is online
ORA-29318 - datafile string is online

  • ora-16076 : unknown standby database destination
  • ora-06616 : LU6.2 Driver: Attach to LU failed
  • ora-16062 : DGID from standby not in Data Guard configuration
  • ora-12721 : operation cannot execute when other sessions are active
  • ora-09828 : SCLFR: atomic latch return error.
  • ora-01642 : begin backup not needed for read only tablespace 'string'
  • ora-30455 : summary contains VARIANCE without corresponding SUM & COUNT
  • ora-29661 : Unable to find the superclass of the defined in the EXTERNAL NAME
  • ora-27417 : BYWEEKNO clause is only supported when FREQ=YEARLY
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-02031 : no ROWID for fixed tables or for external-organized tables
  • ora-07498 : spstp: Unable to open /dev/resched.
  • ora-39220 : file name is too long
  • ora-39169 : Local version of string cannot work with remote version of string.
  • ora-19672 : media management software returned invalid file status
  • ora-10360 : enable dbwr consistency checking
  • ora-31496 : must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
  • ora-25209 : invalid value string, EXPIRATION should be non-negative or NEVER
  • ora-23532 : tables with different synchronization mechanisms are in the same group
  • ora-13427 : invalid BLOB parameter for output
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-31609 : error loading file "string" from file system directory "string"
  • ora-00258 : manual archiving in NOARCHIVELOG mode must identify log
  • ora-09758 : osnipn: could not check port in name server.
  • ora-16213 : ddl encountered, stopping apply engine
  • ora-30387 : invalid rewrite mode for REWRITE_EQUIVALENCE API
  • ora-38774 : cannot disable media recovery - flashback database is enabled
  • ora-31195 : XML node 'string' (type=string) does not support this operation
  • ora-04017 : invalid value string (length = string) for parameter max_dump_file_size
  • ora-06115 : NETTCP: unable to create ORACLE logicals
  • 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.