DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, December 29, 2017

ORA-01157: cannot identify/lock data file 201 - see DBWR trace file



Fix: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file


Issue:

If you are using XML in your database and you are trying to update any XML data, then above error may come.

Fix:

1) Add below line in your parameter file and bounce the database if not there.

*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODXDB)'

2) Unlock the XDB user if locked.

SQL> alter user XDB account unlock;


3) If you have created a duplicate database or open standby database r/w mode, then source TEMP tablespaces will no more valid. drop your TEMP tablespace and create new TEMP tablespace and make it default.

SQL> DROP TABLESPACE TEMP  INCLUDING CONTENTS AND DATAFILES;

SQL> create temporary tablespace TEMP02 tempfile '/u02/PROD/ORADATA/temp_02.dbf' size 1024M autoextend on;

SQL> alter database default temporary tablespace TEMP02;