Tuesday, October 7, 2008

ORA-32006

ORA-32006: %s initialization parameter has been deprecated

Cause: A deprecated parameter was specified at startup

Action: Consult Oracle documentation to find new parameters to use instead.

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-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


ORA-19905

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


ORA-19504

ORA-19504: failed to create file "string"

Cause: call to create file returned an error

Action: check additional messages, check access permissions

alert.log:
< Errors in file /oracle/admin/mydb/bdump/mydb_arc0_1604.trc:
< ORA-19504: failed to create file "/mydb/archivelogs/mydb_2085_1_633269081.dbf"

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-12913

ORA-12913: Cannot create dictionary managed tablespace

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