ORA-01121: cannot rename database file string - file is in use or recovery

Oracle error

ORA-01121: cannot rename database file string - file is in use or recovery

Cause: Attempted to use ALTER DATABASE RENAME to rename a datafile that is online in an open instance or is being recovered.

Action: Close database in all instances and end all recovery sessions.

See more oracle error here.

ORA-01120: cannot remove online database file string

Oracle error

ORA-01120: cannot remove online database file string

Cause: Attempting to drop a datafile when it is online

Action: Take file offline before dropping.

See more oracle error here.

Oracle error- ORA-00832: no streams pool created and cannot automatically create one

Oracle error

ORA-00832: no streams pool created and cannot automatically create one

Cause: A database feature which needs STREAMS SGA was being used, however, the streams_pool_size parameter was not defined and the value of db_cache_size was too small to permit an automatic transfer of SGA to the streams pool from the buffer cache.

Action: Please set the parameter streams_pool_size or set SGA_TARGET.

See more oracle error here.