Set up a friendly environment to share my understanding and ideas about Oracle / Oracle Spatial database administration, ESRI ArcSDE Geodatabase administration and UNIX (Solaris) operating system.
ORA-27040: file create error, unable to create file
Cause: create system call returned an error, unable to create file
Action: verify filename, and permissions
imp.log:
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "RBS" DATAFILE '/oracle_data/mydb/rbs01.dbf' "
"SIZE 1073741824 , '/oracle_data/mydb/rbs02.dbf' SIZE 536870"
"912 DEFAULT STORAGE(INITIAL 516096 NEXT 516096 MINEXTENTS 2 MAXEXTEN"
"TS 2147483645 PCTINCREASE 1) ONLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/oracle_data/mydb/rbs01.dbf'
ORA-27040: file create error, unable to create file
--------
ORA-28000: the account is locked
Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account
Action: Wait for PASSWORD_LOCK_TIME or contact DBA
[sde log] [05/07/2007 15:29:47;SdeId=0;Client=GIOMGR] Error (-51):Couldn't Start Server Task.
DB_open_instance()::db_connect (OCI8) error: 28000
CAN'T OPEN INSTANCE: idw10g.
Reason: the account is locked. Use Oracle Enterprise Manager to unlock the account.
All Oracle errors in the blog can be found at: Oracle errors All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors
ORA-19905: log_archive_format must contain %%s, %%t and %%r
Cause: log_archive_format is missing a mandatory format element. Starting with Oracle 10i, archived log file names must contain each of the elements %s(sequence), %t(thread), and %r(resetlogs id) to ensure that all archived log file names are unique.
Action: Add the missing format elements to log_archive_format.
All Oracle errors in the blog can be found at: Oracle errors All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors
Cause: Attemp to create dictionary managed tablespace in database which has system tablespace as locally managed
Action: Create a locally managed tablespace.
imp.log:
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "TEMP" DATAFILE '/oracle_data/mydb/temp02.dbf"
"' SIZE 1048576000 , '/oracle_data/mydb/temp01.dbf' SIZE 419"
"430400 , '/fs/u02/oracle_data/mydb/temp03.dbf' SIZE 419430400 "
" DEFAULT STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 214"
"7483645 PCTINCREASE 1) ONLINE TEMPORARY "
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
--------
ORA-13226: interface not supported without a spatial index
Cause: The geometry table does not have a spatial index.
Action: Verify that the geometry table referenced in the spatial operator has a spatial index on it.
All Oracle errors in the blog can be found at: Oracle errors All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors
I reserve the right to delete comments that are not contributing to the overall theme of the BLOG or are insulting or demeaning to anyone. The posts on this BLOG are provided "as is" with no warranties and confer no rights. The opinions expressed on this site are mine and mine alone, and do not necessarily represent those of my employer.