Tuesday, October 7, 2008

ORA-27040

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


No comments:

Post a Comment