My Oracle Support Banner

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 AUGUST 13, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.