Many Invalid Objects - Packages After TMS 4.5.2 Install - ORA-01119: error in creating database file 'E:\oradata\database\tms_data1.dbf' (Doc ID 1292764.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Thesaurus Management System - Version 4.5.2 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Aug-2012***
***Reviewed for currency: 03-Feb-2015***

Symptoms

Recently Installed TMS 4.5.2.

However, there were a lot of Invalid objects in the environment after install which will not compile.

On reviewing the installation log we see that the initial tablespace creation statement failed e.g.


Creating tablespaces...
running TMSCINTABLESPACES
Creating tablespace TMS_DATA
old 2: datafile '&&mountpoint1+tms_data1.dbf' size 100m
new 2: datafile 'E:\oradata\database\tms_data1.dbf' size 100m
create tablespace tms_data
*
ERROR at line 1:
ORA-01119: error in creating database file 'E:\oradata\database\tms_data1.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Creating tablespace TMS_IDX
old 2: datafile '&&mountpoint2+tms_idx1.dbf' size 100m
new 2: datafile 'E:\oradata\database\tms_idx1.dbf' size 100m
create tablespace tms_idx
*
ERROR at line 1:
ORA-01119: error in creating database file 'E:\oradata\database\tms_idx1.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.


Creating tablespace TMS_CLOB
old 1: create tablespace &&memos_tablespace_name
new 1: create tablespace TMS_CLOB
old 2: datafile '&&mountpoint1+tms_clob1.dbf' size 100m
new 2: datafile 'E:\oradata\database\tms_clob1.dbf' size 100m
create tablespace TMS_CLOB
*
ERROR at line 1:
ORA-01119: error in creating database file 'E:\oradata\database\tms_clob1.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.


finished TMSCINTABLESPACES

Changes

Upgrade to existing TMS 4.5.1 environment.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms